troubleshooting Question

Access Web App or PowerApp

Avatar of Rob4077
Rob4077Flag for Australia asked on
Microsoft SharePointMicrosoft AccessPower BI
29 Comments1 Solution4555 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 1 Answer and 29 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 29 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros