Power Platform Community Forum Thread Details

I have a search box and a dropdown for it, which gives options on employee departments. When searching, it also displays undesired results, which i filtered out from showing, but they still show in the backend, so dropdown still gives their "departments".

how can i make the dropdown not show the departments for the employees, which dont fit my filter criteria.

code from dropdown:

SortByColumns(Distinct(Office365Users.SearchUser({searchTerm:IskalnikZaposlenihTxt.Text,top:950}), Department), "Result")

code for search button:

Set(varTable, Filter(Office365Users.SearchUser({searchTerm:IskalnikZaposlenihTxt.Text,top:950}), Department = OddelekDropdown.Selected.Result, IsMatch(Mail, "xyz", Contains & IgnoreCase)))

code for search box:

If(IsBlank(Trim( IskalnikZaposlenihTxt.Text)),DisplayMode.Disabled,DisplayMode.Edit)

hope my issue is understandable.

thanks for help

Categories:

Building Power Apps