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
Solved! Go to Solution.
I have solved the issue by adding check out/check in actions
Regards,
Serbay
I have solved the issue by adding check out/check in actions
Regards,
Serbay
@Serbay could you post a picture of the part of your flow where you added the checkout / check in actions please?
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:
For anyone else who searches this, my issue was due to no file extension, .xlsx, being added on the 'Create File' step
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
29 | |
27 | |
20 | |
11 |