Create a new excel file inside sharepoint document library and then trying to create a table will raise this error "The provided drive id appears to be malformed, or does not represent a valid drive."

Like (0) Share

Report

Posted on 5 Jun 2024 16:22:09 by johnjohnPter

1,546 Super User 2024 Season 1

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

All responses (3)

Answers (0)

v-yueyun-msft on 06 Jun 2024 at 08:15:40

Like (0)

Report

Re: Create a new excel file inside sharepoint document library and then trying to create a table will raise this error "The provided drive id appears to be malformed, or does not represent a valid drive."

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:

split( outputs('Invoke_an_HTTP_request')?['body']?['id'] , ',')?[1]

xpath( xml(json(concat('{"root":{"item":',outputs('Invoke_an_HTTP_request_2')?['body']?['value'],'}}'))) , '//item[name="Documents"]/id/text()')?[0]

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
johnjohnPter 1,546 Super User 2024 Season 1 on 06 Jun 2024 at 07:42:53

Like (0)

Report

Re: Create a new excel file inside sharepoint document library and then trying to create a table will raise this error "The provided drive id appears to be malformed, or does not represent a valid drive."

@v-yueyun-msft thanks ,, so the question now is how i can dynamically get this drvieId for the document library?
v-yueyun-msft on 06 Jun 2024 at 01:44:59

Like (0)

Report

Re: Create a new excel file inside sharepoint document library and then trying to create a table will raise this error "The provided drive id appears to be malformed, or does not represent a valid drive."

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