cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Update Item when Person/Group Field is empty

empty Value.jpgCondition.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Anonymous 

 

Please see below. Here 'TestPerson' is 'Person or Group' column type. I have used a compose to map the output. Then in next step I have added an IF condition to check using the below expression

 

length(outputs('Compose'))

 

image.png



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!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

14 REPLIES 14
abm
Super User
Super User

Hi @Anonymous 

 

Could you please explain what you trying to do? All I can see here is a screenshot not description about your issue.

 

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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

I want to update my SharePoint list when the Author does not enter a email in my PeerReviewer Column.

 that is a multiple select (Person/Group) column. When I put in the Condition PeerReviewer is equal to 

empty(triggerOutputs()?['body/PeerReviewers/Email']). it does nor update the List.

Hi @Anonymous 

 

Try the below expression

 

empty(triggerOutputs()?['body']['PeerReviewers']['Email'])

 

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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

I get a Greyed out condition

Anonymous
Not applicable

Blank Condition.jpgCondition 2.jpg

abm
Super User
Super User

Hi @Anonymous 

 

Please see below. Here 'TestPerson' is 'Person or Group' column type. I have used a compose to map the output. Then in next step I have added an IF condition to check using the below expression

 

length(outputs('Compose'))

 

image.png



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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

I added 

length(outputs( 'Compose' ))

But still get greyed output

 

compose.jpglength(outputs( 'Compose' )).jpg

abm
Super User
Super User

Hi @Anonymous 

 

That means you having no records returning from your step "Get File Properties - For Peer Reviewers". Check the run history and see the data.

 

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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

When I check my history I can see the Data and my PeerReviewers results has [ ] as the value

 

peer reviwer.jpg

Hi @Anonymous 

 

Check your apply to each mapping value?

 

image.png

 

Is that correct?

 

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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

Yes i have I have the Value correct. If I add a email in the PeerReviwers column the condition runs.

Hi @Anonymous 

 

 

You mentioned earlier results has [] as the value. This means there is no data under PeerReviewers column.

 

image.png



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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

Yes That's correct I want to update my item if their is no data in the column, but when know data is in the column the condition is greyed out.

Anonymous
Not applicable

I got it to work using the length(outputs( 'Compose' )) equal to 0

 

lenghth.jpg

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,957)