cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chriss1982
Level: Powered On

Check if people field is empty

Hi all, 

I want to execute a flow, only if a people field is not empty. 

I´ve tried this solution with the length expression,  but I still get an error message (unfortunately not in english)

The expression is:

length(item()['Responsible_x0020_Manager'])

flow1.PNGflow2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Check if people field is empty

@Chriss1982 

Please see my solution below.  I have a person or group column titled PG and I am checking for a null value in the email.  I have tested this solution and it works as intended.

 

PGNull.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Check if people field is empty

Hi @Chriss1982 

 

Check this post

 

https://powerusers.microsoft.com/t5/Building-Flows/Flow-Condition-If-Field-is-Blank/m-p/136853#M1354...

 

 Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Super User
Super User

Re: Check if people field is empty

@Chriss1982 

Please see my solution below.  I have a person or group column titled PG and I am checking for a null value in the email.  I have tested this solution and it works as intended.

 

PGNull.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Community Support Team
Community Support Team

Re: Check if people field is empty

 

Hi @Chriss1982 ,

 

Could you share all the screenshots of the Flow configuration?

I noticed that you used item()['Responsible_x0020_Manager'], so the references seem to need to be included in Apply to each, or in Filter array.

Please provide us the source of this field value, whether it is the output of the trigger or the output of other actions.

 

If it comes from a trigger, then the expression needs to be:

length(triggerBody()['Responsible_x0020_Manager'])

If you come from Get items action, then this Condition needs to be configured in Apply to each, just like the methods involved in the link you provided.

Also please need to ensure the correctness of the field name Responsible_x0020_Manager.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Chriss1982
Level: Powered On

Re: Check if people field is empty

Hi @ScottShearer,

 

thanks for sharing your solution.

It works with Email and Display Name as well. I´ve choosed the Displayname, because this is the one, which I´ve tried to validate.

 

Also thanks to all others for your thoughts.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,463)