Get Items Filter query

(0) Share

Report

Posted on by KK-ZS

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

All responses (2)

Answers (0)

KK-ZS 4 on at

Like (0)

Report

Re: Get Items Filter query

Hi Expiscornovus,

Unfortunately, he still takes "null" values with him...
Expiscornovus 32,131 Most Valuable Professional on at

Like (0)

Report
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))