SOLVED

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

Copper 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 = Mickey.Mouse@Disney.com 

2 Replies
best response confirmed by sasrsc (Copper Contributor)
Solution

Hi @sasrsc 

 

Give this a try: 

varname eq null

 

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

 

capture20200825164842745.png

 

Good luck

Damien

1 best response

Accepted Solutions
best response confirmed by sasrsc (Copper Contributor)
Solution

Hi @sasrsc 

 

Give this a try: 

varname eq null

 

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

 

capture20200825164842745.png

 

Good luck

Damien

View solution in original post