I have a label that recognizes the user: Office365Users.MyProfile().JobTitle and then I also have a hidden label that says "All Roles". So, when a user accesses the app, I want the gallery to display all the items that are available to their role or all roles... and then I want them to be able to search within that.
Here's what I have the gallery set to:
Filter(ListName,ColumnName.Value in CurrentUsersLabel.Text Or AllRolesLabel.Text && searchbox.Text in Title)
It only returns the first logical test instead of both. Thoughts?
@RezaDorrani, So simple! Thank you! Right now, the column is a single-selection drop-down, but it needs to be a multi-selection. I've been researching how to first even display the multi-selection choices in the gallery and haven't made it that far yet. Suggestions?