Unanswered

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

(0) Share

Report

Posted on by johnjohnPter

1,756 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

I have the same question (0)

All responses (3)

Answers (0)

v-yueyun-msft on at

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

Was this reply helpful? Yes No
johnjohnPter 1,756 Super User 2024 Season 1 on at

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?

Was this reply helpful? Yes No
v-yueyun-msft on at

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

Was this reply helpful? Yes No