Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

filtering a gallery with a NOT forumla

(2) ShareShare
ReportReport
Posted on by 94
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:
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 10,429 on at
    filtering a gallery with a NOT forumla
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard