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

Occasional Contributor

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 = 

2 Replies
best response confirmed by sasrsc (Occasional Contributor)

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