Hello everyone. I'm asking for help because I'm about to go crazy. I have the following code that searches and filters data
With({asmt:Filter(
'TELEFONY — kopia';StartsWith(
Nazwisko;szukaj_box.Text
)
)
};
If(
filtr.Selected.Result = "Pokaż wszystkich pracowników"; asmt;
Filter(
asmt;Stanowisko=filtr.Selected.Result
)
)
)
For quite a long time I have been trying to modify it to use two filters independently.
I created this monster, but it doesn't do anything except that when I click show all floors, the data disappears, but when I select a specific floor, nothing happens, i.e. I see all the data limited by the job position filter.
With(
{
asmt: Filter(
'TELEFONY — kopia';
StartsWith(Nazwisko; szukaj_box.Text)
)
};
If(
filtr.Selected.Result = "Pokaż wszystkich pracowników";
asmt;
If(
filtr_1.Selected.Result = "Pokaż wszystkie piętra";
Filter(asmt;
Text(Piętro) = filtr_1.Selected.Result
);
Filter(asmt; Stanowisko = filtr.Selected.Result)
)
)
)
