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?
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!
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!!!
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:
To insert a Table id choose Custom value and do so:
Hope it helps!
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!