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 new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.