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?

The Automate tab allows you to create and run Office Scripts, which allow users to automate tasks in Excel.

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...