We use an MS Access based system in our office to manage most work functions with the backend stored on a local server . We now have a need to make a small subset (about 500-600 records in a single table) available to field personnel to enable them to look up details, record when jobs are completed and make brief comments.
PowerApps. I could use MS Access to keep a spreadsheet up to date and read user inputs to that spreadsheet but is SharePoint "smart enough" to update just the updated record or does it replace the entire spreadsheet every time the spreadsheet is updated.
Access Web Apps. These use a SQL Azure database on the SharePoint server and can be linked to MS Access. It seems like this would be a more efficient solution but perhaps opportunities to increase features over time may be more limited.
My question is: Am I making the right choice - a web app instead of a PowerApp, or is there something about PowerApps that make them a better choice for my application?