TLDR : I want to access an Excel file based on a sharepoint path I give manually.
What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents.
You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable.
So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.
Any other idea would help.
Thanks in advance,
Maxim Perolle