Unanswered

Flow script error with correct output. How?

(0) Share

Report

Posted on by RPYee

My workflow creates an Excel file from a Power BI Paginated report, opens the Excel file, then runs a script on the file to create a new worksheet with a pivot table. The flow is doing exactly what it is supposed to do, but I'm still getting an error.

I'm not sure what I need to fix. There are actions to be added after this, so I need to rectify this error to move forward.

Any help is greatly appreciated!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RPYee

So looking at it, its not doing what its supposed to as its failing? I don't mean that rudely I mean it as in, am I misunderstanding so I can help better.

Looking at this, I see a Create File (is my guess using the output of your Power BI), then I see Get File Content(can you explain why you are doing that?)

Then you want to run a script.

Is the script already in the workbook? How did it get there?

Or is this a script in another file that knows how to access this file?

Was this reply helpful? Yes No
RPYee 25 on at

Like (0)

Report

The script is saved in a file (.osts) in the SharePoint folder and called at the "Run script from SharePoint library" step. It's working just fine, but at the end, I'm getting the message "flow run failed". The reason I say it's working is that the script completely modifies the original file. The output file shows me that the script worked. Don't understand how my output is correct if the flow failed.

I did a "Get file content" to be able to run the script on it. It's entirely possible I'm not thinking about this process in the proper way...

.

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RPYee

No worries, i have to ask myself each time (did I mean that or lol why did I do that).

My only weirdness is I see you have an error, but you feel like its working, so I am not sure what to resolve.

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The error message mentions that you may have an error in the workbook input (file format issue), although the script runs fine. Could you please share the inputs from your Run script from SharePoint library action?

In this meantime, to prevent your flow run to stop due to this error, you can set up the Run after configuration of your action, so your flow will move to the next step even if the Run script from SharePoint library fails. You just have to go to the first action after it and select Configure run after:

And then you can select the scenarios where your flow must move forward to the next step (and even all of them). Since the action is failing, make sure to keep the has failed checked:

Let me know if it works for you or if you need any additional help!

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.

Was this reply helpful? Yes No