Answered

Collect Multi Select Combo box Unique values into collection

(0) Share

Report

Posted on by Deepshikha21

Hello,

I have multiselect combo box in my Power App, On Change Property of Comb Box I am collecting values in collection which are selected in combo box. But when I am removing any value from Combo box its adding again all the combo box existing value into Collection leading to duplicate values in it.

I want that when I remove any value from combo box that should be remove from collection also and no duplicate or existing value should be added in collection.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

zaphod88 502 on at

Like
a
(0)

Report
Copy link

Link copied!

Which formula are you using to collect?
If you are not already doing it, try using ClearCollect(Collection, Self.SelectedItems). This way the collection always has the same records as the combobox.
Deepshikha21 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zaphod88 ,
I am using below formula -
Collect(EventContacts,{Contact:DataCardValue7_1.Selected.'Full Name',checkIn:"No",isLead:"No"});
And I am using same collection in Gallery to update values of this collection , so If I will use ClearCollect on On change property the all the data which is updated in same collection from gallery will be cleared.
zaphod88 502 on at

Like
a
(0)

Report
Copy link

Link copied!

If I get you right, the collection should only contain one record for each DataCardValue7_1.Selected?
Try
If(!IsEmpty(Filter(EventsContacts, DataCardValue7_1.Selected.'Full Name = Contact)),
RemoveIf(EventsContacts, DataCardValue7_1.Selected.'Full Name = Contact),
Collect(EventContacts,{Contact:DataCardValue7_1.Selected.'Full Name',checkIn:"No",isLead:"No"}))
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Deepshikha21 ,
You can try below formula:

If(IsBlank(LookUp(EventContacts,Contact=DataCardValueX.Selected.'Full Name')), Collect(EventContacts,{Contact:DataCardValueX.Selected.'Full Name',checkIn:"No",isLead:"No"}))

This time, only when the selected value doesn't exist in the collection, Collect function will add this selected value into collection.
Best regards,
Allen