
Announcements
Hi,
I am trying to update a multi-person column using the output of a filter query. However, I can't figure out how to convert the output to a proper Array structure.
I want to convert the below output (left) to the desired outcome shown in Screenshot on the right (Sponsor) so that I could use it to update a multi-person column.
Screenshot for my flow setup.
I can't use the output of select in Append to Array Variable as this action combines the multiple people together which makes it useless in Append to Array Variable.
Hi @MaanR
Try the below steps:
1. Declare an array.
2. Construct an Apply to each to read the body output (your screenshot left hand side one)
3. Inside the loop add a compose action step and add the following:
{
"Claims":item()
}
Note: Above item() must be add as an expression.
4. Next Append the array using output from the compose step.
5. Finally map the array variable for the update.
Thanks