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.