show unique value in comboboxes

(0) Share

Report

Posted on by LisKr

304

Hi,

my app contains multiple comboboxes linked to a sharepoint list, for example "monitor 1" and "monitor 2". The comboboxes only show items linked to a specific user from a people picker.

My problem now is, that if a user has only one monitor, both comboboxes show the same one. Is it possible to somehow check if one item is already selected in the first combobox and if yes don't show anything in the second one? And also for manually selecting, like if a user selects item 1 in combobox 1, they can't select item 1 in combobox 2?

This is my current code for default selected items in both "monitor" comboboxes:

If(
 !IsBlank(UserField.SelectedItems);
 Distinct(
 Filter(
 Monitors;
 Status.Value = "Handed out" &&
 Len(User.Email) > 0 &&
 User.Email = UserField.Selected.Email
 );
 'Asset ID'
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
hi @LisKr ,
Items for First Combobox:
Distinct( Filter( Monitors; Status.Value = "Handed out" && Len(User.Email) > 0 && User.Email = UserField.Selected.Email ); 'Asset ID' )

Items for Second Combobox:
If( !IsBlank(FirstComboBox.Selected), Filter( Distinct( Filter( Monitors; Status.Value = "Handed out" && Len(User.Email) > 0 && User.Email = UserField.Selected.Email ); 'Asset ID' ), 'Asset ID' <> FirstComboBox.Selected.'Asset ID' ), Distinct( Filter( Monitors; Status.Value = "Handed out" && Len(User.Email) > 0 && User.Email = UserField.Selected.Email ); 'Asset ID' ) )

OnChange for First Combobox:
Reset(SecondComboBox)

OnChange for Second Combobox:
If( SecondComboBox.Selected.'Asset ID' = FirstComboBox.Selected.'Asset ID', Notify("This item is already selected in the first combobox.", NotificationType.Error); Reset(SecondComboBox) )

Was this reply helpful? Yes No
LisKr 304 on at

Like (0)

Report
Thank you for your reply @anandm08

I get errors when trying your code for the items property of the second combobox. Firstly, it doesn't recognize Asset ID in Combobox.Selected.'Asset ID'. Asset ID is my column name in my list and it seems like I can't refer to it at this point. So I tried using Combobox.Selected.Value, it should do the same, right?

Secondly, I get an error at
'Asset ID' <> FirstComboBox.Selected.'Asset ID'

It says "incompatible type for comparison: Record, Record". But record is the same data type, so why is that happening?

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Referencing Column Values in Combobox Selected Item: Yes, if 'Asset ID' is the column name in your list, then you should reference it as Combobox.Selected.Value. The 'Asset ID' is usually referenced directly as Combobox.Selected.Value, assuming Combobox represents a dropdown control bound to the SharePoint list. So you can replace 'Asset ID' with Combobox.Selected.Value in your formula.
Error with Comparing Records: The error "incompatible type for comparison: Record, Record" typically occurs when you try to compare two entire records instead of their specific fields. Since we're comparing the 'Asset ID' field of the records, we need to directly compare the values of those fields, not the records themselves.
Here's how you can adjust the formula:

Filter( Distinct( Filter( Monitors; Status.Value = "Handed out" && Len(User.Email) > 0 && User.Email = UserField.Selected.Email ); 'Asset ID' ); Value <> FirstComboBox.Selected.Value )

Was this reply helpful? Yes No
LisKr 304 on at

Like (0)

Report

Thanks for your detailed explanation, that sounds very logical.
Unfortunately, the new formula throws no error, but it also doesn't do anything. There's still the same default items shown in both comboboxes.

Was this reply helpful? Yes No
LisKr 304 on at

Like (0)

Report

It seems like I needed to put that code into default selected items, too. Now it works.

Was this reply helpful? Yes No