Microsoft flow move items based on dropdown selected value new item form include multi person field

Question

I want to create a flow to move items from one list to another list based on dropdown selected value, i have created a flow it is working fine but the challenge is, the new item form includes person or group filed with allow multiple selections as 'Yes'. if this field has more than one value the flow is creating multiple entries. My requirement is to create only one item including all the values in person or group how it happens in the source form. Any help would be really appreciated. should also required a help for email flow in a same way to trigger only one email for one entry.

Answer 1

Here is the solution of your problem.

Steps of your flow should be like this,

1. Put your trigger as-is Create and modified && Opportunity status=Closed,
2. Initialize variable, PersonId type must be array
3. Apply to each on variable Assignee(Multi person field)
4. Send an HTTP request to SharePoint -> Get method -> https://coffee.sharepoint.com/sites/lorem/_api/Web/SiteUsers/getByEmail('Email') -> email address from Assignee(Multi person field)
5. Append to array variable -> PersonId -> body('Send_an_HTTP_request_to_SharePoint')['d']['id'] -> Send_an_HTTP_request_to_SharePoint name must match the name of 4th step because it is formula
6. Compose -> PersonId
7. Send an HTTP request to SharePoint -> Post method -> https://coffee.sharepoint.com/sites/lorem/_api/web/lists/getbytitle('ipsum')/items ->

Headers,

{
   "Accept": "application/json;odata=verbose",
   "Content-Type": "application/json;odata=verbose"
}

Body,

{
   "__metadata": {
      "type": "SP.Data.YourListNameListItem"
   },
   "Title": "Lorem", //you can use dynamics variables here
   "Opportunity": "Closed",
   "AssigneeId": {'results':@{outputs('Compose')}} //multi person field == Assignee
}

Reference, How to patch a multi-person field from one SharePoint list to another