Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Get Tables file error ...
Power Automate - Building Flows
Answered

Get Tables file error Not supported file format & file corrupted error

(0) ShareShare
ReportReport
Posted on by AthenaDepper 110

I have a flow that I am trying to build. The goal is to have the end user update a budget by selecting a file anywhere in SharePoint. Once selected a generic file, identical in form to all budget files in the system, is updated.

 

 

SharePoint Get Tables 1.PNG

 

 

From there I am trying to Get Tables. As you can see the table Location, Document Library, and File are all selected and not dynamic. 

 

SharePoint Get Tables 2.PNG

 

 

This is where I receive the following errors: 

 

Not supported file format. Please select another file.
clientRequestId: 335bd3d0-44ae-4030-9e83-55fda991c735
serviceRequestId: ea6c8640-8a42-4f51-8166-10c0c47ae373

 

 

Additionally, when I try to open the file I get the Cannot open the file 'Budget Updates.xlsx' because the file format or file extension is not valid.

 

I've also tried to just pull the information from the original file, as well as trying to save it to OneDrive.

  • AthenaDepper Profile Picture
    AthenaDepper 110 on at
    Re: Get Tables file error Not supported file format & file corrupted error

    I know about the custom value option, but it doesn't work with Excel options. I've found tons of posts about the same issue and was just hoping the issue was resolved. Thanks anyway.

  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Get Tables file error Not supported file format & file corrupted error

    Hi @AthenaDepper,

     

    Yes, it is possible, you could enter the dynamic content by clicking the Enter Custom value:Screenshot 2020-10-16 154015.jpg

     

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

  • AthenaDepper Profile Picture
    AthenaDepper 110 on at
    Re: Get Tables file error Not supported file format & file corrupted error

    Thank you.

     

    Now if I wanted to get the file content from a dynamic library, is that possible yet?

  • Verified answer
    v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Get Tables file error Not supported file format & file corrupted error

    Hi @AthenaDepper,

     

    If you Get file content by using itemUrl and ID, the return file content couldn't be used in the Update file action directly.

    You could use Get file properties action to get File identifier first, then use it to get file content, steps as below, please have a try:

    Screenshot 2020-10-15 141603.jpg

     

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

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans