Power Platform Community Forum Thread Details

Hi, Is it possible to reference a grouped data inside a collection?
As an example, Let's say I have this collection. Is it possible to reference the Grouped Data for Japan Location?

Data	Location	Total
[Grouped Data]	Japan	100
[Grouped Data]	Malaysia	200
[Grouped Data]	Thailand	300

The output im really looking to create is to loop through this collection, using ForAll, and to run a Flow using the row details, and the grouped data as an HTML Table.

Essentially, for each location, I want to make a pdf. and inside the PDF i want to plug in the Grouped Data for that location.

I've tried separating the location column first as one collection, and filtering the Data before I had it grouped as another collection, but ForAll doesn't seem to allow having multiple ClearCollect inside the formula.

Is it impossible?

Categories:

Building Power Apps