Announcements
I am very confused about Dataverse. It is supposedly the preferred database for Power Apps. However I cannot import Excel files into a Dataverse Solution & Table, but I can import Excel files into a SharePoint list. Is it correct to use SharePoint lists as data for Power Apps? Also, does it mean I have to manually enter all my data into Dataverse tables to build a Model Driven apps?
@Evad - you can certainly import data into Dataverse using Excel and there is more than one way to do it.
https://powerapps.microsoft.com/en-us/blog/introducing-an-easier-than-ever-experience-to-import-data-from-excel/
https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Bulk-update-Dataverse-LookUp-column-using-Dynamics/ba-p/2300886
You can even bulk update Dataverse tables directly in Excel:
If you're organisation can afford the licencing fees, I would suggest Dataverse for your Power Apps. However, I have yet to come across a scenario in Dataverse that I have not been able to replicate using SharePoint Lists.
I have only two connector options on the New table from external data, Sharepoint or SQL server. My license probably doesn't support an Excel connector. I found a way around this, I create a SharePoint list from an Excel file, then I connect in Dataverse using the external Sharepoint connector. I just tested and it worked.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
