I am following the exact steps mentioned in this video @ https://www.youtube.com/watch?v=RB_ySjhm9Sg+ in this link https://www.matthewdevaney.com/create-an-excel-file-and-add-rows-using-power-automate/ to create an excel file and create a table inside it, but the create table action will raise this error:-
The provided drive id appears to be malformed, or does not represent a valid drive.
clientRequestId: 97ffa24b-eb80-4b33-9920-9ab980b80fde
serviceRequestId: 67d1a2b2-7bcc-4b62-8fe1-5c9aac6339a4
here is my full flow:-
now the file will be created >> but without any table. as follow:-
please any advice? i spent 2 days trying to figure out what is wrong?
Thanks
Hi , @johnjohnPter
If you want to get the drive id, you can directly get in the "Peek Code":
How to find DRIVE ID for a Document Library in SharePoint using Power Automate (2024) - In 1 minute! (youtube.com)
If you want to get the drive id dynamically, you may need to call Graph API.
(1) First to get the site id.
https://graph.microsoft.com/v1.0/sites/{host-name}:/{server-relative-path}
(2)Get the drive id:
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
@v-yueyun-msft thanks ,, so the question now is how i can dynamically get this drvieId for the document library?
Hi , @johnjohnPter
I test it in my side , i can reproduce your error code :
This error code means that , you pass the wrong drive id in the red box.
Instead of the Name , you need to pass the drive id here!
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang