Answered

Dataverse Update a row action error

(2) Share

Report

Posted on by SR-17041729-0

I am using Power Automate flow on Dataverse table within Power App to update a column value. The flow fails on Update a row action with following error:

error "code": "0x80060888", "message": "Bad Request - Error in query syntax."

I am also using plural table set name plural(GUID) but not entirely sure what GUID I need to refer

Categories:

Power Automate Mobile App

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

11manish 2,293 on at

Like (0)

Report
Copy link

Link copied!
The error is most likely caused by incorrect syntax in the Row ID field.

For the Dataverse Update a row action:

select the table normally

pass ONLY the Dataverse row GUID in Row ID

do not use pluralname(GUID) syntax there

Use the actual Dataverse primary key GUID of the record you want to update.

Was this reply helpful? Yes No
SR-17041729-0 10 on at

Like (1)

Report
Copy link

Link copied!

Question is where do I get Dataverse row GUID?

Was this reply helpful? Yes No
Suggested answer

Valantis 5,267 on at

Like (1)

Report
Copy link

Link copied!

Hi @SR-17041729-0,

The row GUID is the primary key of the record you want to update. A few ways to get it depending on how your flow is set up:
If you triggered the flow from Power Apps: pass the record ID from Power Apps to the flow as a parameter. In Power Apps use the formula YourFlow.Run(ThisItem.recordid_columnname) or for Dataverse tables specifically the primary key column is usually named after the table, like cr20b_yourtablename + "id".

If you're using a List rows action before the Update: add a List rows action to find the record first, then in the Apply to each loop use the primary key column from the output. The primary key column in the List rows output is usually the table logical name + "id" e.g. for a table called cr20b_orders it would be cr20b_ordersid.

If you're in the Dataverse table in make.powerapps.com: open the table, open a record, and look at the URL. The GUID is in the URL after etn= and id= parameters.

The quickest way to find the exact column name: go to make.powerapps.com > Tables > your table > Columns, filter by Primary Key, and that's the column name to use.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
David_MA 14,614 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

How you get the Row ID will depend on what you're doing in your flow, but here is one example which is to update the approval if the approval times out:

In this scenario, the Row ID is the Approval ID from the Create an approval action. If you have an add a row action earlier in your flow, look for a value in the dynamic values of your flow under that action for Row ID or something similar with and ID value.

Was this reply helpful? Yes No
Verified answer

Haque 3,202 on at

Like (1)

Report
Copy link

Link copied!

In Power Apps:

When you work with a record (e.g., from a gallery or form), the record’s GUID is usually available as the primary key field of the table, often named like TableNameid or recordid. For example, if your table is Accounts, the GUID field might be AccountId. We can access it in formulas like ThisItem.AccountId or from the selected record. Also, we can pass this GUID as a parameter to Power Automate flows or use it in your app logic.

In Power Automate:

If your flow is triggered by a Dataverse trigger like When a row is added, modified, or deleted, the trigger outputs include the Row ID as dynamic content. This Row ID is the GUID of the record that triggered the flow. If you retrieve rows using List rows action, each item in the output will have a GUID field (usually the primary key) we can use. Use this GUID value in the Update a row action’s Row ID field to specify which record to update.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No