cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Serbay
Resolver I
Resolver I

The script couldn't create a connection with Excel.

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Serbay
Resolver I
Resolver I

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

Serbay

 

View solution in original post

5 REPLIES 5
Serbay
Resolver I
Resolver I

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

Serbay

 

View solution in original post

BrandonArceaux
New Member

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

Hi @BrandonArceaux 
Here is an example for you;

Serbay_0-1622233949982.png

 

 

mlopez
Regular Visitor

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

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:

 

capture.png

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,694)