Forum Discussion
Converting Access Web App data to Sharepoint List
We are also using access apps.
But in my tenant I have an option to export my application to a set of SharePoint lists:
It creates a subsite with a few lists.
Do you have this option also?
All, I also have an Access Web App. I have the Export to SharePoint lists option that Heiko mentioned:
It works for me. However, the resulting lists do not have Lookup columns, which is causing me to rethink using lists.
Have you found a solution to your lookup fields not exporting?
We never got SharePoint lists to work. We ended up converting data to Excel and building an app in PowerApps. We are almost there, but some weird stuff happening between Excel data and PowerApps - specifically dates. PowerApps is stuck on UTC time zone, we are Mountain, so dates aren't displaying correctly. Still trying to find a work around.
How did you retain your "relationships" using excel? It's looking like this is the path I'm going to have to take.
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
