Dataverse file not found when trying to update a row in flow

[rhaddad87]

Hello,
I have this part of a flow that keeps kicking back a 404 file not found error when it is indeed finding the intended dataverse row.  What am I doing wrong?  What do I need to change?  I also tried using the OData Row ID value as well but that returns the same error.

[shoog]

In the Row ID property of the Update row action, there should only be the ID (from the dynamic content of the List rows action), so you should remove the "crb41__id eq" part and the quotes here.

This action works different than the list rows action in that you point it to one record, rather than supply a filter query to match records.

[rhaddad87]

Thank you for your reply!  I changed it to ID and received the following error:

  "message": "Bad Request - Error in query syntax."

Screen shot below.. any idea?

Troubleshooting screenshot to help:

Thank you!

[shoog · Accepted solution]

The last screenshot shows the value being passed is a number field (79) rather than a GUID (like 000000000-0000-0000-0000-0000000000000), so this is not the right column to use.

Usually the correct column will have the name <prefix>_<tablename>id

Prefix will be crb41 judging from the screenshots, so something like crb41_mytableid if the tablename would be mytable.

[rhaddad87]

YESSSS THANK YOU SO MUCH, @shoog !!!!  I feel so silly referencing the wrong row ID haha.  You are awesome!  Thank you!!!