Within Power Automate, it has been possible to run scripts in Excel using the Run Script actions. Did you know that the is a Run Scripts from SharePoint library action too?

Learn how to combine Excel files with different sheet names using Power Query. Save time, reduce errors, and automate your data consolidation ...