Add column to single value table and populate with data while in ForAll loop

[HappyShrooom]

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

[WarrenBelz · Accepted solution]

Hi @HappyShrooom ,

I cannot test this, but you might try 

ForAll(
   colProducts, 
   Collect(
      colProductsRecords, 
      AddColumns(
         Split(
            Products, ","
         ),
         "RecordID",
         YourRecordIDValue
      )
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[HappyShrooom]

Hi @WarrenBelz , 

It works. Would have sworn I tried your approach, but maybe I missed something. In any case thank you for your help. 

HappyShroom