Unanswered

"The provided drive id appears to be malformed, or does not represent a valid drive." when creating a table inside excel

(0) Share

Report

Posted on by johnjohnPter

1,809 Super User 2024 Season 1

I have this flow to create an excel and a table inside the excel, the excel will be created but the create table is raising this error:-

The provided drive id appears to be malformed, or does not represent a valid drive.

Here is the flow related actions:-

and here is the error:-

The provided drive id appears to be malformed, or does not represent a valid drive.
clientRequestId: 0cc57ae4-76d3-4922-96e8-be6e7c61cf25
serviceRequestId: 8ec263d1-b077-4aa7-89a3-1b763b3ae6af

here is the created excel file:-

any advice?

Thanks

Categories:

Building flows

I have the same question (1)

All responses (4)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @johnjohnPter

Pls try to pass the identifier (id) of the newly excel file instead of file path in "Create table" action. Try to find out the file identifier in the output of previous http action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

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

Like (0)

Report
@ManishSolanki i tried to pass the uniqueid:-

body('Send_an_HTTP_request_to_SharePoint_-_Create_empty_Excel')['d']['UniqueId']

but i got the same exact error...

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @johnjohnPter

Here is the sample flow.

I have used "Create file" action instead of "Send http request to SharePoint" action to create a new excel file:

Add an expression to pass empty string in 'File Content' parameter:

string('')

Next, add "Delay" action to give some time to save file in SP library:

Finally, add "Create table" action to create a table in the sheet. Pass the Id for the excel file from the output of create file action. In table range, specify the sheet name & the columns range as shown below:

Sheet1!A1:B1

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Suggested answer

Shravyashree_Shetty 49 on at

Like (0)

Report

Hi,

I found a fix for the above issue

Step 1: Select the document Library from the drop down (this is only to get the drive ID later we will change it to environment Variable)

step2: Test run the flow

The "Document Library" Output is the drive ID that this action requires -COPY the ID

Step3: Add a Text Environment Variable in the solution and add the Copied Drive ID

Step4: Replace the Document Libary in the Create Table action with the Above environment Variable with the drive ID in it

Please note that the QA and Prod Drive ID may vary

PLEASE GIVE THIS ANSWER A THUMBS UP, IF THIS HELPS AND ACCEPT THIS ANSWER AS A SOLUTION FOR FUTURE REFERENCE!

Was this reply helpful? Yes No