question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked DSPatrick answered

Using PowerAutomate to Open an Excel File, Calculate, and Save

Say i have a folder that has several excel reports in it. Instead of having to go into each report every week... is there a way for PowerAutomate to trigger every Monday morning to open each excel file, hit the 'Calculate Now' button, and then Save the file in the same folder. Even if it just overwrites the same name that is OK, but i'd be interested in having it save the file with the date at the end ("Report72_10.19.21")

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.