Forum Discussion

sasrsc's avatar
sasrsc
Copper Contributor
Aug 20, 2020
Solved

Is it possible to do a ODATA filter in Power Automate to check for a missing person field?

I have seen some old posts on other sites that seem to indicate you can't do an ODATA filter in Automate for a person field? 

In my particular case I want to get any rows where varname is missing

(varname is a person field).

Can it be done?

 

If it can be done can you also share an example for a ODATA field looking for a particular email address such as where email address for varname = mailto:Mickey.Mouse@Disney.com 

ODATA
  • Damien_Rosario's avatar
    Damien_Rosario
    Aug 25, 2020

    Hi sasrsc 

     

    Give this a try: 

    varname eq null

     

    Do not make it an expression and do not use ' ', simply type null as normal. 

     

     

    Good luck

    Damien

2 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Aug 25, 2020

    Hi sasrsc 

     

    Give this a try: 

    varname eq null

     

    Do not make it an expression and do not use ' ', simply type null as normal. 

     

     

    Good luck

    Damien

Resources