Answered

How do I get the Row ID (GUID) for a Dataverse Table row that I want to update?

(2) Share

Report

Posted on by Karl_F

Hi,

I am building a flow that connects to a Dataverse table. The flow will be triggered when a new row is added, with this addition being done by a user who enters details via a Power App. When the new row is added some intermediary actions will be done in the flow that may or may not require updates being made to the newly added row.

To make these updates I choose the Dataverse 'Update a row' connector. However, the required entries for this connector are (1) 'Table name' (which I obviously have), and (2) 'Row ID' (GUID), of the row you want to update.

My question; how to I get/find the Row ID (GUID) of the newly added row that triggered the flow?

Thank you.

For reference: https://docs.microsoft.com/en-us/power-automate/dataverse/update

Categories:

Using connectors

I have the same question (4)

All responses (4)

Answers (1)

Verified answer

alaabitar 1,503 Super User 2024 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello,
Basically you can get it from the dynamic content of your trigger action. For example in this flow when an item is created in the Account table I am updating the Account table and the row id is the Account column.

Best regards,
Alaa

Was this reply helpful? Yes No
Karl_F 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Alaa,

Thank you for your reply, and for the solution.

Was this reply helpful? Yes No
fitzpjam 14 on at

Like (0)

Report
Copy link

Link copied!

How would this work for a Dataverse table that is not Accounts or a default list? I do not see a unique Identifier/GUID field that would work for this flow. my unique identifier field which is the auto generated field with a string prefix, ex: AB-1234, does not work.

Was this reply helpful? Yes No
jonathanmweaver 80 on at

Like (0)

Report
Copy link

Link copied!

In addition to the great information above, remember that in Dataverse when you use the List Rows action, you only get the Dynamic Values/column data for the columns you include in the Select Columns field. Then you can use the column data in subsequent actions.

Was this reply helpful? Yes No