web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse or Sharepoin...
Power Apps - Microsoft Dataverse
Unanswered

Dataverse or Sharepoint lists.

(0) ShareShare
ReportReport
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
I have the same question (0)
  • Ami K Profile Picture
    Ami K 15,674 Super User 2024 Season 1 on at
    Re: Dataverse or Sharepoint lists.

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

     

    Amik_0-1696629242192.png

     

    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.

  • Tal22 Profile Picture
    Tal22 259 on at
    Re: Dataverse or 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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans