Help with Survey123 workflow
Good morning,
I have a doubt with power automate and I can't find the solution.
What I´m trying to do is:
I have a survey123, and every time that survey is submitted, I need pdf reports to be generated. But not exactly the same as in the basic flow where triger is used when a survey response is submited + create report + upload file from url. What I want, based on this initial flow of triger + create report + upload file from url, is that when the triger is triggered, not only the pdf of the last survey is printed, but I want to generate reports of ALL records grouped by a field called Pipeline name. For example, if Pipeline name had these values: A,B,C,A,B,B,A,A,A,B,B,C,B, I would want a report of A in this case with its 5 records, another of B with 4, C with 2, etc.
Then, what I need, once the triger is activated, is an action that from that survey that has been connected to the initial triger, allows me to generate an array with the values without duplicates of Pipeline name and once I have that array, i can use apply to each, use filter array and already create report and upload file.
Here is a screenshot of the workflow I have. With this workflow, only the report of the last survey to be uploaded is generated, but not all of them. And although in the select action that you see, I try to generate this array, I do not get it.
Would anyone know how to approach this workflow?
I hope I have explained myself well.
Thank you
