Power Automate cannot find Excel File

(1) Share

Report

Posted on by JKMyx

Hi,

So I've been trying for a while to create a Planner task from an excel file which is on Sharepoint...

But I run into trouble at the very start: when I need to select the "File" (before choosing the table), Powerautomate cannot find my excel file in the list... It does find all the folders of my Sharepoint though, but no files - see picture.

I already tried, without success:

- with other excel files in other folders, no result

- with other and same file in another location (One Drive Business or other), no result.

- when I use the Flow add-in the concerned excel file and I choose a random template,

automatically a filename is inserted in the "File Field", i.e. a weird long code: "01KO52QRSCPA7TF3NIG5...". But then when I try to choose the table, I get an error saying "Could not retrieve values. Bad Gateway. Client request id: '3FCE9437-1C99-402E-A5BA-AD18FB060867"

- see picture 2

Any ideas how to solve?

Would greatly appreciate, thanks!!

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@JKMyx please can you share screenshot of your flow?

Was this reply helpful? Yes No
JKMyx 6 on at

Like (0)

Report
Copy link

Link copied!

Issue to find excel fileIssue to load tables when using the Excel add-in
@jinivthakkar

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@JKMyx The table name (e.g. Table1) cannot be dynamic and it has to be hardcoded, if for your case you can make sure each excel you can have the table name fixed i.e. Table1 only then it makes sense to work on logic of getting the filename dynamically.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
JKMyx 6 on at

Like (0)

Report
Copy link

Link copied!

@jinivthakkar My table has a name in Excel (in the properties of the Table - see picture below)... but I'm not sure what you mean by hardcoded? What am I doing wrong?

Screenshot table name

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@JKMyx when I say hardcoded, no matter when or for which file you run the flow it will only extract data from Table1 only.

For e.g. for excel1 also it will read table1, excel2 it will read table1 and so on.

It can never work like excel1 table1, excel2 table2, excel3 table3.

Was this reply helpful? Yes No
jessebates 6 on at

Like (0)

Report
Copy link

Link copied!

The Excel file may be hidden. For some reason if the Excel file is hidden just like you would hide your PERSONAL workbook, power automate cannot see the tables.

Was this reply helpful? Yes No