https://community.qlik.com/t5/Member-Articles/How-To-Send-message-in-Microsoft-Teams-with-attached-PDF-report/ta-p/2446116 <P><FONT color="#000000">This article shows an example how you can configure a Qlik Application Automation workflow to generate a simple report using Qlik Reporting Services and attach it as a PDF file to a message sent in Microsoft Teams channel. The main challenge addressed is the configuration of the necessary Microsoft Sharepoint and Teams blocks.&nbsp;</FONT></P> <P><FONT color="#339966"><STRONG>Content:</STRONG></FONT></P> <P><LI-TOC indent="15" liststyle="disc" maxheadinglevel="3"></LI-TOC></P> <P>&nbsp;</P> <H3><STRONG><FONT color="#339966">Background information</FONT></STRONG></H3> <UL> <LI>You can attach only those files to a Microsoft Teams message, that are already existing in Microsoft Sharepoint.&nbsp;</LI> <LI>Behind each Micsoroft Teams channel you can find the respective Sharepoint site, where uploaded channel files are stored.</LI> <LI>Generated PDF report must be stored in the respective Sharepoint first, before attaching it to the Teams message.</LI> </UL> <P><STRONG>Necessary Automation blocks:</STRONG></P> <UL> <LI>Qlik Reporting: <UL> <LI>Create / Generate report</LI> <LI><EM>further blocks according to your needs</EM></LI> </UL> </LI> <LI>Microsoft Sharepoint: <UL> <LI>Copy file on Microsoft Sharepoint</LI> <LI>List items on Drive</LI> </UL> </LI> <LI>Microsoft Teams: <UL> <LI>Send message</LI> </UL> </LI> <LI>Other: <UL> <LI>Variable</LI> <LI>Condition</LI> <LI>Exit Loop</LI> </UL> </LI> </UL> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Create new Application Automation</STRONG></FONT></H3> <P>Create a new automation using one of the provided Qlik Reporting templates:&nbsp;<EM>Store a simple multi-page PowerPoint report to Microsoft SharePoint</EM></P> <P class="lia-align-center"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KatjaK_0-1714373902974.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164904iFE52C7061F8D0FF8/image-size/medium?v=v2&amp;px=400" role="button" title="KatjaK_0-1714373902974.png" alt="KatjaK_0-1714373902974.png" /></span></P> <P>Configure Qlik Reporting blocks to generate the report needed. For more information on how to generate a PDF report using Qlik Application Automation please refer to previously posted articles (see links below).&nbsp;</P> <P>Here is an example of a simple one-page report:&nbsp;</P> <P class="lia-align-center"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KatjaK_1-1714374230044.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164907iB6EE14113204AD69/image-size/medium?v=v2&amp;px=400" role="button" title="KatjaK_1-1714374230044.png" alt="KatjaK_1-1714374230044.png" /></span></P> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Copy generated report to Microsoft Sharepoint</STRONG></FONT></H3> <P>The next step is to configure Microsoft Sharepoint automation block to copy the generated PDF report to the site of your interest. Certain input parameters were already pre-filled by the template, which was used to generate this automation.&nbsp;</P> <P class="lia-align-center"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KatjaK_2-1714374426184.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164908i3DC4D4E98C229AC2/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_2-1714374426184.png" alt="KatjaK_2-1714374426184.png" /></span></P> <UL> <LI><U>Source file</U>: This is the PDF report that was generated by the preceding Qlik Reporting block</LI> <LI><U>Destination Connector</U>: The file should be copied to a Microsoft Sharepoint site</LI> <LI><U>Destination Path</U>: The path including the file name of the destination</LI> <LI><U>Driveid / siteid</U>: Either one of the ids must be provided for the block to run successfully</LI> </UL> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Find necessary driveid / siteid / itemid</STRONG></FONT></H3> <P>There are several ways to find the relevant information (see links to Microsoft documentation below). This article shows one example way, which you can use.</P> <P>Let's assume an example scenario, where you want to share the generated PDF report in a teams channel named "My Channel". Under the files tab, you can view the files stored in the Sharepoint attached to your channel. There you can create a new folder, for example named "General", where you will store the generated report files.&nbsp; &nbsp;&nbsp;</P> <P class="lia-align-center"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KatjaK_3-1714374968537.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164912i9C3EF976FEEE8E4C/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_3-1714374968537.png" alt="KatjaK_3-1714374968537.png" /></span></P> <P>To find the driveid and siteid of this Sharepoint site, you can use <A href="https://developer.microsoft.com/en-us/graph/graph-explorer" target="_blank" rel="noopener">Microsoft Graph Explorer</A>&nbsp;and retrieve the necessary information by executing a chain of API calls.</P> <P>1. First, you must log in to your Microsoft account:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_5-1714375794025.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164914i55747B1C398D0139/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_5-1714375794025.png" alt="KatjaK_5-1714375794025.png" /></span></P> <P>&nbsp;</P> <P>2. Knowing the name of your Teams channel ("My Channel"), you can start a search for sites with this keyword:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">https://graph.microsoft.com/v1.0/sites?search={Keyword}</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_6-1714375913402.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164915i8591CF54BCBF6E34/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_6-1714375913402.png" alt="KatjaK_6-1714375913402.png" /></span></P> <P>Looking at the returned id, it seems like several siteids (separated by a comma) were concatenated as the example Sharepoint site contains one or more folders.</P> <P><EM>Note: this might look different in your scenario, however the returned&nbsp;<STRONG>id</STRONG> parameter is the one, which is required for the next steps.&nbsp;</EM></P> <P>&nbsp;</P> <P>3. This id parameter can now be used as siteid for the next API call, to find the rest of the relevant information for the target folder ("General").</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">https://graph.microsoft.com/v1.0/sites/{siteid}/drive/items/root/children</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_8-1714377657404.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164924iC680E51A68BE371B/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_8-1714377657404.png" alt="KatjaK_8-1714377657404.png" /></span></P> <P>Having found the name of the target folder ("General" in the example scenario), you can copy the relevant information into Qlik Application Automation. As this information will be used across multiple automation blocks, it is recommended to store the ids in the respective variables:</P> <UL> <LI><U>Driveid</U>: Take <STRONG>driveid</STRONG>&nbsp;parameter from the response</LI> <LI><U>Siteid</U>: Take&nbsp;<STRONG>siteid</STRONG> parameter from the response</LI> <LI><U>Itemid</U>: Take the&nbsp;<STRONG>eTag</STRONG> parameter from the response (without brackets)</LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_0-1714378105584.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164925i8C315A55A2D7EF50/image-size/medium?v=v2&amp;px=400" role="button" title="KatjaK_0-1714378105584.png" alt="KatjaK_0-1714378105584.png" /></span></P> <P>&nbsp;</P> <P>4. Configure the "Copy File on Microsoft Sharepoint" block using the new variables. Additionally, adjust the destination path to use the folder "General".&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_1-1714378289902.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164926i1699BC3E3EE57576/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_1-1714378289902.png" alt="KatjaK_1-1714378289902.png" /></span></P> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Find the generated report file in Microsoft Sharepoint</STRONG></FONT></H3> <P>Having stored the newly created file in Sharepoint, you must now retrieve the eTag of this file to be able to attach it to a message in Microsoft Teams.</P> <P>Use the Microsoft Sharepoint automation block "List Items on Drive" to iterate over items in a certain folder and find the newly generated file dynamically. Use the initially created variables <EM>Driveid</EM> and <EM>Itemid</EM> as input parameters:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_2-1714378703426.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164927i7830C8B72D2F7FDD/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_2-1714378703426.png" alt="KatjaK_2-1714378703426.png" /></span></P> <P>Include a "Condition" block into the loop to check, whether the file name corresponds to the name of the generated report you are looking for:&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">if {$.listItemsOnDrive.item.name} = {$.generateReport.path}</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>In case you have found the correct file name, store the eTag and webUrl parameters of this file in variables.&nbsp;</P> <UL> <LI>FileTag:&nbsp;</LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">{substr: {$.listItemsOnDrive.item.eTag}, 1, {subtract: {textlength: {$.listItemsOnDrive.item.eTag}}, 4}}</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <UL> <LI>WebUrl:</LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">{$.listItemsOnDrive.item.webUrl}</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Exit the loop, as you have already found the necessary information.</P> <P>&nbsp;</P> <H3><FONT color="#339966"><STRONG>Send Microsoft Teams message with PDF file attached</STRONG></FONT></H3> <P>Insert a Microsoft Teams automation block "Send Message" at the end of your automation. Use the lookup functionality to define your team and channel id, where the message will be posted.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_3-1714379198977.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164929i9387095794F4D616/image-size/medium?v=v2&amp;px=400" role="button" title="KatjaK_3-1714379198977.png" alt="KatjaK_3-1714379198977.png" /></span></P> <P>Write the content of your message. Use the following tag in the Content field to insert an attachment into the message. The id of the attachment should be the eTag of the file previously stored in the "<EM>FileTag</EM>" variable.</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">&lt;attachment id="{$.FileTag}"&gt;&lt;/attachment&gt;</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Define the attachment code as follows:&nbsp;</P> <UL> <LI><U>id</U>: eTag of the file (stored in variable "<EM>FileTag</EM>")</LI> <LI><U>contentUrl</U>: url to the stored file on Sharepoint (stored in variable "<EM>webUrl</EM>")</LI> <LI><U>name</U>: name of the file, that will be shown in the Teams message</LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">[{"id": "{$.FileTag}", "contentType": "reference", "contentUrl": "{$.webUrl}", "name": "{$.generateReport.path}" }]</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>This is how it might look like in the end:&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_4-1714380151039.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164933iFABF7B9A4EFF8497/image-size/medium?v=v2&amp;px=400" role="button" title="KatjaK_4-1714380151039.png" alt="KatjaK_4-1714380151039.png" /></span></P> <P>Save the automation and execute it. You will now receive a message in your Teams Channel with the content and attachment you have defined:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="KatjaK_5-1714380419701.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/164937iE71245593E66F601/image-size/large?v=v2&amp;px=999" role="button" title="KatjaK_5-1714380419701.png" alt="KatjaK_5-1714380419701.png" /></span></P> <P>&nbsp;</P> <H3><STRONG><FONT color="#339966">Related Content</FONT></STRONG></H3> <UL> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-get-started-with-Microsoft-Teams-in-Qlik-Application/ta-p/1838373" target="_self">How to get started with Microsoft Teams in Qlik Application Automation</A>&nbsp;</LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Create-automations-report.htm?id=1476#Creating%20a%20report%20using%20Qlik%20Application%20Automation" target="_self">Creating a report using Qlik Application Automation</A>&nbsp;</LI> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-store-cycled-reports-in-cloud-using-Qlik-Application/ta-p/1913084" target="_self">How to store cycled reports in cloud using Qlik Application Automation</A></LI> <LI>Microsoft documentation of API calls:&nbsp; <UL> <LI><A href="https://learn.microsoft.com/en-us/graph/api/chatmessage-post?view=graph-rest-1.0&amp;tabs=http#example-4-send-a-message-with-file-attachment-in-it" target="_self">Send a message with file attachment in it</A>&nbsp;</LI> <LI><A href="https://learn.microsoft.com/en-us/graph/api/driveitem-get?view=graph-rest-1.0&amp;tabs=http" target="_self">Get a driveItem resource</A>&nbsp;</LI> <LI><A href="https://learn.microsoft.com/en-us/answers/questions/730575/how-to-find-site-id-and-drive-id-for-graph-api" target="_self">How to find site id and drive id for graph API</A>&nbsp;</LI> </UL> </LI> </UL> <P>&nbsp;</P> <P><EM>The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.</EM></P> Tue, 30 Apr 2024 11:37:21 GMT KatjaK 2024-04-30T11:37:21Z https://community.qlik.com/t5/Member-Articles/How-To-Send-message-in-Microsoft-Teams-with-attached-PDF-report/ta-p/2446116 <P><FONT color="#000000">An example how to configure a Qlik Application Automation workflow to generate a simple report using Qlik Reporting Services and attach it as a PDF file to a message sent in Microsoft Teams channel.</FONT></P> Tue, 30 Apr 2024 11:37:21 GMT https://community.qlik.com/t5/Member-Articles/How-To-Send-message-in-Microsoft-Teams-with-attached-PDF-report/ta-p/2446116 KatjaK 2024-04-30T11:37:21Z https://community.qlik.com/t5/Member-Articles/How-To-Send-message-in-Microsoft-Teams-with-attached-PDF-report/tac-p/2446958#M2168 <P>Great Work Katja&nbsp;</P> Tue, 30 Apr 2024 12:01:34 GMT https://community.qlik.com/t5/Member-Articles/How-To-Send-message-in-Microsoft-Teams-with-attached-PDF-report/tac-p/2446958#M2168 Torsten_Kohrt 2024-04-30T12:01:34Z