Unanswered

Excel Update a Row action - "No row was found with ID..."

(2) Share

Report

Posted on by Buloke

I'm trying to accomplish a very simple task of updating the first row in a table in an Excel spreadsheet on a SharePoint Online site.

When I configure the connector, it Identifies the spreadsheet, table and the column to use to ID, but when it runs, it says, "No row was found with ID '1'."

This is the Excel table (Table1)

I tried using a Get Row action and it pulled the data back successfully. I have been going around and around with this with no luck.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

HI @Buloke,

Could you please make sure if the ID column in your excel table is set as General or Number type?

Ensure that the Key Value is set with the same type value with the ID column in your excel table.

If ID column is General, using string() function to convert 1 as a string value, if ID column is Number, using int() function to convert 1 as a integer.

Was this reply helpful? Yes No
tdr 10 on at

Like (0)

Report

I'm having this same problem and it's driving me crazy.

I have a small test table of 3 rows. I have an explicit "id" column with the values 1, 2, and 3. The id column is type "General".

I have a small flow that grabs all the rows, and tries to update each row with a bogus value. I'm getting error:

No row was found with Id '1'

I have tried setting the id to "Number" and the result is the same.

Here is my flow

I read the response from v-qiaqi@microsoft.com and I don't think I understand it. (I'm fairly new to power automate so maybe there's something I just don't get?)

Are you saying that in order to update a row the Key Value must be either String or Int and we must set that explicitly because Power Automate doesn't interpret the input from the spreadsheet as a String or Number?

Was this reply helpful? Yes No