Running Python triggered from Microsoft Flow

Question

Would anyone know what is the approach to call Python application/script (which relies on imported libraries like pandas) from Microsoft Flow?

The complete problem is like this. Client uploads something to Dropbox (it is how his ERP works). This action is linked to our Microsoft Flow so whenever he uploads it, Microsoft Flow registers it (now it just redirects it to us). What I need to do after is run the Python application/script on that file in Dropbox after he uploads it. I can put my Python directly into that Dropbox. What I do not know is how to trigger it and ensure it runs (is interpreted).

Thank you for any suggestions.

Answer 1

To execute any code locally from MS flow, install and configure On premises gateway as per the instructions in the below link

https://docs.microsoft.com/en-us/flow/gateway-reference

Create a flow to copy the new file from dropbox to the local filesystem

Create a watcher to the local directory for any new file creation and execute the python code for the new file.

Refer the below link for the powershell script execution. Similar process can be designed for python

https://flow.microsoft.com/en-us/blog/flow-of-the-week-local-code-execution/