Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...
Stop relying on manual clicks and clunky code—let Excel refresh your queries automatically.