Power Automate Integration

[ALT_2358]

Hi, 

I think it would be extremely useful to be able to trigger an Alteryx workflow using Power Automate. 

The main benefit I see at the moment is automatically triggering an Alteryx workflow when the input data has been refreshed.

This would also enable a Power App to be added directly to Power Bi which can simply be clicked to re-run an Alteryx workflow then refresh the Power Bi dataset. 

[LSalter]

Hi Chiraz,

I was involved with robwalks and Chris in architecting and building out the solution within our business.

Typically what happens is you send a http request to the API with the right endpoint and that triggers the workflow to run. The last time I checked the endpoint for running a workflow was /user/v2/workflows/{appId}/jobs. 

You would need to authenticate via OAuth2, which was the main challenge we had using power automate. Hence having a Flask API running on a webserver on the alteryx server machine. This Flask API could then fetch the token from the correct URL once authenticated. The endpoint for the token is typically your server address and /webapi/oauth2/token appended to the end. When fetching the token, the endpoint takes your api access key and secret to authenticate you. 

It is once you have the token that you can make the actual POST request to /user/v2/workflows/{appId}/jobs in order to run the required workflow, passing in the appid of the alteryx flow you wish to run. When sending the POST request you should use bearer as the authorization header in your request along with your token. https://swagger.io/docs/specification/authentication/bearer-authentication/ 

Postman can often be a great way to test this.

Unless your alteryx server can be reached directly over the internet and not just on the company network then if using power automate you will need a gateway set up to allow power automate to make http requests over the internal company network.

I hope that helps.

[chiraz_cheikha]

Hello @LSalter 

I just confirmed that i need vpn to connect to company's gallery :( 

so in this case i guess this makes it more complicated, i will have to use http with azure ad like @KidVallejo said,

thank you @LSalter , @KidVallejo  and @robwalks so much for your help i really appreciate it, it gave me more clarity about the next steps, 

have a great day !