Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Power Automate cannot find Excel File

(1) ShareShare
ReportReport
Posted on by 6

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!!

  • jessebates Profile Picture
    jessebates 2 on at
    Re: Power Automate cannot find Excel File

    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.

  • jinivthakkar Profile Picture
    jinivthakkar 4,177 on at
    Re: Power Automate cannot find Excel File

    @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.

     

     

  • JKMyx Profile Picture
    JKMyx 6 on at
    Re: Power Automate cannot find Excel File

    @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 nameScreenshot table name

  • jinivthakkar Profile Picture
    jinivthakkar 4,177 on at
    Re: Power Automate cannot find Excel File

    @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.

  • JKMyx Profile Picture
    JKMyx 6 on at
    Re: Power Automate cannot find Excel File

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

    @jinivthakkar 

  • jinivthakkar Profile Picture
    jinivthakkar 4,177 on at
    Re: Power Automate cannot find Excel File

    @JKMyx please can you share screenshot of your flow?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics