Approval Flow with multiple approvers - save all Approver Names in Sharepoint Column

Paula K 1 Reputation point
2020-08-27T21:57:55.157+00:00

I have an Approval Flow with multiple approvers. The flow has a document library in Sharepoint Online and I have a column for Approved By (name). I want to be able to update the Approved by column with each of the approvers names, currently it's only showing 1 name - I think it's the last approver.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,143 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Jerry Xu-MSFT 7,941 Reputation points
    2020-08-28T07:33:08.723+00:00

    I assume the Approved By column is a people column which enables multiple value. In that scenario, we need to do a bit more work to update this field.

    We need to create a special array to Approvers in JSON.
    21182-image.png

    The input in compose variable is

    {
    "Claims": "i:0#.f|membership|@{items('Apply_to_each')?['email']}"
    }

    The output in apply to each action is the Approvers.
    21107-image.png

    One thing to mention, remember to change the people field to input entire array like the pic shows. Or you will not be able to add the array variable to it.

    0 comments No comments