Power Automate Tool...Working or not?

[lourdes_urena]

Hello, has anyone successfully utilized the power automate tool to run flows? We managed to connect to the environments available to our service account, but we don't see any flows to be able to trigger them.  We are signing in through browser.  We are unsure how it should be setup if something specific needs to be done in order to be successful with this connector.

[abacon]

@lourdes_urena The Power Automate tool can be funky, but if you have connected and don't see any flows, I would look at a few different things.

1. Are the workflows you are wanting to run shared with you or created by you? It could be that the alteryx connector is looking in the wrong spot for the flows.

2. Did you connect to the wrong workspace? Similar to the issue above, it could be looking in the wrong spot or using the wrong type of authentication to find the flows.

3. Do you have strict IT controls over the security of the environment? I had trouble using it at my first role because of the very strict IT policies.

I hope you get it working, it is a handy tool to use when you can get it working. If you get any errors that give some detail, post it so we can try to help out.

Bacon

[caltang]

Following this - I didn’t get it to work either and would love to learn. @abacon Useful points though even after successfully connecting, sometimes it’s slow / breaks. Can’t really understand why and I just gave up on those tools…

[abacon]

@caltang It definitely is very slow and I don't prefer to use it. I had one use case we started to use it for but stopped as there was a better option.

A lot of the issues in setting them up I believe come down to IT settings and security. I didn't do anything special to my tool to get it setup. One option may be the OAuth Custom app credential option and have IT get you the Client ID, Secret, and Tenant ID. Probably tried this but I would think that is the most secure/assured way to get into the desired workspace.

Bacon

[lourdes_urena]

@abacon was your other option also running power automate flows just from another application? I've gone through all the checks mentioned and can't have my IT peeps figure out what's missing so at this point I'm looking at alternatives.  

[abacon]

@lourdes_urena We were getting data from SharePoint so I just used the SharePoint connector. What are you trying to do with Power Automate and Alteryx? An option could be to call the AYX workflow from the Power Automate flow? And, are you getting an error, or just no flows are showing up?

Bacon

[lourdes_urena]

@abacon no error, just no flows showing up.  Do I just call the Alteryx workflow from Power Automate by an API call to the server?

[abacon]

@lourdes_urena Yes, that is another option to do.

Use the HTTP tool in power automate to setup your alteryx workflow api call. Have you setup API calls to the Alteryx Server before? If not, just click the question mark in the top right corner of you server and hit API documentation, also go to your profile and grab your Client_ID and Client_secret.

Bacon

[lourdes_urena]

I have but through BluePrism not Power Automate so thank you so much for the tip about the API documentation.  

[abacon]

@lourdes_urena They are pretty easy to setup. And, if you are going to use Alteryx at some point to pull Alteryx APIs, check out the Server API Tool - Server API Tool.

Bacon