Unanswered

Dataverse or Sharepoint lists.

(0) Share

Report

Posted on by Evad

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
Tal22 259 on at

Like (0)

Report

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.

Was this reply helpful? Yes No