Unanswered

Run Script on saved file from previous action

(0) Share

Report

Posted on by davidcab

A weekly sales report gets emailed to me that I auto format the title and save it to a folder in my onedrive.

I created an excel online macro that deletes columns that are not needed, changes some header text and then selects all to create a table and sort a column.

The script works if i open a raw file and run it. How do i add it to my original flow?

Tried adding the run script card after the apply to each that renames and saves the file, didn't work. need guidance.

Categories:

Business Process Flows

All responses (3)

Answers (0)

Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: Run Script on saved file from previous action

Sounds good. Glad to hear you solved the problem! Feel free to reach out to us if you need any further help on Office Scripts!
davidcab 31 on at

Like (1)

Report

Re: Run Script on saved file from previous action

Oh sorry I solved this on my own. I had to change the input for the run a script action from the email attachment to the “item”. Works well. Now I need to figure out how to move the data to a report
Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: Run Script on saved file from previous action

Can you share a bit more about your flow? What actions do you have in it? What errors did you get?