cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

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

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!

Highlighted
Frequent Visitor

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

 


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

Highlighted
Helper I
Helper I

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

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!!!

Highlighted
Regular Visitor

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

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!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,553)