Unanswered

Excel Online Office Script not running in Power Automate

(0) Share

Report

Posted on by spudduk

Good afternoon....

I have an Office Script created in Excel Online that copies and pastes data from a Pivot Table as values to another table. When I run the script inside Excel it all works fine and the data is copied across, so all is good.

However when I run the same script from inside Power Automate as a set of sequenced flows then it reports a success but it does not copy and paste the data over ?

There are 4 other flows and they all run fine, just the copy and paste as values ?

Any ideas where to look ?

Andy

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (1)

Report

Hi @spudduk

Add console.log("done") statements to script and check run logs. Go to the Power Automate run history, expand the Run script action, and look into the Outputs for the logs.

Regards
Kaif

Was this reply helpful? Yes No
MarkRullo 2 on at

Like (0)

Report

I'm not sure if the tip helped solve this issue, but the response from @Kaif Siddique was a really handy hint for me. Thank you for this!

Was this reply helpful? Yes No