Filter(
Search(
'Overview hydrocolloids';
SearchInput1.Text;
Type;
Modification
);
'Gel formation' = Radio1.Selected.Value || IsBlank(Radio1.Selected.Value)
)
Now, I'm trying to make a filter with a Combobox. In my data source table I have a choice list (with text)
which allows (and contains) multiple choices. See below:a picture below
Now for the Combobox I used Choices('Structure choice') to express that I want to use the choices from that
choice list as my choices for the Combobox.
In the Combobox I want to allow multiple choice.
Problem/question
I want to filter my data with the search bar and/or with the filters. The rows represent hydrocolloids
When I select the structure choices in the Combobox I want the filter show me the following: I want to
see all results that contain at least my structure choices.
So for example: I filter on "elastic gel" I want to see all Hydrocolloids (Results) that contain
"elastic gel". When I filter for "elastic gel" and "low viscous" I want to see all Hydrocolloids that
contain this combination of structures and they may also contain other structures not filtered on.
I have been trying to include that in my formula, but whatever I try I keep getting errors.
Below you can find 2 examples of formulas that didn't work.
Filter(
'Overview hydrocolloids';
Or(
IsBlank(ComboboxCanvas1.SelectedItems);
IsEmpty(ComboboxCanvas1.SelectedItems);
CountRows(
ComboboxCanvas1.SelectedItems
) = CountRows(
Filter(
'Structure choice';
Value in ComboboxCanvas1.SelectedItems.Value
)
)
)
)
The error gives an invalid argument type at Value
Filter(
'Overview hydrocolloids';
Or(
IsBlank(ComboboxCanvas1.SelectedItems);
IsEmpty(ComboboxCanvas1.SelectedItems);
ForAll(
ComboboxCanvas1.SelectedItems;
ThisRecord.Value in 'Structure choice'
)
)
)
At ThisRecord "invalid argument type, a boolean value is expected" and "a text is expected at
the position of the formula"
Working on it for hours but every solution gives an error. Also can't seem to find a video that explains
how to work with the "double multiple choice" Can someone please help? Thank you so much!
ps in my language version the ; is used instead of ,
pps I tried to give as much important information as possible. If you need more, let me know
