Power Platform Community Forum Thread Details

Hi there folks,

I am running into an issue in Flow where I am unable to reference a table that I had created in an existing excel file that I use for tracking projects.. The error is coming up as "Could not retrieve values. BadGateway". I have however created a brand new excel file with a table and Flow was able to complete the connection just fine.... That new excel file is saved in the exact same sharepoint folder as the existing excel tracker that I am trying to make this work in...

Flow Error.jpg

Might it have something to do with the settings of my existing excel tracker?... I cant seem to decern why I can make it work with a new file... but not with the existing file that I am trying to get it to work in..

Categories:

Using connectors

Hi @Jengel76,

Make sure the Excel table is defined in the specified Excel file, save the excel, close it, reopen the Flow, select it.

Most of the actions in the Excel connector can be used on the premise that the tables are pre-defined in Excel files before the related actions are configured.

Also, when specifying a file, you need to select a file from the file selector.

For more information about Excel connectors, please refer to the online documentation:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.