Answered

Powershell Script not working in Power Automate Desktop

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community!

I'm trying to automate uploading Power BI reports to our report server (we use the on premises version of Power BI rather than the cloud) I have 2 scripts that run one after another and work outside of PAD but when I add them in via this method the report is not uploaded:

This is what the second script looks like:

Script Example.PNG

What am i doing wrong?

Many thanks for any help!

Amy

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is that Folder Location "/" the wrong way?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@MichaelAnnis the script works outside of PAD so I'm not sure why I would need to change the slash in the script for PAD to make it work. I'm also not receiving any error messages when running the flow.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are they both not working, or just the second one? I wonder if it's a timing issue.

If the first one isn't working either, to test, temporarily disable the second one.

If that works, or if it is just the second one that is failing, I would get some type of Wait command to run the second.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@MichaelAnnis the first script allows the second to run (it's a function) so I tried running the first script outside of PAD and then running the second inside PAD and that doesn't work either. No matter what combination I try it fails to upload the report.

Was this reply helpful? Yes No
kierian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

try this hope its help.

How to use PowerShell in Power Automate Desktop - YouTube

Have a good day.

Was this reply helpful? Yes No
Verified answer

yoko2020 495 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Are there any error inside these 2 variables ?

%ScriptError%
%ScriptError2%

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks...this is actually the video I used to make the flow.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you, I am so new to PAD I didn't realise how to look at the message inside the variables. I combined the script into one as it wasn't recognising one of the commands and it now works. Thank you!!

Was this reply helpful? Yes No