Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Power Automate Integration

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. 

12 Comments
LSalter
5 - Atom

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
6 - Meteoroid

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 !