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!!
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.
@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.
@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
@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.
Issue to find excel file
Issue to load tables when using the Excel add-in