How to create multi-page PowerPoint report and store them to Microsoft SharePoint using Qlik Application Automation

AfeefaTk — Thu, 07 Nov 2024 07:59:23 GMT

This article explains how the Reporting connector in Qlik Application Automation can be used to generate multi-page PowerPoint reports. It also explains how to store the generated report on a cloud storage tool, like Microsoft SharePoint.You can modify this automation by selecting a different destination connector for the cloud storage in the "Copy File" block or Use the Send Mail block in the Mail connector to send the report over email.

You can use the template that is available in the template picker. You can find it by navigating to Add new -> New automation -> Search templates and searching for 'Store a simple multi-page PowerPoint report to Microsoft SharePoint' in the search bar. Click on the Use template option to use it in the automation.

Environment

Qlik Sense Enterprise SaaS
Qlik Application Automation

Full Automation

Step-by-step description

The following steps describe how to build the demo automation. You will find a version of this automation attached to this article: "Store-a-simple-multi-page-PowerPoint-report-to-Microsoft-SharePoint.json".

Search for the 'Create Report' block in the Reporting connector, drag it to the automation editor, and attach it to the Start block. Configure it by specifying a name for the report and selecting Sheets mode = All option
Add the 'Generate Report' block to the automation and configure it to use the report we are building. Select PowerPoint as the format mode to generate a PowerPoint report.
Note: It provides an option to generate a PDF report when PDF is selected as the format mode.
Find the Cloud Storage connector in the Block Library and add the 'Copy File' block to the automation. Configure it to use the output from the 'Generate Report' block as the Source File and set the Destination connector to Microsoft SharePoint (or another destination of your choice). Include the Path from the output of the Generate Report block in the Destination Path parameter to use the generated filename. Use the 'do lookup' functionality to find a Drive Id or a Site Id, but do not specify both.

article How to create multi-page PowerPoint report and store them to Microsoft SharePoint using Qlik Application Automation in Official Support Articles

How to create multi-page PowerPoint report and store them to Microsoft SharePoint using Qlik Application Automation

Environment

Full Automation

Step-by-step description

Related Content