Migrate Person or Group type data from SharePoint list to Dataverse table

(0) Share

Report

Posted on by xsomej33

Hi all,

I have a SharePoint list which I'd like to migrate to Dataverse.

Part of the list is a column called Assigned To, which is a type Person or Group.

How can I migrate the data from the SP list to the Dataverse table and have the same functionality - being able to pick a user from the whole Azure Active Directory?

I thought of using the new virtual table MS created - AAD User - but for that I would need to create a new key, which is not possible in this table.

Any other ideas?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @xsomej33,

Dataverse doesn't have a Person Column as in SharePoint. You have to also include the User Information list which is a hidden list that exists in the root site of every SharePoint site collection. This list will have to be loaded into your Dataverse as well with your Table that has the Person Column.
If the user column doesn't represent a metadata about the record ownership and you only need for example the email address of the person(s) in that column, then once loading the data into Dataverse, you can use Power Automate and extract those emails.
Here is a post by @dpoggemann explaining User in Dataverse vs. Person Column in SharePoint for information of how users are handled in Dataverse: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/User-in-Dataverse-vs-Person-Column-in-SharePoint/td-p/1418211

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

xsomej33 on at

Like (0)

Report
Copy link

Link copied!

Hi @AhmedSalih,

Thanks for you answer. Can I use the Edit data in Excel option within the Dataverse table to simply copy/paste data from a text field to the lookup field, which is connected to the AAD User virtual table?

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@xsomej33, to migrate data with lookup columns configuration from Excel to Dataverse, follow my tutorial here: https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

xsomej33 on at

Like (0)

Report
Copy link

Link copied!

Hi @AhmedSalih,

Thanks for the link. I'm still struggling to make the person column working in Dataverse - I've used the method you suggested (get users from the hidden table in SharePoint) but I'd like to have this synchronized somehow (new joiners are not there for example). Any ideas how to do that?

Was this reply helpful? Yes No
MarceloPinhal 3 on at

Like (0)

Report
Copy link

Link copied!

Hello community!

Any news regarding this subject? I'm trying to migrate a people/person column from sharepoint to dataverse using dataflows and establish a many-to-one relationship with AAD Users table. However, since I can't create a key in AAD users, I'm unable to establish this relationship. Any ideas? Thank you so much in advance.

Was this reply helpful? Yes No