It is easy to set up a flow in Power Automate to open, save and close a file. However, I want to automate a process whereby the Power Pivot tables refreshes before it saves the file. How do I do that?
Check out this thread. It sounds like something similar to what you're trying to accomplish and might provide you a solution.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.