I have an app that collects repair tickets. On the Tickets screen it currently lists by most recently submitted. Is there a way to set up a filter on this screen that can filter by one of my Sharepoint Columns: "Priority" ? The column is a Choice column with 4 options: Urgent, Important, Medium, Low. I think I like that the default view shows all the tickets. But I'm not sure how to add a button or text field or whatever to filter. Thanks for your help!
hi @Anonymous you can add a filter indeed.
I'm going to use a collection to show you a way to do the filtering.
ClearCollect(colDataSource,DataSource);
The gallery below is from the colDataSource
gallery Items = If(IsBlank(ComboBox.Selected.Value),colDataSource, Filter(colDataSource, Xand in ComboBox.SelectedItems))
The combobox to look up those 4 options with column name being Xand
Choices(TestStuff.Xand) returns all the choices listed in the column
ComboBox
Selecting the option will reteunr the following:
selecting uhm (all the items with choice uhm is displayed)
Lets add pff as a choice
i hop ethi swill guide you to build that filter 😉
Share
Report
All responses (
Answers (
4,843
