Power Platform Community Forum Thread Details

I have quite similar issue with yours.

In my case, I have a combobox that stores multiple selection of brandcode. When user select more than 1 brand code, it will concat the brand code with";"

For example, user select brandcode 1001 and 1002, hence in my dataverse, I store this row as 1001;1002.

In my defaultselecteditems, this is the current code i use:

ForAll(
Filter(
Brands,
Market.Market = ThisItem.cra31_Market.Market,
BrandCode in Split(
ThisItem.cra31_brand,
";"
)
) As selectedBrands,
{Result: selectedBrands.BrandCode & "_" & selectedBrands.BrandName})

I have tried to change based on your formatting but it still override the record instead of storing the old and adding the new record only. Please help!

Categories:

Building Power Apps

Hey @_kikilalaaa

Maybe you can use Collection for this.

You can use Collect function for this. Make a similar function as below:

Collect(
YourCollectionName, // Replace with the name of your collection
ForAll(
Filter(
Brands,
Market.Market = ThisItem.cra31_Market.Market,
BrandCode in Split(ThisItem.cra31_brand, ";")
),
{ Result: selectedBrands.BrandCode & "_" & selectedBrands.BrandName }
)
)

With this formula, when a user selects items in the ComboBox, it will collect the new items into your collection without overwriting the existing records.

Now comes the clearing part. On the OnStart Property of your app you can keep Clear function or even use clear collect.

Clear(YourCollectionName)

ClearCollect(YourCollectionName, {})

I hope this helps 🙂