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?
@noelflores The following formula will give you a table with the grouped data for Japan, which can be looped using a ForAll.
LookUp(yourCollection, Location="Japan").Data