web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint column mult...
Power Automate
Answered

SharePoint column multiple assignees that trigger workflow

(0) ShareShare
ReportReport
Posted on by 10
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!!!
SharePoint+Teams ...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)
  • Suggested answer
    Raymen Deol Profile Picture
    75 on at
    Hi, 
     
    I believe AssignedTo0 is an array of "person" objects , you need to extract each persons email before joining.

    Try this:
    • Add Select action
      • From: triggerBody()?['AssignedTo0']
      • Map: switch to text mode and use item()?['Email']
    • You can then use join(body('Select'), ';') in your teams/email recipient field or wherever you need this.
      • It's best to join using ; for outlook recipients
    I didn't have time to actually test this but it should get you most of the way there.
     
  • Suggested answer
    Vish WR Profile Picture
    3,257 on at
     

    @Raymen Deol Select action approach is correct. Here's the thing, though , if you want each assignee to get their own individual Teams message and email (not one combined email to everyone), the Select + join approach won't cut it. You'd need an Apply to each on the array instead.

    So it depends on what you actually want:

    If one email/message to all assignees together, Raymen's way works — Select action to pull out the emails, then join(body('Select'), ';') in the To field.

    If each person gets their own separate notification, skip the join and just loop through triggerBody()?['AssignedTo0'] with Apply to each, then use items('Apply_to_each')?['Email'] in your send email / Teams action inside the loop.

    Given your flow already works for one person, the Apply to each route is probably cleaner since you're just wrapping your existing send actions in a loop rather than rebuilding how recipients work.

     

    Vishnu WR
     
    Please âœ… Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like â™¥
  • CU19052155-0 Profile Picture
    10 on at
    @Vish WR thanks SO much for this guidance, it finally worked! I am so relieved. This was the only thing that worked, no issues!
  • Vish WR Profile Picture
    3,257 on at
     
    Glad it worked. Thanks for marked as verified 
     
    Vishnu WR
     
    Please âœ… Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like â™¥

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard