Responsive PowerApp to scan data and post data to an Excel file

We would like to create a responsive PowerApp application to primarily work on a tablet, but responsive to also work on smaller mobile device screens.

We will have several devices around the factory, not all workstations will have a device. All posting to the same excel file (most likely a one drive business folder). This excel data will extracted and imported into our production software.

There must also be a separate screen to look up the data in that excel file (Search by works order reference number) this should show the most recent workstation/date/time this number was at.

App fields:

- Dropdown field: Select Workstation (which remains selected after submitting data)
- Input field: Works Order Reference Number (options to manually type, input by barcode, or PowerApps in-built camera scanner - with a button to open the PowerApps in-built scanner, of course)
- Date field (auto populates)
- Time field (auto populates)

Attached example data table in excel file (1st tab)
Attached list of current workstations (2nd tab)

Open to additional ideas too! Potential for more of the same work moving forward if happy with the quality and improvements will be needed over time.