updating lookup field via Power Automate

(1) Share

Report

Posted on by MS-03020640-0

Hi Everyone,

I have two tables 1. Requestors table and 2. Approvers Table with a one to many relationship.

Every time a user raises a request, a new Use case ID is assigned to it and on that basis a new row is added in the Approvers Table with that Use case ID via power automate workflow.

I want a field in the Approver's table to automatically create a link to the lookup value of the Requestors table (use case id). Without this, I am not able to show the updates in the Review Status (pending, approved, rejected) in Requestor's table as and when the Approver inputs the details and approves or rejects it by updating the Review status field in its own table.

I am not able to work out the Power automate steps to make this happen which results in the approver manually tagging the Use Case ID in the Approver's table to make sure the requestor is able to view the updates done by the approver on his request.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

If you want to update a lookup column in Power Automate with the Dataverse connector, you need to set the column value as :

/table_name_in_plurial/record_id

So, you need to retrieve the record ID of the approver with maybe previous steps

Regards,

Was this reply helpful? Yes No
Kalathiya 1,680 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @MS-03020640-0,

When you want to automatically link a record in Approvers Table to a Requestor record, you need to populate the lookup column with the table set name + GUID like this:

RequestorsTableSetName(GUID)

#1. RequestorsTableSetName → You can get this from Table Tools → Copy Table Set Name in Power Apps.

#2. GUID → This is the dynamic ID of the Requestor record (from your trigger in Power Automate).

This will link the new Approver row to the correct Requestor.

Reference Link:

https://www.matthewdevaney.com/power-automate-update-a-lookup-column-in-dataverse/

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,714 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @MS-03020640-0

You can give a try like

plurallogicalnames(contacts)/Guid

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No