Qlik Cloud Automation saving report as "array.pdf" instead of dynamic file name
Hi everyone,
I’m building an automation in Qlik Cloud to generate PDF reports by “Grupo Empresarial” and save each file to SharePoint.
The idea is:
Get all distinct values of a field (Grupo Empresarial)
Loop through each value
Generate a report filtered by that specific group
Save each PDF in SharePoint with a dynamic file name based on the group
My current flow is: Start → List values of field → (inside the loop) Create report → Add selection → Add sheets → Generate report → Copy file to SharePoint
The issue I’m facing is that the file is being saved as “array.pdf” instead of using the expected dynamic name. I’m currently using the output from “List values of field” in the Report Name / File Name, but it seems to be treated as an array instead of a single value.
What I need is:
Generate one PDF per group
Use the current loop value (Grupo Empresarial) as the file name
Ensure each file is correctly filtered and uniquely named
Is there any reason why you are using automation to do this instead of actually using in app reporting which has those things built-in and easy to apply?
cheers
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Hi @stratico , looking at your issue i think you are using all the items of “List values of field” output. you must use only the current item of “List values of field” output which will give you correct filename as per current value in the loop of field list. It would be more helpful if you attach your automation Json to help on this issue.
