cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jason_
New Member

Simple filter from SharePoint list

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! 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@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) 

View solution in original post

5 REPLIES 5
Drrickryp
Super User
Super User

@Jason_ 

What type of column is status?

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.

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
Super User
Super User

@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) 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,336)