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
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.
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.
Hi Alaa,
Thank you for your reply, and for the solution.
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