@PBala the way I would do this is with a button on the SharePoint list to trigger the flow. You format the column and copy in the JSON code below but use your flow id from the browser address bar in place of my id shown in bold in the image.
The SharePoint list has a multi-select People column called People.
The JSON code is:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"txtContent": "Send Email",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"e0e5590c-68c9-40a6-ae6e-dc7f8ac6afd0\"}"
}
}
Then in the flow the trigger is a SharePoint For a selected item. The first action is to Initialize a variable, give it a name and set it to String.
Next, add a SharePoint Get item action and select ID from the dynamic content.
Then add an Apply to each and select People from the dynamic content.
Inside the apply to each add an Append to string variable, select the variable you initialized earlier and in the Value field select People Email from the dynamic content. Add a semi-colon after it.
Still inside the apply to each add the Send an email (V2) action and in the To field select the variable.
A separate email will be sent to each person in the People column.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
