Skip to main content

Notifications

Power Automate - Using Flows
Suggested answer

Power Automate Excel Script - Run from sharepoint is SLOW

(0) ShareShare
ReportReport
Posted on by
So, i'm running into an issue with a flow I built which was working fine & it will run, but not complete one of the excel scripts from sharepoint.
 
I have checked & we haven't changed any of the connection references, the script, the script's location or the location of the excel file it is looking up against.
 
I tried running the script manually and it works in around 15s, so don't think it's an issue with the script itself.
 
To add confusion, I have a parallel script doing the exact same thing (albeit with a few thousand less rows) that runs absolutely fine and takes 8sec to run. Previously this problem script would take 36 seconds to run, but now wont run even if I leave it for 15min.
 
Has anyone got any ideas as to why one script would run & the other wouldn't and what might've caused the script to suddenly break?
  • Suggested answer
    David_MA Profile Picture
    David_MA 8,950 on at
    Power Automate Excel Script - Run from sharepoint is SLOW
    You don't show your flow, so I don't know how the script is being used or how you have created the script or which Office Script action you are using to run it. However, if you created an *.osts file for the script, these should be saved to the OneDrive of the owner of the flow in the folder Documents > Office Scripts as noted in Office Scripts file storage and ownership - Office Scripts | Microsoft Learn
     
    If the script is being run on the account of the owner of the flow, I would move the file to this folder in the owner's OneDrive and run it from there to see if that improves performance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics

Restore a deleted flow