I have a combo that contains lot of values in drop down. I am able to select one or more from the drop down .
e.g below, i have selected 5 items and the count shows '5 items' . I would like to know , is this count displaying from
Reason why i would like to know , is because i have a check box ( see pic 'select all') , and when i check the checkbox , i am able to select all items , but the combo box is not displaying any count of items in the combo box.
see how it behaves when i check the check box . It actually selected 97 items but the count of items is not showing up in combo box.
What am i missing ?
LOGIC :
Combo box - Items :
--------------------
Distinct(
'Site Admins',
If(
NewComboBox.Selected.Value = "Supplier",
Supplier,
NewComboBox.Selected.Value = "City",
City,
NewComboBox.Selected.Value = "Site",
'Site Name'
)
)
Combo Box - On change :
----------------------------
Clear(SelectedPerson); // Add this formula
ForAll(
// Add this formula
'ComboBox-Bcc'.SelectedItems,
Collect(
SelectedPerson,
Filter(
'Site Admins',
If( // Modify formula here
NewComboBox.Selected.Value = "Supplier",
Supplier = Result,
NewComboBox.Selected.Value = "City",
City = Result,
NewComboBox.Selected.Value = "Site",
'Site Name' = Result
)
)
)
);
If((CountRows(SelectedPerson)+CountRows('ComboBox-To'.SelectedItems)+CountRows('ComboBox-Cc'.SelectedItems)) >500,UpdateContext({PopUpCount: true}))
Combo box - On Select :
--------------------------
false
Check Box - On Check :
---------------------------
If(
Checkbox1.Value=true,
Set(
Glob,
Distinct(
'Site Admins',
Switch(
NewComboBox.Selected.Value,
"Site", 'Site Name',
"Supplier", Supplier,
"City", City
)
)
),
Blank()
)
