web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps filtering a gallery wi...

Power Apps

Answered

filtering a gallery with a NOT forumla

(1) Share

Report

Report

Posted on by nerdyplayer

142

I suck at this.

I have a gallery, that has 3 status, New, in progress and closed.

I am trying to do a filter where it filters out Closed projects.

I can do a long code, but wanting to learn what i'm doing wrong.

filter(New project table, status.value ="New", status.value = "In Progress")

Filter (new project table, status.value <> "closed") didn't work.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
hey

can u try this please:

Filter('New Project Table', status.Value <> "Closed")

and

Filter('New Project Table', status.Value = "New" || status.Value = "In Progress")

did u connect the table as datasource to your app? when your datasource has spaces in the name (same counts for column names) you need to wrap them in single quotes

if you want to combine 2 status as above you need an operator in the middle such as && (for and) or || (for or)

if it helped please mark as verified answer

cheers

Was this reply helpful? Yes No

Join the conversation