Unanswered

Migrating Sharepoint List to Dataverse Table (Lookup Columns aren't showing)

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello I'm an Intern who is tasked to Migrate Data from Sharepoint Online List to Dataverse Table. I set up all the Lookup columns from Dataverse Table. but for some reason when I was doing Data Flow at the Column Mapping Step, all the Lookup columns that I set up from Dataverse Tables aren't showing on the list. at the same time the Lookup Columns from Sharepoint Online List aren't showing on the source column list.

What do I do am I missing something or I should do something for the Lookup Columns to show up. Early Replies will be much appreciated so I can finish this.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous，

Actually, Dataflow could not map complex columns like LookUp type.

We could only achieve this by combining with Power Automate.

Here is a detailed video talking about how to migrate SharePoint data to Dataverse table including LookUp column:

Migrate SharePoint Data To Dataverse - Part 2 - YouTube

What's more, the following blog could help you learn more about this migration thing between SharePoint and Dataverse:

Transforming your important/critical PowerApps App Data-Source from SharePoint to Dataverse - European SharePoint, Office 365 & Azure Conference, 2023 (sharepointeurope.com)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

so for every table I have to create a Power Automate flow for it? how would it work since I want to migrate it along side the lookup columns (since data flow isn't working for it) Do I have to like call the related table to it first or set out those tables first in the dataverse?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Actually, you still need to use the Dataflow to finish part of things.

Assuming you have a Department as the LookUp field in your SP list.

For Lookup field with single value, make sure to pick the field containing the ID as string in this scenario departmentid and not the field that returns data type as table (Departments), you will need this later to properly setup One-Many relationship between tables in Dataverse

If you don't have Dataverse table, well, under load setting selected Load to new table, and specify new table name. of course if you had created the tables previously you can select Load to existing table.

All of the above info is mentioned in the blog I attached in my previous reply.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

so first I have to migrate those lookup tables on the dataverse and then do what's in the video? am I getting this right? so all in all whats like the steps, Powerautomate and Dataflow at the same time or like Power Automate First and then Data flow?

Was this reply helpful? Yes No