Bug? Get Row / Update row does not find the key values

[Valerio_]

Hello,

I'm doing a small test as I'm having an issue with a bigger task.

I'm trying to update or get a row in an excel file that sits on sharepoint the table looks like below:

If I use get rows on the table I get the following results: 

the rows exist, and the store numbers are listed, the other headers do not have values.

Now if I try to use get row or update row I get always this message that there is no row with ID (key-value?) 6001, what I'm doing wrong?

The whole flow: 

[jinivthakkar]

@Valerio_ here is what i tried

my excel 

Excel updated

Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[jinivthakkar]

@Valerio_ get a row action:

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Valerio_]

Hi Jinivthakkar, I've tried using the file in onedrive as well but I get the same error.. 😞

[jinivthakkar]

@Valerio_ ohh I see, may be then its a temporary issue, try after sometime or raise a ticket with Microsoft.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[alldayrr]

@Valerio_ Did you ever get it to work? I couldn't get mine to work.

[Daiye]

Hi, @Valerio_ and the rest of you!

I had problems with updating a row as well, got it to work. I had two different tables created in Excel, one was working the other was not.

Short answer: Name your table columns starting with letters and the error is not related to your key column, but the whole table. 

Long answer: 

I concluded that the way the actual tables in Excel were created did not matter. Thought it might be a bug from Excel depending on how the table was created. Can be created by:

1. Creating a table from table/table range.

2. Creating a table by inserting a table.

(Also tried some other far fetched theories in Excel here)

I concluded that it had nothing to do with the data in the table as my two tables had the same data in the tables (again, one was working and the other one wasn't). 

I concluded that integers in the key-column do not matter.

Integers stored as general/text/number works fine:

All my values in the key column were numbers. I then tried changed the cell settings on the table where it was working to all three, all were fine.

I then tried changing the name of my columns. Note that column A (ManagerId) is the key column.

From this:

(No updates in the table here as PA crashed. I was trying to populate columns ManagerName,1,2,3 and 4)

To this:

(Data is updated in columns)

When I got it to work using letters to start my column names...

Update successful:

...I changed the columns back to numbers within the exact same table it crashed again. I had made no other differences to Power Automate, Excel, table in Excel or the data in the table.