Answered

Power Automate for Dataverse - updating a row

(0) Share

Report

Posted on by karenperry

Hello,
I am trying to make a power automate flow, triggered when a specific column in a dataverse table is updated. When this is updated, if it meets the condition, I want it to update a column (choice column) within that row. My issue is that I am not sure what my row ID should be in the update row action. In other similar flows there has been an option in dynamic content to add a "unique identifier for entity instances" however I do not have that option in this case. only this:

which I assume would show IDs for all rows.

I've screenshotted the flow below for reference. Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

You would look at the structure of your table to see what field has the unique identifier and ends with Id:

This is provided that the table Projects is the same table in the update a row action. Otherwise, you would need to know what field the two are joined on.

Was this reply helpful? Yes No
karenperry 24 on at

Like (0)

Report

Hi David,

Thanks for getting back. I tried that, filling "row ID" with the name of the unique identifier field but got an error. Any suggestions?

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

In addition to the error, you need to post how you configured the action so folks can see what you did.

Was this reply helpful? Yes No
karenperry 24 on at

Like (0)

Report

Sorry, see below what I'd entered into the update a row action. 'msdyn-projectid' is the logical name for the column. Other actions are as noted in the original post.

Was this reply helpful? Yes No
Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

You would not type in any data in the Row ID field unless you know the actual row ID, which would be in this format: 755e1e9e-6549-4e42-a6ba-cdeb58bbfda9. Go to the table in Dataverse and open it. Under schema, click on columns. Then look for the column that has ID next to the name and is of the type Unique identifier.

You would use this value from the dynamic values in the row ID of the update row action.

Was this reply helpful? Yes No
karenperry 24 on at

Like (0)

Report

Thank you! I have now done this and I'm not getting errors in the flow, however, I seem to be getting an infinite loop as the flow continues to trigger. For reference, through the flow, a column "cost" is updated based on the condition within the flow. Does the trigger condition need updated to prevent this infinite loop? In my understanding, the trigger should only apply when there are changes to the named column in the "select columns" field (schedule variance, not cost)? Can you see an error in how I've completed this?

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

The infinite loop makes sense since your trigger is when a row is added or updated and you then go and update the row in your flow. You'll need to add a trigger condition to your flow to prevent the infinite loop. However, I have never done this with a Dataverse table. You can read about this at How to avoid infinite trigger loop in Power Automate.

You may be able to add this as a trigger: @not(equals(triggerOutputs()?['body/_modifiedby_value'], 'YOUR_USER_ID')). You can get your user ID with a Get user profile action. With SharePoint it is easier as I could just write a trigger for where the modified by email address is not equal to the flow owner email address, which is one of the examples in the above link.

Was this reply helpful? Yes No
karenperry 24 on at

Like (0)

Report

Thank you! I too dont have much experience in working with dataverse. I perhaps wrongly assumed that by adding a column in to the trigger action, that this would essentially be the trigger condition. I'll look into this. Thanks for your help.

Was this reply helpful? Yes No