Microsoft is adding the Python programming language to Microsoft Excel, allowing users to create powerful functions for analyzing and manipulating data.

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?

Sign in with a Microsoft Account. Step 3: Once the app is installed, choose Examples at the top of the application. You'll see various examples for how to use Power Automate.