web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 0LHD3T6+fJb2FyM+Iot8YB
Power Automate - Using Flows
Unanswered

Excel script (just 1 of the several used) within Power Automate flow suddenly started failing this Monday. Works fine when manually triggered.

Like (1) ShareShare
ReportReport
Posted on 11 Jul 2024 13:18:58 by 22

Good Morning!

 

I created a Flow which pulls data from (the last 30 days of) an MS List, dumps it into a newly-created excel file, then triggers a series of scripts which, in sequence, reorganizes the data and creates (3) new sheets with pivot tables on each.  This has been working great until Monday of this week.  The very last script failed.  So the data's all in the excel script, but the pivot tables aren't done.  It doesn't appear to have taken any actions from the last script at all.  The Error Details says the error is in Line 23, which is somewhat in the middle of the first pivot table setup.  Screenshots below:

maxxell_1-1720703703796.png

 

maxxell_0-1720703518017.png

 

When I get to my PC in the morning (this usually runs in the early hours of the day), I can open up the file and trigger this script.  It runs without any errors.  That has been my solution all week, in the hopes that this was a temporary glitch in the matrix somehow.  But it's failed with the same error, citing the same part of the script, all 5 times the script has been triggered since Monday (including manual tests).  I can tell that neither my flow, nor any of the scripts referenced by this flow, have been edited lately. 

 

Any have any idea why this script would start failing?  I thought maybe the prior script wasn't really finishing before this one tried to start, so I added a 30-second delay in the flow before this script is fired.  That did not help.

 

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete