web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Reading Excel file sto...
Power Automate
Unanswered

Reading Excel file stored in a Document Library on SharePoint

(0) ShareShare
ReportReport
Posted on by
I have been facing trouble for fetching the Excel table (Get tables action) where my Excel file is stored in a document library. For creating a file in the same library with '.xlsx' extension my method of using Send HTTP request then Parsing and then by using compose extracting the name of document library, I was able to use it to store documents there.
But by same method I am not able to fetch the Excel and it shows 'GRAPH API REQUEST FAILED "The provided drive id appears to be malformed'. I tried various methods but I am not able to resolve this issue.

Please do help or give suggestions!
I have the same question (0)
  • Expiscornovus Profile Picture
    33,830 Most Valuable Professional on at
     
    Can you share a bit more details about the HTTP request you are using and also a screenshot of how you configured the Get tables action. That would be useful for troubleshooting.
     
    Additionally, have you tried to use the drive id of the document library instead of the name? (That should also work).

     



    Example drive id value as a custom value.




     
    Happy to help out 😁

    I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard