Excel cloud "update a row" failing: No row was found with Id...

(1) Share

Report

Posted on by DP-01101616-0

Using a cloud flow to update an the last three columns of a the last row of an exisitng excel spreadsheet.

The flow fails in the last action 'update a row' w/ the error:

"No row was found with Id '{"Id":"24"}'..."

Using the Id column as the UID to locate the last row of the table, as well as the actions Select and Compose last(body('Select')) to pass the last row's Id to the update a row action, however, the flow fails to find the Id to update.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi

1. please share your Select statement (opened) so I can see what you are doing.

2. please go into your run. Look at the output of the Select

I am positive that your id is not at the top level as you have it, and thats why.

Was this reply helpful? Yes No
DP-01101616-0 4 on at

Like (0)

Report

Hello...

Please see details below...

Raw output....

Was this reply helpful? Yes No