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