Hi everyone,
I am having a collection that can have multiple records in it. A collection has the following columns.
Products: Concatenated values from record columns.
RecordId: Generated unique identifier.
Clear(colProducts);
ForAll(
Gallery2_1.AllItems,
Collect(
colProducts,
{
RecordId: RecordId,
Products: Concatenate(
If(
ThisItem.Sharepoint = "true",
"Sharepoint",
"false"
),
",",
If(
ThisItem.Dynamics = "true",
"Dynamics",
"false"
),
",",
If(
ThisItem.Office = "true",
"Office",
"false"
),
",",
If(
ThisItem.PowerApp = "true",
"PowerApp",
"false"
),
",",
If(
ThisItem.PowerBI = "true",
"PowerBI",
"false"
),
",",
If(
ThisItem.Flow = "true",
"Flow",
"false"
)
)
}
));
Next, I create a collection based on "Products" column so that each product is actually a new record. I am achieving this by using Split function.
ForAll(colProducts, Collect(colProductsRecords, Split(Products, ",")))
BUT, I also want to add new column to collection "colProductsRecords", RecordId for each product record created, depending on the current iteration item. Result should be this:
Thank you all for helping!
HappyShroom
User | Count |
---|---|
183 | |
110 | |
88 | |
44 | |
42 |
User | Count |
---|---|
227 | |
108 | |
106 | |
68 | |
68 |