Answered

Update rows from power automate

(0) Share

Report

Posted on by iskguy

402

I have a dataverse table that creates new rows from an incoming csv file that is scrubbed using power query. Included in the record is the RecordID (a guid which is the primary key column) and RecordStatus (which is set to "New"). This is all good. These New records are then part of a Power App where the end user will go through their data processing. Records from the processing are set to either Pending or Remove. Patching a single record for "Remove" does work and sets the RecordStatus to "Removed". The final process for the end user is to take the "Pending" records and finalize them. This button kicks of another Power Automate process, reads in any records marked "pending", creates a semi-beautiful HTML file and emails those that need to know. All good so far. However the final step of updating the Pending records to Final does not work. I am using the Update a Row process in power automate and trying to only update that record (there is an apply to all loop) and set the RecordStatus to Final. What it does is it CREATES a new record in the dataverse table. This I do not want so what I am doing is going in and manually updating the data and deleting those new rows.

Thanks for any information

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iskguy , would you please share a screenshot of your Power Automate flow where you have the Update Row action?

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Was this reply helpful? Yes No
iskguy 402 on at

Like (0)

Report
Copy link

Link copied!

Here it is

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iskguy , make sure that the RecordID is the GUID from the List Rows Action. Find the GUID column in the table you are using in the List Rows action.

Also, for the owners value, you have to use this expression:
/ownerid_type(ownerid_value)

Replace the ownerid_type with the value from the List Rows Action
Replace the ownerid_value with the value from the List Rows Action

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Was this reply helpful? Yes No
iskguy 402 on at

Like (0)

Report
Copy link

Link copied!

I have this option, but not finding a GUID for the row . And if I use the oData id, I get an error about the resource not being found.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@iskguy, Go to your Dataverse, Tables, fine your table and go to Columns, find the column with the Data Type "Unique Identifier" >> This should be the column you select for the ID value.

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,680 Moderator on at

Like (2)

Report
Copy link

Link copied!

@iskguy , it should have a text under it says Unique Identifier for entity instances:

Was this reply helpful? Yes No
iskguy 402 on at

Like (1)

Report
Copy link

Link copied!

Thanks and this works! Equally stupid of me though is I have TWO mirrored tables as one was being used for testing and I was referencing THAT table and not the current production table. Again, thanks for the help

Was this reply helpful? Yes No
Alan_N 3 on at

Like (0)

Report
Copy link

Link copied!

Worked for me also
Thanks

Was this reply helpful? Yes No