cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Grossherzog
New Member

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

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

17 REPLIES 17
Anonymous
Not applicable

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!

 


@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.

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
Regular Visitor

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:
UpdateExcelRow.png
 

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

table.png

Hope it helps!

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

Anonymous
Not applicable

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

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

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,470)