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:

Business Process Flows

All responses (2)

Answers (1)

DP-01101616-0 4 on at

Like (0)

Report

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

Hello...

Please see details below...

Raw output....
Verified answer

Michael E. Gernaey 43,266 Super User 2025 Season 1 on at

Like (1)

Report

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

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.