You’re offline. This is a read only version of the page.
4
I have a power automate flow built which saves an excel attachment down into sharepoint. I then want to run an office script which converts the data into a table and then creates a pivot. This script runs when i go into the file and trigger it manually. However, whenever I run it in power automate, it fails as below.
I'd also if possible like it to run on each file that is saved, rather than on the "template" file I have set up.
Hello @PeterAP , would you mind sharing the clientRequestId (from the run history logs) so we can do some further troubleshooting? Please feel free to pm me with that info you prefer!
And for your second question, are you asking about running the script against a dynamically created workbook? It should be possible. But could you elaborate a bit more about your flow? Specifically, how are you saving the attachment to SharePoint? Which Power Automate action are you using? For example, if you are using the "Create file" action, you should be able to use "id" from its results as the "File" parameter for the "Run script" action.
Share
Report
All responses (
Answers (
