Can't load a Table from Excel spreadsheet (.xlsx file)?

(0) Share

Report

Posted on by ahmadbutt

255

Error: Could not retrieve values. BadGateway.

See the Yellow marked areas. In the Excel file, it says it is a table called: 'Tabel1'. The table range is B8 to I9. If I only select the yellow marked area and delete the other values/tables then I can load the table (Tabel1), but is there a way to get 'Tabel1' from the Excel file as shown in the picture or do I need to delete all the other things to let it work?

I hope someone can help me out.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @ahmadbutt ,

I have made a test on my side and I'm afraid that you need to delete all the other things in the spreadsheet if you want to get the table in the spreadsheet 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.

Was this reply helpful? Yes No
ahmadbutt 255 on at

Like (0)

Report

If you are sure about this then I will accept it as a solution...?

Was this reply helpful? Yes No