Hi,
I am writing this post, after I heard the really sad news that Access web app will be closed from next year. This is in my opinion a big mistake, as I believe AWA was the best product Microsoft released in last 10 years. However, not too much we can do, we need to look for an alternative, and Microsoft recomends Power Apps.
I have a fairly complex app which allowing office to dispatch jobs to emplyees outside on their iPads and employees just need to update information once the job is done and so office can e-mail to customers, take reports and analyze data through a desktop Access app.
Now, how can I achieve this in Power Apps, as I tried before and abandoned the project from a lot a reasons. As far I can see, Power Apps can't do more than update a spreadsheet through smartphone. No real support for relational databases, no macros, not even queries available. Even dropdown box is displaying only Record ID and need Lookup to diplay another information from specific record. Who cares Record ID??
So, basically what do I need to achieve:
-Need to be able to display information from multiple tables on same screen, update and save;
-Add a record to multiple tables from same screen;
-Email when a field was updated, with all the information regarding changes made by users;
-A lot of tables involved, many lookups and records;
I managed somehow to pass the heavy lifting to Access desktop app,and minimize tasks from mobile app, but I got the feeling that Power apps can't handle it.
I will probably use Azure SQL server as back-end, as I need to find a solution to move data from AWA.
Really I need your honest opinion on this matter, and I believe I am not the only one who got this questions and problems, after Microsoft give us this short notice on cancellation of AWA.
Thanks for reading my post, look forward to hear from you!
