Hello,
I have a stable workflow that generates a Teams message and an email with response option when assigning an individual to an uploaded file on SharePoint. All of that works great--when I'm only assigning one person to initiate it.
The SharePoint column is set to allow multiple selections, as I want the option to generate this workflow to multiple people when inserting them in the Assigned To column. The issue lies here:
In the flow recipient boxes, the only way I get this workflow to do what I want be stable every time is code it like this:
Assigned to:
first(triggerBody()?['AssignedTo0'])?['Email']
However, that code obviously doesn't register any additional assignees that are assigned in the column. The assigned people are also not separated by commas OR semicolons. Instead, they are pulled up in a tab of people in my company that I can select. Long story short, I have not found out a way to code or insert a new action to register that multiselect option.
I've been working on this flow for about a week, and as it started as an array that broke intermittently, I'm trying to avoid that or anything that may mess up the current flow.
Below are selected code options I have tried in place of it:
join(triggerBody()?['AssignedTo0'], ',')
replace(triggerBody()?['AssignedTo0'], ',', '\n')
split(triggerBody()?['AssignedTo0'], '\n')
join(triggerBody()?['AssignedTo0'])?['Email']
{first(triggerBody()?['AssignedTo0'])?['Email']};@{join(skip(triggerBody()?['AssignedTo0'],1), ';')}
concat(first(triggerBody()?['AssignedTo0'])?['Email'], ';', join(skip(triggerBody()?['AssignedTo0'], 1)?['Email'], ';'))
Any tips would be greatly appreciated!!!