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

Community site session details

Session Id : QgihTB1eRIdpLtKZArYSrn
Power Automate - Building Flows
Unanswered

Get Items Filter query

Like (0) ShareShare
ReportReport
Posted on 19 May 2022 12:19:15 by 4

Hi, 

 

Can anyone tell me what is wrong with this filter query? 

Title eq 'Wet_Ovrldn' and (Andere_x002d_mailadres ne null or Persoon_x002f_Groep ne null)

 

What I'm trying to do is get all items from but get only those items which has title 'Wet_Ovrldn' and make sure that "null" values in column Andere_x002d_mailadres of column Persoon_x002f_Groep are left behind. 

If I try to run my flow with following filter query's seperatly, than it works fine, but together he doesn't leave the null values behind... 

Title eq 'Wet_Ovrldn' and Andere_x002d_mailadres ne null  --> works fine

Title eq 'Wet_Ovrldn' andPersoon_x002f_Groep ne null   --> works fine

I have the same question (0)
  • KK-ZS Profile Picture
    4 on 23 May 2022 at 08:38:41
    Re: Get Items Filter query

    Hi Expiscornovus, 

     

    Unfortunately, he still takes "null" values with him... 

  • Expiscornovus Profile Picture
    32,207 Most Valuable Professional on 19 May 2022 at 16:40:55
    Re: Get Items Filter query

    Hi @KK-ZS,

     

    Can you try this Filter Query instead:

    (Title eq 'Wet_Ovrldn') and ((Andere_x002d_mailadres ne null) or (Persoon_x002f_Groep ne null))

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 809 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 711 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 373 Super User 2025 Season 2

Last 30 days Overall leaderboard