Power Platform : Power Automate – How to verify whether value is available for Person column in SharePoint list – for single value selection or multiple selection

Power Platform - Power Automate - Flow to demonstrate validation on Person column with single value selection and multiple value selection
Power Platform - Power Automate - Flow to demonstrate validation on Person column with single value selection and multiple value selection

Hi All,

Greetings for the day!!!

Today again small sharing !!!

As me and my team took bit good amount time to verify the conditions for Person type column either single value selection or multiple value selection. So thought to share though it was very simple. SHARING IS CARING 🙂

Details

  • We have one SharePoint list in my demo tenant – “Power Automate – Test Person field” with some of the following columns like (there are other columns as well)
    • Title
    • User – Person – with single value selection
    • Users – Person – with multi value selection
Microsoft 365 - SharePoint Online
fig : Microsoft 365 – SharePoint Online – Demo list – with two Person columns – single value and multi value respectively
  • List schema
Microsoft 365 - SharePoint Online
fig : Microsoft 365 – SharePoint Online – Demo list – with two Person columns – single value and multi value respectively – List schema
  • On new item creation in given list we need to trigger Power Automate

Power Automate

  • In Power Automate we need check if value in “User ” column is specified or not while creating the item – that means any user is specified or not in this column
  • To check the value of Person – single selection column we just need to check either empty value OR null in condition control as
Power Platform - Power Automate
fig : Power Platform – Power Automate – Verifying the condition for single value Person column

OR

  • Just check for blank / empty value as in below figure
Power Platform - Power Automate - Verifying the condition for single value Person column (verifying the presence of user in column)
fig : Power Platform – Power Automate – Verifying the condition for single value Person column (verifying the presence of user in column)
  • For multiple value selection Person column, in Power Automate we get array as , there are two users selected in list item
fig : Power Platform – Power Automate – Result of multi value Person column – Two users are selected in litsitem column
  • Since we have array of result we can user the length() under Expression – to check if respective columns have values or not as – that means users are selected or not
Power Platform - Power Automate - Condition to check if there are users in multi value Person column
fig : Power Platform – Power Automate – Condition to check if there are users in multi value Person column

Complete Flow

Power Platform - Power Automate - Flow to demonstrate validation on Person column with single value selection and multiple value selection
fig : Power Platform – Power Automate – Flow to demonstrate validation on Person column with single value selection and multiple value selection

Thanks for reading the article !!! Please feel free to discuss in case any issues / suggestions / thoughts / questions !!!

HAVE A GREAT TIME AHEAD !!! LIFE IS BEAUTIFUL 🙂

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: