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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

 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
    Microsoft Employee 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
    Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 550

#2
Valantis Profile Picture

Valantis 390

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard