Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(2) ShareShare
ReportReport
Posted on by 18

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

  • jonathanmweaver Profile Picture
    jonathanmweaver 80 on at
    Re: How do I get the Row ID (GUID) for a Dataverse Table row that I want to 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.

    jonathanmweaver_0-1715201358476.png

     

  • fitzpjam Profile Picture
    fitzpjam 14 on at
    Re: How do I get the Row ID (GUID) for a Dataverse Table row that I want to update?

    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.

  • Karl_F Profile Picture
    Karl_F 18 on at
    Re: How do I get the Row ID (GUID) for a Dataverse Table row that I want to update?

    Hi Alaa,

     

    Thank you for your reply, and for the solution.

  • Verified answer
    alaabitar Profile Picture
    alaabitar 1,503 on at
    Re: How do I get the Row ID (GUID) for a Dataverse Table row that I want to update?

    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.

    alaabitar_0-1658931673614.png

     

    Best regards,

    Alaa

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics