cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daleritf
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

jkeckard007
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

PeterLeibling
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (55,640)