How to send straight table data to Microsoft Teams as a message using Qlik Automate

[AfeefaTk]

This article provides an overview of how to send straight table data as a message to Microsoft Teams using Qlik Automate.

The template is available on the template picker. You can find it by navigating to Add new -> New automation -> Search templates, searching for 'Send straight table data to Microsoft Teams as a message' in the search bar, and clicking the Use template option.

You will find a version of this automation attached to this article: "Send-straight-table-data-to-Microsoft-Teams-as-a-message.json".

Content:

• Full Automation
• Automation structure
• Related Content

Full Automation

Automation structure

The following steps describe how to build the demo automation: 

1. Add the 'Select Field Value' block from the Qlik Cloud Services connector to apply a selection to the straight table.
   
   
2. Add the 'Get Straight Table Data' block from the Qlik Cloud Services connector to get data from the straight table for a specific app to send to the Microsoft Teams channel as a table. Specify app ID, Sheet ID, and Object ID input parameters. You can use the do-lookup functionality to find value for all these parameters. The 'Get Straight Table Data' block is limited to retrieving  100,000 records. This block will not work with other table types.
   
   
3. Add a string variable called 'message' within 'Get Straight Table Data' block to append a list item element (<li>) to the message variable. Specify key-value pairs for the dimensions from your straight table to be included in the message.
   
   
4. Add a 'Send Message' block from the Microsoft Teams connector to send straight table data as a message to the Teams channel. Map the 'message' variable to the Content input parameter and enclose it in an unordered list element <ul>. Ensure you don't send too many records; Microsoft Teams has a limit of 28 KB per message. Specify the Team ID and the Channel ID input parameters. You can use the do-lookup functionality to find value for all these parameters. 
   
   

An example output of the message sent to the Teams channel:

The information in this article is provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s), and/or other factors, ongoing support on the solution below may not be provided by Qlik Support.

Related Content

• Video - Send straight table data to a Microsoft Teams channel as a message 
• How to get started with Microsoft Teams
• Send straight table data to Microsoft Teams as a table 

Environment

• Qlik Cloud Analytics
• Qlik Automate