web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / empty person/group col...
Power Automate
Unanswered

empty person/group column results in error of update item action

(0) ShareShare
ReportReport
Posted on by

 I am having 2 columns of "Person" type. Sometimes one of the columns is empty. And when it is so i started getting (like a wekk) error in "update item" action

Capture.PNG

basically my flow is:

-i get items for the last 30 days from my list

-after several conditions i update one of the items and sometimes get error if person column is empty.

 

Does anyone knows how to workaround this?

Categories:
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    on at

    Hi @Anonymous,

     

    Could you please share a screenshot of your flow's configuration?

    Could you please share more details about your SharePoint list?

    Further, is it the WLA column a Person or Group type column?

     

    The error message told that there is something wrong with the formula that you provided within your "Update item" action, the Claims property could not be selected based on the formula that you provided.

     

    I have made a test and the issue is confirmed on my side. I assume that the WLA column is a Person or Group type column in your SharePoint list, if the WLA column is empty, when you use the "Get item" action to get the correspodning item, the WLA column would return empty. In other words, if the WLA column is empty, the Approver Claims dynamic content would not be shown up within the result of the "Get item" action.

     

    In addition, you could consider take a try to add a Condition to check if the WLA column (Person column) is empty before the "Update item" action within your flow. I have made a test on my side and please take a try with the following workaround:1.JPG

     

    2.JPG

    Within Condition 2 box, click "Edit in advanced mode", type the following formula:

    @or(empty(body('Get_item')?['Approver']))

    Within Condition 3 box, click "Edit in advanced mode", type the following formula:

    @empty(body('Get_item')?['Executor'])

    Within Condition 4 box, click "Edit in advanced mode", type the following formula:

    @empty(body('Get_item')?['Executor'])

     

     

    Note: The Executor column and the Approver column are both Person or Group type columns in my SharePoint list.

     

     

    Best regards,

    Kris

  • Community Power Platform Member Profile Picture
    on at

    Kris, thanks a lot.

    yes, "WLA" is the Person/Group type. Your formula helped.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard