Importing a SharePoint list to an existing Dataverse table

Like (0) Share

Report

Posted on 25 Mar 2025 12:20:32 by RW-18021048-0

I have a sharepoint list in a teams sharepoint site and I want to create a Dataverse Table in order to use Power Apps to provide a better UI

I can find the list and see the data in power query but when i set the load parameter and select next it just wont import the columns

Any ideas why it doesn't work would be welcome

Regards

Roger

Categories:

Microsoft Dataverse

All responses (3)

Answers (0)

MS.Ragavendar 1,062 on 28 Mar 2025 at 09:10:52

Like (0)

Report
Importing a SharePoint list to an existing Dataverse table

@RW-18021048-0,

It sounds like you have a solid reason for moving from SharePoint to Dataverse, given the complexity of managing serial numbers, stock updates, and payment tracking across multiple locations.

Possible Reasons & Fixes

If the column types in SharePoint don’t map properly to Dataverse, Power Query might struggle to load them.

Certain column types (e.g., Person, Lookup, Multi-select Choice) do not transfer smoothly, import this data manually once the actual migration is completed.

If the Dataverse connection is not properly authenticated, Power Query might pull data but fail to insert it into Dataverse.
RW-18021048-0 2 on 25 Mar 2025 at 14:12:29

Like (0)

Report

Importing a SharePoint list to an existing Dataverse table

Hi

Its not quite that simple the app is to collect stock and payment data from the point of sale so will be forms based. The stock has to be decremented each time a sale is made and the stock is serial numbered. We need to manage over 40 serial number series in 27 locations. The end user must issue the next serial in the series and record the quantity, type and description of the payments taken.

This has proved to be too complex for sharepoint and also the calculations need a better range of functions, so we plan to build the forms in power apps and store the considerable data in dataverse.

I cant import from either sharepoint or excel - everything works up to the point of getting the data in to power query but the data never occurs in the tables - either new or existing.
Suggested answer

MS.Ragavendar 1,062 on 25 Mar 2025 at 13:44:00

Like (0)

Report
Importing a SharePoint list to an existing Dataverse table

@RW-18021048-0,

What is the reason that you want to migrate the data from SharePoint to Dataverse ?

For Powerapps you can also use sharepoint as a datasource too, If you used dataverse it need premium license for all the users who using the powerapps.

There is no linkage between the data source for the UI design.

If you have any queries revert me back. We can circle back again.

However with respect to your query please find the below links

https://www.youtube.com/watch?v=g3HnyQmvkRw

https://community.dynamics.com/blogs/post/?postid=0b2a9f23-74b5-4c81-a512-42439f225c9e

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Community site session details

Importing a SharePoint list to an existing Dataverse table

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Importing a SharePoint list to an existing Dataverse table

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates