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!
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!