Answered

Excel Run Script - Script not found Error for shared users

(1) Share

Report

Posted on by jiwhite

500

I have a cloud flow that I have shared with a Run Script connector. The flow and the workbook is shared with others. The Office Script is shared with everyone with access to the workbook, and they can run it manually in the workbook. When the flow is run by the account that created the flow, the connector works. When the flow is run by someone else with access, the script is not found. The other connectors to a SharePoint list and OneDrive folders work properly for everyone. Is there any way to fix this error?

Categories:

Building flows

I have the same question (1)

All responses (4)

Answers (1)

Sort by

Verified answer

Gdarmon Outlook 372 on at

Like (1)

Report
Copy link

Link copied!
One possible reason for this issue is that the other users do not have the necessary permissions to access the Office Script. To resolve this issue, you can try the following steps:
Double-check that the Office Script is shared with everyone who needs access to it.
Verify that the other users have the necessary permissions to access the Office Script. You can check the sharing settings for the script to ensure that the other users have the appropriate level of access.
Try running the flow using the “Run only” feature in Power Automate. This feature allows you to specify which users can run the flow and ensures that the flow runs using the correct credentials.
Gill

1 people found this reply helpful.

Was this reply helpful? Yes No
jiwhite 500 on at

Like (1)

Report
Copy link

Link copied!

Changing the flow access to Run Only with the connector set to use the service account's connection fixed the issue. Thanks!

2 people found this reply helpful.

Was this reply helpful? Yes No
RL-23102218-0 4 on at

Like (0)

Report
Copy link

Link copied!

I understand to check the permission. Where do I go to check those permissions? Where is the setting to properly share the script?

Was this reply helpful? Yes No
CU09011757-0 2 on at

Like (0)

Report
Copy link

Link copied!
To verify and update who an Office Script has been shared to:

Go to the script in OneDrive My files > Documents > Office Scripts.

Right click on the script and select Share. You can use the Share window to add additional users.

Left click on the Manage Access icons in the lower left corner of the pop up to view who currently has access.

To view additional permissions options, select ... > Advanced Settings.

Was this reply helpful? Yes No