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?