Dear community,
On my form I have a gallery connected to a Dataverse tabel that contains 5000 records and a combobox called cbAfdelingen for displaying the members of a department. But when I choose a department in the combobox I do not get to see all the employees.
Code of the combobox cbAfdelingen:
Sort(Distinct(dbEmployeeDirectory;Afdeling);Value;SortOrder.Ascending)
Code of the Gallery:
If(
!IsBlank(SearchBox.Value) || !IsBlank(cbAfdeling.Selected.Value) || !IsBlank(cbTitel.Selected.Value);
SortByColumns(
Search(
Filter(
dbEmployeeDirectory;
cbAfdeling.Selected.Value = Blank() || Afdeling = cbAfdeling.Selected.Value;
cbTitel.Selected.Value = Blank() || Titel = cbTitel.Selected.Value
);
SearchBox.Value;
"crcfa_voornaam";
"crcfa_achternaam";
"crcfa_personeelsnummer";
"crcfa_gebruikersid";
"crcfa_computer"
);
"crcfa_achternaam";
If(
cbSort.Selected.Value = "A-Z";
SortOrder.Ascending;
SortOrder.Descending
)
)
)
Who can help me ?
Gr. Peter