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 : eHCIqehK0jUVSnCgjkGsjT
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Migrate Person or Grou...
Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 4 Oct 2022 13:46:10 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:
Dataflows
Microsoft Dataverse
I have the same question (0)
  • MarceloPinhal Profile Picture
    MarceloPinhal 3 on 12 Jan 2024 at 14:32:20
    Re: Migrate Person or Group type data from SharePoint list to Dataverse table

    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.

  • xsomej33 Profile Picture
    xsomej33 on 09 Nov 2022 at 08:44:10
    Re: Migrate Person or Group type data from SharePoint list to Dataverse table

    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?

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on 09 Nov 2022 at 05:21:56
    Re: Migrate Person or Group type data from SharePoint list to Dataverse table

    @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


     

     

  • xsomej33 Profile Picture
    xsomej33 on 10 Oct 2022 at 09:02:44
    Re: Migrate Person or Group type data from SharePoint list to Dataverse table

    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?

    xsomej33_0-1665392556429.png

     

     

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on 04 Oct 2022 at 14:55:03
    Re: Migrate Person or Group type data from SharePoint list to Dataverse table

    Hello, @xsomej33,

     

    1. 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. 
    2. 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. 
    3. 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


     

     

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 936 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 375 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 330 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans