Forum Discussion
Converting Access Web App data to Sharepoint List
We are using PowerApps - exporting the database into Sharepoint Lists.
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?
- Yes, but the access database is too large to export into Lists. It hangs up for 3 days, and there is no abort option. We eventually had to put the data into Excel and managed to import it into Power APPs that way.
Microsoft should NOT be retiring Access Web Apps.Malinda,
My Access DB is pretty small, so I'm going to try to use lists. However, I have noticed the Export tool doesn't handle Lookup columns properly. Again, my DB is small enough, so I'm going to try and fix that up with PowerShell. Best of luck to you.
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?
