Update a User column in data verse table using power automate

(0) Share

Report

Posted on 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 with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

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

Was this reply helpful? Yes No

KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @AhmedSalih ,

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

Thank you so much again!

Was this reply helpful? Yes No
toya0324 11 on at

Like (0)

Report
Copy link

Link copied!

@KrishR has this been resolved?

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @toya0324 ,

Yes it has been.

Was this reply helpful? Yes No