cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Filter sharepoint list

I have sharePoint List that has multiple columns. 

Columns: Facility, Facility Status, Address, Phone number, etc.

I want to be able to search and show all items by "Facility" column but I would like to see Items where Facility Status = "Active".

 

This is what I have:

SortByColumns(Search([@Facility], TextSearchBox1.Text, "Facility"), "Facility", If(SortDescending1, Descending, Ascending))

 

My fromula shows all the items that are "Active"and "Inactive".

 

Please help on configuring my formula to show only Facilities where Facility Status = "Active"

 

Thank you

18 REPLIES 18

Thanks alot!!!!!

Hi Radu, I'm still really struggling with this syntax and your solution appears to be the only one out there!

 

I have a Sharepoint list called Valet which is designed to book vehicle valet appointments. From this I have created a powerapp also called Valet. My Items syntax currently reads:

SortByColumns(Filter(Valet, StartsWith(RegNo, TextSearchBox1.Text)), "RegNo", If(SortDescending1, Descending, Ascending))

 

This searches for the RegNo just fine but my problem is that I only want to display items where Status = "Live". I have tried using your logic based on the Facility example but clearly I'm doing something wrong as all I end up with is lots of little yellow warning triangles. All of my display fields are text - no choice or drop-downs so in theory it should be very simple. Could you tell me what syntax I need? I have been tearing my hair out on this all afternoon!

 

Many thanks

SortByColumns(Filter(Valet, StartsWith(RegNo, TextSearchBox1.Text), Status = "Live"), "RegNo", If(SortDescending1, Descending, Ascending))

Does this work?

Hi Meneghino

 

Sorry to take so long to get back to you - I was away the second half of last week.

 

The good news is that it works! You're a star, many thanks

Helper III
Helper III

Can sme one help me I am trying to do close to the same thing.  I have a Title Column and a Status Column both are single line of text field.

I want to filter on Status= COMPLETE and text box search on Tilte column...the Only thing I get to work is the below the list is over 5000 item This doesn't filter on Status at all.

SortByColumns(Filter(HelpDeskTicket, StartsWith(Title, TextSearchBox1.Text&& Status="complete")), "Status", If(SortDescending1, Descending, Ascending))

Thanks

Jennifer

Hi @jkeckard007, since both StartsWith and = are delegated then it shouldn't matter how many rows the list has.

I think you got a bracket in the wrong place, try this:

SortByColumns(Filter(HelpDeskTicket, StartsWith(Title, TextSearchBox1.Text), Status="complete")), "Status", If(SortDescending1, Descending, Ascending))

Please let me know.

PS the = operator may be case-sensitive for SP lists but I am not sure

This did not work see

 It just says starting string the function returns true if the text starts with a string and then it does not return anything.

Thank you

New Member

Maybe somebody can help me. I try to filter my Sharepoint List - cause i want only to see Entrys with Status "Offen" (means Open - this comes from an Dropdownlist in Sharepoint.

 

The original Source is:

SortByColumns(Filter([@Ticketliste], StartsWith(Titel, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

 

When i try this, i get an error:

SortByColumns(Filter([@Ticketliste], StartsWith(Titel, TextSearchBox1.Text), Status = "Offen"), "Title", If(SortDescending1, Descending, Ascending))

 

When i edit the Sharepoint list this field it shows me: ...../_layouts/15/FldEdit.aspx?List=%xxxxxxxxxxxx-D14A-4E7F-BF89-67E11C230DAF%7D&Field=jexo

 

How is the Syntax? Did i have to use as Name jexo or Status? How is the correct Syntax?

 

Thanks a lot for your help.

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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