cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TiempoKZ
Regular Visitor

FLOW EXCEL Could not retrieve values. Bad Gateway

Hello everybody,

I have an isue with "List rows present in a table" action.flow.JPG

I roughly understand what the problem is
The general idea is that text will be writen into the excel file using the "update row" function and based on this text an image will be selected
I implemented this functionality in the excel file using the "name manager" and the "INDIRECT" function in excel (as described here: Example on YouTube

If I remove the function "indirect" then the tables in flow are defined, but if I return it is not

I dont know other ways how to make it or how to fix

plz help 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @TiempoKZ ,

 

The "INDIRECT" function in excel is not supported in microsoft flow currently, so please remove the "INDIRECT" function in excel if you would like to read data from the excel table with microsoft flow.

 

Best regards,

Alice       

 

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

 

 

View solution in original post

4 REPLIES 4

Hey @TiempoKZ 

 

Can you confirm that you have selected the excel file by clicking the folder icon in the right side on the File attribute in the action? 

 

This is a current limitation with the excel connector that you need to point to that file by selecting the folder icon and navigating to the file and then selecting it from there. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anda have same return error

 

Get tables

 

And as I said, if I remove function "INDIRECT" from my excel file then excel online can read my file

 

Hi @TiempoKZ ,

 

The "INDIRECT" function in excel is not supported in microsoft flow currently, so please remove the "INDIRECT" function in excel if you would like to read data from the excel table with microsoft flow.

 

Best regards,

Alice       

 

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

 

 

RaySCook
New Member

I have this same issue with a flow I have been working on for some time. For some reason, it now will give me the "Bad Gateway" error when trying to select a table from the drop down menu. It was working fine yesterday and I haven't made any changes to the spreadsheet (besides tables auto refreshing data from external data sources) or the flow. Now all calls to that specific spreadsheet (and copies of it that I made and put into different paths to determine if the file is the root of the problem) give the same error. 

 

I created a new spreadsheet with a small table in the same directory. The flow functions work fine for that spreadsheet. It is very confusing.

 

There is a ton of logic and data sources in the existing spreadsheet, so I am hesitant to create it again from scratch.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,150)