How to send an Excel report as an attachment using Qlik Application Automation

[AfeefaTk]

Environment

• Qlik Sense Enterprise SaaS
• Qlik Application Automation

This article describes how an Excel file can be sent as an attachment by using the Send Mail block in Qlik Application Automation.

Automation Structure

The creation of an Excel report from a Qlik Sense straight table is explained in the first part of this article.

Let's walk through the blocks used in the automation workflow to send the Excel file as an attachment using the "Send Mail" block.

1. Open the Excel file saved in Microsoft SharePoint using the "Open File on Microsoft SharePoint" block.
   
   
2. Use the "Send Mail" block from Mail Connector to send the Excel file as an attachment via email.
   
   
   

A JSON file containing the above automation is attached to this article.

Please follow the steps provided in the How to import automation from a JSON file article to import the automation.

Related Content 

• Generate Excel Report 
• Copy data from a Qlik Sense straight table to an Excel sheet 

[Carin_89]

Hello everyone, 

I have a question @Sonja_Bauernfeind . 

Can I send the generated report through automation after my app reloads?

Thanks

[ttibrandsqliksense]

@Carin_89  - you can use webhook for this requirement

[poojask123]

Hi,

 I want to pass a value like "*- 1000 -* to a field Column1 through the "Select Field Value" block. Please help me on how this can be achieved.

Thanks

[PetyaAtanasova]

@poojask123You have a couple of options depending on whether you need all values selected at the same time or in a loop.
1. You can do that if you create a loop. Start with a block of List Field Values. When within this loop place a Condition container where you specify that the selected value should consist of this string - 1000 -, then on the Yes of this Condition you will place your Select Field Value Block. While this can be a bit slower, it enables you to select individual values, one at a time. 

2. It could also happen if you start with the approach above, but instead of Select Field Value within the Condition Block, you will place a variable that appeends all values that match the *- 1000 -* criteria into this variable. Creating a comma (or anything else) separaterd list that later you can use in a Select Field Value. Custom Code can take care of any duplicates, if there are any. This enables you to select all values at once. 

Here is the python code i use to deduplicate lists:

import json

raw_input = inputs.get("YourVariableName")

# Handle both string and list inputs
if isinstance(raw_input, str):
try:
name_list = json.loads(raw_input)
except json.JSONDecodeError:
name_list = []
elif isinstance(raw_input, list):
name_list = raw_input
else:
name_list = []

# Deduplicate
unique_names = list(set(name_list))

print(json.dumps(unique_names))

Please, let me know how it goes! 

[mayuringale25]

Hi Team,

I want to remove that Lead with data image completely. is there any way to do it