Unanswered

The script couldn't create a connection with Excel.

(5) Share

Report

Posted on by Serbay

213

Hi,
I have a flow that uploads the file into the Sharepoint site and then runs a script to make changes in the file.
But I'm receiving the following error,
"We were unable to run the script. Please try again. The script couldn't create a connection with Excel"

I have realized that when a file created in the SharePoint library, the file is shown only in view mode. I assume this could be the reason.
I have tested similar flows that upload the file as in edit mode, scripts run.

Any idea how to fix this issue?

Regards,
Serbay

Categories:

Building flows

I have the same question (3)

All responses (15)

Answers (1)

Verified answer

Serbay 213 on at

Like (1)

Report

I have solved the issue by adding check out/check in actions
Regards,
Serbay

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@Serbay could you post a picture of the part of your flow where you added the checkout / check in actions please?

Was this reply helpful? Yes No
Serbay 213 on at

Like (2)

Report

Hi @Anonymous
Here is an example for you;

Was this reply helpful? Yes No
mlopez 4 on at

Like (1)

Report

I cannot seem to get this flow to work. Can I see properties you are using?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

I have the same error dynamically setting the file name rather than picking it. Picking the file works. My error is:

We were unable to run the script. Please try again.
The script couldn't create a connection with Excel. Please try again.

I have tried checking out / in the document and tried using the identifier but no luck. Here's my Flow:

Was this reply helpful? Yes No
chaile on at

Like (6)

Report

For anyone else who searches this, my issue was due to no file extension, .xlsx, being added on the 'Create File' step

Was this reply helpful? Yes No
PC_Mn 4 on at

Like (2)

Report

Thank you for posting this. The missing .xlsx extension resolved my error.

Was this reply helpful? Yes No
bsfegade 60 on at

Like (4)

Report
I am still getting the error.

{ "message": "We were unable to run the script. Please try again.\nThe script couldn't create a connection with Excel. Please try again.\r\nclientRequestId: 07f96g4c-8578-4f3g-93c6-2b6f55fb35d8", "logs": []}

Was this reply helpful? Yes No
franca5 3 on at

Like (2)

Report

im having the same issue. i am truly shocked how clunky the power automate UI is after the update. this is painful.

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (1)

Report

Same issue as @bsfegade any one can help us?

Was this reply helpful? Yes No