You’re offline. This is a read only version of the page.
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.
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?
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.
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?
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:
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
