cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wahlbang
Regular Visitor

Browse gallery exclude item

Hey everyone,

I've created an app from a Microsoft List.
The list is showing reported incidents within our organization.

The app shows items that has been set to "resolved".

I would like that the list will not show resolved incidents.

The column in the list is called Status.

 

wahlbang_0-1612437652889.png

As you can see in the list, the resolved incident is not shown like from the app below.

wahlbang_0-1612439232819.png

 


The code from the browse gallery 

 

 

SortByColumns(Filter([@'Incidents-PROD'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

 

 

 

What i actually would like is to show is everything except Status: Resolved


Hope you can assist me.

Best regards,

Sebastian

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@wahlbang 

Try this

SortByColumns(Filter([@'Incidents-PROD'], StartsWith(Title, TextSearchBox1.Text), Status.Value<>"Resolved"), "Title", If(SortDescending1, Descending, Ascending))

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@wahlbang 

Try this

SortByColumns(Filter([@'Incidents-PROD'], StartsWith(Title, TextSearchBox1.Text), Status.Value<>"Resolved"), "Title", If(SortDescending1, Descending, Ascending))

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

@mdevaney 

Let me try, I will get back to you! 🙂

jufguu
Helper II
Helper II

It worked for me

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,562)