Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : MrETwtjYkKLNqNO7xtRl5h
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Update a User column i...
Power Apps - Microsoft Dataverse
Answered

Update a User column in data verse table using power automate

Like (0) ShareShare
ReportReport
Posted on 30 Mar 2023 13:33:21 by KrishR 431

Hello Everyone,

 

I did create a column in Data verse table for people picker. Below are the steps I followed.

 

1. Create a column and chose Lookup

2. Selected AAD user table for reference.

 

The point where I stuck is I cannot update this column, do I have to just give email address or is there any other way I'm missing. Can anyone please help me on how can I update this column with a user?

 

Thanks in advance!

Categories:
Microsoft Dataverse
  • KrishR Profile Picture
    KrishR 431 on 06 Jun 2024 at 20:04:54
    Re: Update a User column in data verse table using power automate

    Hi @toya0324 ,

     

    Yes it has been.

  • toya0324 Profile Picture
    toya0324 11 on 04 Jun 2024 at 23:38:05
    Re: Update a User column in data verse table using power automate

    @KrishR has this been resolved?

  • KrishR Profile Picture
    KrishR 431 on 03 Apr 2023 at 15:05:17
    Re: Update a User column in data verse table using power automate

    Hi @AhmedSalih ,

     

    Thanks for the response. Could you please help me with an example? Was unable to implement.

     

    Thank you so much again!

  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on 30 Mar 2023 at 14:08:05
    Re: Update a User column in data verse table using power automate

    Hello, @KrishR, to Update a Dataverse table LookUp Column in power automate, you muct use this expression in the Lookup Column Field: parentTableLogicalName(record_GUID)

     

    For more information, check my tutorial here. Check the update section: https://powerplatformplace.com/f/working-with-dataverse-lookup-choices-columns-in-power-automate?blogcategory=Dataverse

     

    If my reply helped you, please give a đź‘Ť  , & if it solved your issue, please give a đź‘Ť & 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

    Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

    New Project.png

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
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans