Please bear in mind that I am an end user not a developer (this is what Powerapps & Flow is all about right?!) We have a legacy MS Access LOB application that hasn’t been developed since Access 2000 days. However it runs in Access 2016 no problem and there are only a handful of users at this time. It’s pretty simple, being a client & case management app with a small amount of reporting. The main functionality is that it can write a record to a CSV file to create merged client letters & documents in Word. I need to retain this data merged document functionality but not necessarily in the same manner.
We are Office 365 subscribers and it’s time to modernise & start exploiting the data better + also explore workflow automation. So what would be the best way to store the data to build an app in Powerapps?
It appears as though I might be able to migrate the Access 2016 DB to an Access Web App, then make a SQL Server connection in Powerapps. I’m open to using CDM/CDS but not sure what the exact benefits would be, there also appears to be additional on going costs involved. The dataset isn’t exactly large so it might also be possible to use Sharepoint Lists or even and Excel Spreadsheet backend stored in Onedrive for Business. Any advice would be appreciated!
