I'm trying to figure out how to appropriately set a person column in my sharepoint list. All of my attempts have been fruitless. I have a flow that is transferring data from an excel sheet to a sharepoint list. However, I've ran into an issue where I'm not able to set the Claims data properly.
My flow is as follows:
if(empty(outputs('Filter_approvers_array_(Update)')?['body/value']),null,concat('i:0#.f|membership|',outputs('Filter_approvers_array_(Update)')?['body/value'][0]['Mail']))
My logic here is if the body of the filter array action is empty, return null. Else, concatenate the claims syntax to the user's email.
The filter array returns the right person object with the correct email handle, it's returned as:
[
{
"ID" : "value",
"DisplayName" : "name",
"Mail" : "email",
...
}
]
The compose action yields no result apparently as nothing is populated into the action that actually writes the data to the sharepoint list. Something is going wrong in that compose action, but I'm not sure where I went wrong. Any thoughts? I'll provide more details if needed about my setup.

Report
All responses (
Answers (