Answered

Simple filter from SharePoint list

(0) Share

Report

Posted on by 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! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jason_

What type of column is status?

Was this reply helpful? Yes No
Jason_ 7 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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-PowerApps/td-p/177281

Was this reply helpful? Yes No
Jason_ 7 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No