Forum Discussion
Converting Access Web App data to Sharepoint List
We are using PowerApps - exporting the database into Sharepoint Lists.
- Heiko WatzDec 06, 2017Iron Contributor
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?
- Malinda ChanyiJan 19, 2018Copper ContributorYes, 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.- Thomas AlexJan 19, 2018Copper Contributor
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.
- Thomas AlexJan 18, 2018Copper Contributor
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.
- Jennifer WentworthMay 03, 2018Copper Contributor
Have you found a solution to your lookup fields not exporting?