Unanswered

Checking if SharePoint Person Field is Blank

(0) Share

Report

Posted on by Shado42

I have a basic flow that checks to see if various fields are blank when a list item is added or updated. Four fields are hyperlinks and one is a person field. I'm using a series of conditions that checks to see if each field is equal to the expression Null. It works fine for the hyperlinks. However, it always shows the person field as containing data, even when it's a new record where no information was selected for that field. I know the person field in SharePoint is technically different since it's a look up. How can I best check to see if my person field is empty? I don't care what data is actually present. I just need to delineate between nothing has been selected and something has been selected.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

Re: Checking if SharePoint Person Field is Blank

hi @Shado42 please try this option

lenght counts the characters of your field, so if you have 0 it means emty.

Was this reply helpful? Yes No
Shado42 5 on at

Like (0)

Report

Re: Checking if SharePoint Person Field is Blank

Thank you, @ChristianAbata.

I was able to use that to get to a workable solution. What I found interesting is that even on an empty person field in SharePoint, it still returns 2 characters. In my case, I simply set my condition for 2 characters or less and it worked. I know there is a lot that goes on behind the scenes for that type of field. When I added my name (11 char), the total shot to 380. I don't think I'll ever have to worry about a valid name being 2 char or less.

Was this reply helpful? Yes No