Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation

[sanil_barik]

Hello Everyone,

I’m currently working on an automation in Qlik Sense SaaS that retrieves app and sheet details using multiple blocks and then writes the collected data to a Google Sheet.

However, I’m facing an issue - I’m not able to use the output data from the previous block (which contains the app details) as the input for the Append Rows to Sheet block.

Here’s what I’ve tried so far:

• I used a List variable (AppDetails) to store all the details from earlier blocks.

• When I configure the “Append Rows to Sheet” block, the output data or variable (AppDetails) is not available or selectable in the input field.

• I also tried using Add Operation and other approaches to format or pass the data, but no success so far.

I’ve attached a screenshot for reference to show how the data is flowing between the blocks.

Could someone please guide me on how to properly pass the output block data (or list variable) into the Append Rows to Sheet block in the latest Qlik SaaS Automation interface?

Thanks in advance for your help!
– Sanil Kumar Barik

[salmankojar]

Hi @sanil_barik the attached screenshot shows that you are using append rows to sheet block outside the loop where your data content is generated. You can't get the data of a block which is used inside the loop block unless you are reading it from the same loop or else storing it in some variable.