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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / "!" Operator not suppo...
Power Apps
Suggested Answer

"!" Operator not supported by PowerApps

(0) ShareShare
ReportReport
Posted on by 2

 

The logical operators are causing warning. If someone can help with us, it would be helpful. I have pasted the code.

Thanks.

If(ovs,

 

Search(

    Filter('BGC Reports',!('Overall CC'="Green"),

    IsBlank(ComboBox1_1.SelectedItems.Value) || IsEmpty(ComboBox1_1.SelectedItems) || (Location.Value=ComboBox1_1.Selected.Value),

   

    IsBlank(ComboBox1_3.SelectedItems.Value) || IsEmpty(ComboBox1_3.SelectedItems) || (ComboBox1_3.Selected.Value in 'Overall CC')),

   

    TextInput1.Text,Title),

 

 

a1i,

 

Search(

    Filter('BGC Reports',(!('Address CC'="Green")||!('Education CC'="Green")||!('Employment CC'="Green")||!('Court Check CC'="Green")||!('Sanction Screening CC'="Green")||!('Work Authorization CC'="Green")||!('Reference Check-1'="Green")),

    IsBlank(ComboBox1_1.SelectedItems.Value) || IsEmpty(ComboBox1_1.SelectedItems) || (Location.Value=ComboBox1_1.Selected.Value),

   

    IsBlank(ComboBox1_3.SelectedItems.Value) || IsEmpty(ComboBox1_3.SelectedItems) || (ComboBox1_3.Selected.Value in 'Overall CC')),

   

    TextInput1.Text,Title),

 

Search(

    Filter('BGC Reports',

    IsBlank(ComboBox1_1.SelectedItems.Value) || IsEmpty(ComboBox1_1.SelectedItems) || (Location.Value=ComboBox1_1.Selected.Value),

   

    IsBlank(ComboBox1_3.SelectedItems.Value) || IsEmpty(ComboBox1_3.SelectedItems) || (ComboBox1_3.Selected.Value in 'Overall CC')),

   

    TextInput1.Text,Title))

Categories:
I have the same question (0)
  • Suggested answer
    Nandit Profile Picture
    1,568 Moderator on at
     
    It would be helpful if you could share the code where you are using NOT. You can try replacing it with ! if its in front of an argument or <> if you are using it to filter out some records. These are the operators with full delegation support:  =, <, <=, <>, >, >= [3]
     
    Hope this helps. 
     
    Kind regards, 
    Nandit
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
  • WarrenBelz Profile Picture
    153,051 Most Valuable Professional on at
    That is a Delegation warning - the Not operator in any form (<> ! Not) is not Delegable.
     
  • MichaelFP Profile Picture
    1,847 Super User 2025 Season 2 on at
    You need to check the data source that you are using, In the error that you posted it show that doesn't support the NOT() formula. 
     
    Try to get the data into a collection and after apply the not or ! filter on the collection.
     
    Which is the connection that you are using?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard