I guess i have a simple question but i cann`t fix it and i tried everything to do it.
As you can see i have a gallery and i want to search in the search box on Birthname and i want to filter this gallery on EmployerID = "Jan".
Could you please tell me what i am doing wrong?!
To fix this, you would need to nest these two functions rather than to use the & operator. The formula would look like this:
SortByColumns(Search(Filter('[ISL].[Employee]_1', EmployeeId="Jan"), TextSearchBox1_1.Text, "BirthName"), "BirthName", "Ascending" )
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!