Simple filter from SharePoint list

[Jason_]

Hi all, and apologies in advance for yet another Filter post. I have looked everywhere and tried a number of things but am up against a brick wall (and the time clock on this one!)

I have a standard PowerApp to browse and add items to a SharePoint list. On the gallery I want to show only items that have a Status (a column in the list) of New.

The gallery works fine in the unfiltered state with this as the formula under Items

SortByColumns(Filter([@'Training Parking Lot'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

I assumed I would just need to add a critera with something like the below, but it doesnt work (errors). Im sure I have the syntax right, so any suggestions would be much appreciated!

SortByColumns(Filter([@'Training Parking Lot'], Status="New", StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Please help! 🙂

[Drrickryp]

@Jason_ 

What type of column is status?

[Jason_]

It is a Choice column - New, WIP & Resolved

If possible I would like show both New and WIP, but if it can only have a single option, then New.

[Drrickryp]

The Ten Commandments of SharePoint in PowerApps.  Check out #1

Also https://powerusers.microsoft.com/t5/Building-Power-Apps/Displaying-Choice-Columns-in-a-Gallery-in-Po... 

[Jason_]

Thank you, I took a look but am still lost. Is Choice not a suitable column type for what I am trying to do?

[Drrickryp · Accepted solution]

@Jason_ , I would change it to a single line of text in SharePoint and then in PowerApps, use a list box or a combobox and put in your choices ["New", "WIP", "Resolved"] as the items property.  You can select one, or more if you set the Allow multiple selections to true.  You can then filter the list easily on status as you wanted to for a single selection.  If you wanted to filter it for multiple selections you would use Filter([@'Training Parking Lot'], StartsWith(Title, TextSearchBox1.Text) && Status in ListBox1.SelectedItems)