Hello,
I have put together an app over the last few weeks. This works so far also quite well. Unfortunately, I've been stuck with my filters for 3 weeks.
I have a gallery and want to filter different items.
I have managed to combine 4 text filters so that the gallery responds to the 4 different filters.
Filter(
'DataBase Analytics Table',
StartsWith(
Title,
txtTitle.Text
) && StartsWith(
MachineNumber,
txtMachineNumber.Text
) && StartsWith(
'Object / object number',
txtObject.Text
) && StartsWith(
Name,
txtName.Text
)
)
I managed to do the same with a combobox.
Filter('Data base analyses table',
Or(
Subject.Value in ComboBox2.SelectedItems.Value,
IsEmpty(ComboBox2.SelectedItems)
)
)
The problem I have is that I can't get the formulas assembled. Either text filter or combo box. But not both together.
In the net I found "OR" and "AND" and tried them. Nothing worked.
What exactly must the formula look like so that I can use all filters?
Best regards
Christian Junker
