Unanswered

Combobox allowing existing records to be selected again

(0) Share

Report

Posted on by simkessy

I have a combobox on my form. When I edit a SharePoint item the form is displaying the selected items correctly but the dropdown allows me to select those items again. Therefore the same record is displayed twice in the box but only the newly selected records are saved back to the list.

How do I prevent selected items from being selected again?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @simkessy ,

What is the column type of this column? At first, I thought it is a multiple value enabled Person and Group field, but I just tested and got the different result.

For example, for below multiple value enabled Person and Group field, I have "Mona" already in existing item. But after I search for Mona again, and select this person, it will be deleted as 2nd screenshot shows.

Did you use other data source as the options for this combo box? If so, how did you set this?

Please also share the Items property and other related settings of this combo box control.

Regards,

Mona

Was this reply helpful? Yes No
simkessy 72 on at

Like (0)

Report
Copy link

Link copied!
The original source is a multi-lookup field but the items equation looksl ike this:

AddColumns(AvailableUsers, "Subtext", EmailAddress & " | Active: " & ActiveContract.Value & " | Age: " & age, "ActiveStatusText", ActiveContract.Value)

On application start, I do this:

ClearCollect( UserActiveCount, Filter( AddColumns( GroupBy( Filter(Tasks, "Active" = status), "userText", "Count" ), "Active Count", CountRows(Count) ), 'Active Count' < 3 ) ); If(CountRows(UserActiveCount) = 0, ClearCollect(AvailableUsers, ChildList) , ClearCollect(AvailableUsers, Filter(ChildList, Title in UserActiveCount.userText )) )

Was this reply helpful? Yes No