SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1601322%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20do%20a%20ODATA%20filter%20in%20Power%20Automate%20to%20check%20for%20a%20missing%20person%20field%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601322%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20seen%20some%20old%20posts%20on%20other%20sites%20that%20seem%20to%20indicate%20you%20can't%20do%20an%20ODATA%20filter%20in%20Automate%20for%20a%20person%20field%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20particular%20case%20I%20want%20to%20get%20any%20rows%20where%20varname%20is%20missing%3C%2FP%3E%3CP%3E(varname%20is%20a%20person%20field).%3C%2FP%3E%3CP%3ECan%20it%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20can%20be%20done%20can%20you%20also%20share%20an%20example%20for%20a%20ODATA%20field%20looking%20for%20a%20particular%20email%20address%20such%20as%20where%20email%20address%20for%20varname%20%3D%20%3CA%20href%3D%22mailto%3AMickey.Mouse%40Disney.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMickey.Mouse%40Disney.com%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EODATA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1609845%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20do%20a%20ODATA%20filter%20in%20Power%20Automate%20to%20check%20for%20a%20missing%20person%20field%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1609845%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756131%22%20target%3D%22_blank%22%3E%40sasrsc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20this%20a%20try%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3Evarname%20eq%20null%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20not%20make%20it%20an%20expression%20and%20do%20not%20use%20'%20'%2C%20simply%20type%20null%20as%20normal.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22capture20200825164842745.png%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214579i9DAF8F78E79DB0CA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture20200825164842745.png%22%20alt%3D%22capture20200825164842745.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610460%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20do%20a%20ODATA%20filter%20in%20Power%20Automate%20to%20check%20for%20a%20missing%20person%20field%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3BSimple%20when%20you%20know%20how%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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 = Mickey.Mouse@Disney.com 

2 Replies
Highlighted
Best Response confirmed by sasrsc (Occasional 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

Highlighted