web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

If is neither

(0) ShareShare
ReportReport
Posted on by 84

Say I have options A,B,C,D,E,F,G,H,I,J and i want to see all that are neither A or E

 

what formula would I write

 

I have tried using IF(option<>or(A,E)) but this gives a warning

 

Any help would be much appreciated

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @Lynch66 ,

     

    Please try this:

    Filter(["A","B","C","D","E","F","G","H","I","J" ],Not(Value="A"||Value="E"))

     

     

    Best regards,

    Rimmon

  • Verified answer
    timl Profile Picture
    36,753 Super User 2026 Season 1 on at

    Hi @Lynch66 


    Judging by your formula, if you want to use the If statement to test if "option" is not either A or E, the syntax would look like this:

    If (Not(option in ["A", "B"]),
     Notify("option is NOT A or B",
     Notify("option IS A or B"
    )


    As @v-mengmli-msft says , you can use this type of syntax to exclude A & E from the options.

    Filter(["A","B","C","D","E","F","G","H","I","J" ],
     Not(Value in ["A", "B"])
    )

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard