I currently have a Sharepoint list with a multiple choice column named 'tags'.
I can filter the gallery with the tags using a combo box, but I want to also include the title so if a user types 'name of' & clicks choice 2 - the first and second item in the list would appear.
Here are my current formulas
Combo Box:
Distinct(
Ungroup(
ForAll(
FrankCompass,
{Item: Tags}
),
"Item"
),
Value
)
Gallery:
Filter(FrankCompass, CountRows(Filter(Tags,Value in ComboBox1.SelectedItems)) > 0)
Thanks in advance
Wouldn't it be easier for the user if you have two comboboxes, one for Title and one for Tags.
Filter(
FrankCompass, Len(ComboBox1.SelectedItems)=0 || Tags.Value in ComboBox1.SelectedItems,
Len(ComboBox2.Selected.Title)=0|| Title = ComboBox2.Selected.Title
)
Selecting a title from a combobox is easier for a user than guessing what the text might be. With the above formula, if neither combobox has a selection, then then all the values in FrankCompass will be shown in the gallery.
@Drrickryp - thanks for the suggestion.
I won't be able to use comboboxes for titles as there are hundreds 😞
It seems far too difficult to filter by multiple checkboxes
User | Count |
---|---|
253 | |
125 | |
106 | |
50 | |
49 |