Qlik Sense Alert 2 – MS Teams + Power Automate

qlik-sense-alert-2 via Teams and Power Automate

Nearly a year ago, I wrote about sending alerts to Microsoft Teams channel using Qlik load script and REST connector. With the coronavirus sweeping through the world, forcing people in lock-downs, we are seeing surge in the use of collaboration tools such as Microsoft Teams. So, I wanted to expand on this further and send a HTML table as notification to MS Teams channel and send emails using Microsoft Power Automate (Previously known as Flow) to help people get the notifications quicker.

Continue reading “Qlik Sense Alert 2 – MS Teams + Power Automate”

Qlik Load Script Alerts to Microsoft Teams

Qlik Sense is a great platform, however, it has its shortfalls. One of them would be the lack of push notifications out of the box from QMC. Last year, I worked on a few solutions to send alerts via emails and via APIs/webhooks to bespoke applications when there is a job failure on Qlik Sense Enterprise. I utilised the QRS API as well as REST connector and webhook technologies to achieve these goals. That got me thinking, what else can be done using webhook? At Tahola, we use Microsoft Teams as part of our collaboration suite. I thought it would be a good idea to be able to send alerts to the Teams channel directly from Qlik data load scripts (via REST connector), whether be a load completion alert or just a simple KPI summary table from the data model. So, I spent few hours building a PoC Qlik application to that goal, and thought, I should share the concept with others as it might be useful in some scenarios.

Continue reading “Qlik Load Script Alerts to Microsoft Teams”