Forum Discussion
Converting Access Web App data to Sharepoint List
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
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
