Hi the community !
I have actually a gallery where i apply some filter like this screen:
I arrive to filter correctly with checkbox on "statut" and with startswith for the sktech number. But to arrive to a faster interesting result i need to have the possibility to filter on the box "attribué à" who is in reality a column person from my sharepointlist. Is there a possibility to do that ?
Here the actual code :
SortByColumns(Filter(
'database';
And(
Or(
IsBlank(ComboBox2.SelectedItems);
IsEmpty(ComboBox2.SelectedItems);
Statut.Value = Index(
ComboBox2.SelectedItems;
1
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
2
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
3
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
4
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
5
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
6
).Value;
Statut.Value = Index(
ComboBox2.SelectedItems;
7
).Value
);
StartsWith(
Sketch_number;
SearchDTR_4.Text)
));"Scketchbnumber";Ascending)
Thanks in advance
