Forum Discussion
Converting Access Web App data to Sharepoint List
Hello,
We've been using an Access Web App to track timesheet data through SharePoint online 2013. Now that the Access Web Apps are being retired, we are trying to migrate to PowerApps and use ...
Have you found a solution to your lookup fields not exporting?
Hi Jennifer. No, we did not. We wrote a PowerShell script to copy all Access tables (including lookup columns) to a new AZURE SQL Database, and built a new SPFx (SharePoint Framework) app from there.
- You wouldn't happen to have any written guidance on how you did this would you? I am trying to create a PowerApp, hoping it will work as needed.Just looking for any help i can get.Thank You for your response.Jen
There is no "cookbook" that I could find out there, but we knew what we wanted: (1) an AZURE SQL Server database, (2) an ODATA service, written in C# and using Entity Framework running as an Azure web app, and (3) SPFx pages hosted in SharePoint. We had to hire a local SharePoint developer to do the ODATA and SPFx part.
Jennifer Wentworth wrote:You wouldn't happen to have any written guidance on how you did this would you? I am trying to create a PowerApp, hoping it will work as needed.Just looking for any help i can get.Thank You for your response.Jen