Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry

How to: Getting started with the Microsoft Outlook 365 connector in Qlik Application Automation

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
MarkGeurtsen
Support
Support

How to: Getting started with the Microsoft Outlook 365 connector in Qlik Application Automation

Last Update:

Nov 9, 2022 4:02:08 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 8, 2022 7:25:35 PM

Attachments

This article is intended to get started with the Microsoft Outlook 365 connector in Qlik Application Automation.

 

Authentication and Authorization

To authenticate with Microsoft Outlook 365 you create a new connection. The connector makes use of OAuth2 for authentication and authorization purposes. You will be prompted with a popup screen to consent a list of permissions for Qlik Application Automation to use. The Oauth scopes that are requested are:

  • Mail.Send
  • User.Read
  • Offline_access

 

Sending Email with the Microsoft Outlook 365 connector

The scope of this connector has been limited to only sending emails. Currently, we do not enable sending email attachments and are looking to provide this functionality in the future. The suggested approach is to upload files to a different platform, e.g. Onedrive or Dropbox and create a sharing link that can be included in the email body.

The following parameters are available on the Send Email block:

  • To: A comma separated list of recipients;
  • CC: A comma separated list of recipients to which the email should be copied;
  • BCC: A comma separated list of recipients to which the email should be blind copied;
  • Subject: A title for your email;
  • Type: Choose between plain text email or HTML;
  • Body: The content of your email. You can use HTML for your email if chosen as the type.

 

Generating a report and sending an email with the report

As we do not currently support email attachments, we need to first generate a sharing link in Onedrive or an alternative file sharing service. The following automation shows how to generate a report from a Qlik Sense app, upload the report to Microsoft Onedrive, create a sharing link and send out an email with the sharing link in the body. This automation is also attached as JSON in the attachment to this post.

MarkGeurtsen_0-1667813079733.png

 

Environment:

Qlik Application Automation 

 

Tags (1)
Labels (2)
Comments
mfahlers
Partner Ambassador
Partner Ambassador

Hi

Could be please get an option for added an attachment, the lack of attachments makes it impossible to use with the reporting automation

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @mfahlers This is on the roadmap for the Microsoft Outlook 365 connector, though in the meantime, you can distribute links to a report. We also have a Mail block which allows for attachments.

All the best,
Sonja 

 

mfahlers
Partner Ambassador
Partner Ambassador

Hi Sonja

Thanks, the Link is an good idea, but that requires the user to have access to a some place that is not Qlik to access the files, as the idea is to distribute to external users /none qlik users like in nprinting.

The mail block doesn't work because it it not compatible with Microsoft requirements regarding using their smtp server (unless special settings are use, which are deprecated) . Yes we could use other smtp servers, but this is meet with great resistance in the organizations/customers as it is another mail system to be bought/maintained 

Sander_Persgroep
Contributor II
Contributor II

@Sonja_Bauernfeind any update about this connector? When will it possible to send attachments?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Sander_Persgroep 

None as of yet. Please vote on and subscribe to the following idea to stay informed: Automations - Outlook 365 - add attachments 

If you have trouble accessing this link directly, please go to our Ideation Site first, scroll down a little and click Authenticate Me.

All the best,
Sonja

Version history
Last update:
‎2022-11-09 04:02 AM
Updated by: