Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Outlook 365 - Output?!

Hamder83
11 - Bolide

Hi 

im looking for a solution to send emails from alteryx, using moden auth - since microsoft is disabeling basic auth.

 

https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basi...



I can find Outlook 365 INPUT with modern auth, but no output. Have I missed something? 


Kind regards, 

12 REPLIES 12
KGT
13 - Pulsar

Sorry about the length, I tried to include everything...

 

It will still use SMTP, but the DCM connection set up will use Azure OAuth for authentication. The +Connect Credential would then be populated with your Office 365 credentials. I believe that any email available through POP3 and IMAP4 clients needs SMTP. It is the standard for interacting between email servers. Setup is the same as setting up any other DCM connection and then linking it to credentials, except the SMTP connection info that would have gone in the tool, go in the DCM connection.

 

Note: an MS email server sending to another MS email server may not use SMTP, as it's all internal to Microsoft, but it will still be there for connecting to external servers.

 

There is a chance that SMTP is shut down by security protocols in an organisation and so no matter how hard you try, it may always fail to connect. This is organisation by organisation. In that case, you would need an api based tool. I know that when I've come across this, IT wouldn't let me send directly through any method, and so they set up a powerapp, and I called that API to send the bulk emails.

 

So, how that comes together... there is a chance that Alteryx could build an Outlook 365 output tool, but it's not being worked on currently as far as I know. That ideas page linked above from 3 years ago (adding OAuth2 to the Email tool) was marked implemented 3 years ago and so nothing would have happened to "progress" the sideline issue of companies shutting down access to SMTP in that time. (Hence why I responded, because there is nothing else expected on that idea, and so it will most likely be the same in 7 years).

 

Even further, If a company has shut down access to SMTP, which is the standard way to interact with a mail server for sending emails, then I'm not sure that a vendor creating another tool as a workaround will be high on the priority list and won't be blocked as well. But that being said, the best way is to post an idea for that, and see if it garners traction.

AshRez
8 - Asteroid

Thank you very much for the thorough response, much obliged.

 

I have googled for the smtp that I should use and found it is smtp.office365.com, but when I did continue to create the connection, the only option I had for Azur was Azur AD, and when I preceded I got that my organization blocking Alteryx from authorization, so I can’t use it. I appreciate your help though. Thank you.

rfoster7
11 - Bolide

So the Email tool with OAUTH, is still using SMTP to send the email, but using OAUTH for the authentication (instead of SMTP legacy/basic authentication). Alteryx doesn't have a graph based email option yet and there doesn't seem to be one on the roadmap. Our company is pursuing building a python graph based email package that we could theoretically embed in a python tool in a macro in our workflows. Note that the instructions in the email documentation says "You can choose to use Azure OAuth or Azure OAuth (Alteryx Application)." but the actual values in the tool are something like AZURE AD and AZURE AD - Private. We chose AZURE AD and it brought up the microsoft authorization dialog. We submitted it and had to have our AZURE admin find it and authorize send.mail for our application. Once that was done, it worked for all of our licensed users. 

Labels
Top Solution Authors