Answered

Updating dataverse table row(s)

(0) Share

Report

Posted on by iskguy

402

I have the following flow. Filtering and getting the rows then creating an HTML table for an email works just fine. However when I get to UPDATING the row, it is adding a NEW row with the same data. I just want this to update one field - Record Status - from Pending to Final. What is wrong with my current syntax? Thanks

Is it because of the Row ID? I also tried the oData record ID and I get an error about it not being found.

Categories:

General topics

All responses (9)

Answers (1)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Using the first function in Update a Row can help. Here is a an article Power Automate / Dataverse: Get first result – Ben Prins
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response, but this only applies if I want to update one record, correct? I do want to update all of the rows found in the List Rows filter. And for some reason this process is ADDING a new row to Dataverse and not updating the row. The additional row does have the updated status that I need, but it leave the old row and creates a mess as then I have duplicate records with the same record ID.
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Oh in that case try only update the following columns (Leave the others blank)
Table Name
Row ID
Record Status

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried this too and still the same. I made sure that there is a key column in the table. I also deleted and recreated the flow and still the same. All I need to do is to update one field in a current record and it keeps adding a new row.
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you export your Flow (to a Zip) and attach it to this post I can try to replicate at my end.
iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

How do I attach a file here?
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies, Thought it could be attached. If you have a shared drive (e.g. OneDrive). Put it there and share link in post.
Verified answer

iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

I actually got it solved through the dataverse users group. My issue(s) were that I was using a test data table and not the table I should have been using, and also I need to reference the GUID ID of the row (specified in the field description) and not the primary key of the row.
Matt_Dahdouh 106 on at

Like
a
(0)

Report
Copy link

Link copied!

@iskguy can you please provide a link of where problem was solved?