Power Platform Community Forum Thread Details

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

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:

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.

Quick Links

Leaderboard > Power Automate