PowerApps: Filter and sort using tablist AND search bar (with 2 fields)
I have a gallery pulling from a Sharepoint List. I have a tab list set up that allows the user to select a tab, and be shown a filtered view of the list. Love that. Great. Good. Dandy.
SortByColumns( Filter( ‘Sharepointlist’, Or( Category.Value = TabList1.Selected.Value, TabList1.Selected.Value = “All” ) ), “Title”,SortOrder.Ascending)
The problem is I would like to also filter the list by the search bar. As the user types I would like the list to be further filtered by what the user is typing if it matches what is in field a or field b. I have a field with the title and another field with the acronym. Some users may search using the acronym and so I need it to check both places.
I cannot for the life of me figure out what the code would need to be for that or how to nest it. any help is appreciated!
I have a gallery pulling from a Sharepoint List. I have a tab list set up that allows the user to select a tab, and be shown a filtered view of the list. Love that. Great. Good. Dandy.SortByColumns( Filter( ‘Sharepointlist’, Or( Category.Value = TabList1.Selected.Value, TabList1.Selected.Value = “All” ) ), “Title”,SortOrder.Ascending) The problem is I would like to also filter the list by the search bar. As the user types I would like the list to be further filtered by what the user is typing if it matches what is in field a or field b. I have a field with the title and another field with the acronym. Some users may search using the acronym and so I need it to check both places. I cannot for the life of me figure out what the code would need to be for that or how to nest it. any help is appreciated! Read More