You’re offline. This is a read only version of the page.
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
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?
Kris, thanks a lot.
yes, "WLA" is the Person/Group type. Your formula helped.
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:
Within Condition 2 box, click "Edit in advanced mode", type the following formula:
Share
Report
All responses (
Answers (
@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
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
