Update Row in Excel doesn't find any tables (Microsoft Flow)

[Grossherzog]

Hello,

I like to update an excel row as the result of a twitter search. (Microsoft Flow)

When I choose the correct excel file from my onedrive  I get the message "No items" when I want to choose an excel table.

I have two tabs in the excel sheet. In one tab I have named the rows on the top.

What could be wrong? I have no idea.

Or what do they mean with excel table? Isn't a tab meant?

Thanks

Nico

[Anonymous]

Don't worry, no one here really knows what they're doing. It's a mix of people who want actual solutions and people who want that MVP badge!

[AdamW]

---

@McRoe wrote:

I'm constantly getting the next error message and can't find anything on the internet about it:

"Could not retrieve values. Failed to get dynamic values"

---

My worksheet contains a spin button and that is what is causing the error.  When I remove the spin button Flow is able to find the table.

Any way around this you think?  I need the spin button.

[beargal34]

Converting the excel table to range actually worked for the issue I was having. Issue was that the Flow would run successfully, but the SP item wouldn't get added to the Excel table. After I changed this around, the items are now being added! Yay!!! Thanks!!!

[nick_boiko]

I've spent a half of the day fighting with Excel Update row action error "No table was found with the name 'Ratings'".

So, it finally works for me now. 

Answer: Excel Online Update row action Table parameter expects not a name but id, like here:

"id": "{00000000-000C-0000-FFFF-FFFF00000000}".

You can find the id using action Get Tables, wich will return json

    "@odata.id": "/drivesknxjuxbcbcb,

    "style": "TableStyleMedium2",

    "name": "Ratings",

    "showFilterButton": true,

    "id": "{00000000-000C-0000-FFFF-FFFF00000000}",

    "highlightLastColumn": false,

    "highlightFirstColumn": false,

    "legacyId": "1",

    "showBandedColumns": false,

    "showBandedRows": true,

    "showHeaders": true,

    "showTotals": false

then you can enter (or dynamically input) the id in Update row Table:

To insert a Table id choose Custom value and do so:

Hope it helps!

[MichaRPA]

Thank you very much, this was the easy way. I thought about it, but didn't try it before googleing.

[Anonymous]

Hi, I'm having this issue right now, did you solve it?

[Rosy]

If the table doesn't appear, delete the step within Automate and then reinsert it. The dropdown should update.

[openritwanz]

thanks this is works for me. 👍
don't forget to copy the link and paste into location or document library.