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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,504)