Multiple Person field emails

(1) Share

Report

Posted on by smodkins

Hi team,

I have an onboarding tracker in a SharePoint list. The Line Manager is recorded in a single person field and the dynamic content is added to the to field when sending comms in relation.

I want to add an additional multi person column called MultiPersonCC which is a multi person column for additional recipients to be CC'd into comms but this field is not always going to contain a value. What actions do I need to add to extract the emails with a ; separator to add to the CC field?

It's worth noting for the purpose of this I have multiple flows connected to this with different triggers so the solution needs to be able to work for all.

I have:

SharePoint: When an item or file is modified
SharePoint: When an item is created
SharePoint: For a selected item
SharePoint: Get items

Thanks

smods!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (0)

Report

Hi @smodkins

Please in the future to post your Flow, and a Flow Run if you are having issues with inputs and outputs and errors etc.

1. Why are you placing 2 Triggers in the same flow (it';s a guess based on your post and me guessing details), you should not do this.

How to Concatenate a Person Column Email String in Power Automate | 2023 Tutorial

You can use a Condition to check if the field is Empty, or you can use a Compose with an if expression or other to check.

I suggest you create a Condition to check if the field is empty

IsEmpty(field)

is equal to

false

I said false because if its NOT empty, in the Yes, you want to concatenate the names and then email

In the No dont do anything.

Was this reply helpful? Yes No
smodkins 85 on at

Like (0)

Report
Hi @Michael E. Gernaey,

Thank you for replying and pointing me in the direction of that useful YouTube video. When I talk about different triggers I mean within different flows all linked to the same tracker.

For my flow which has the trigger SharePoint: When an item or file is modified I followed the video and added the two steps as shown here.

I then used the expression below in the CC field on the Send an email V2 action rather than a condition as I wanted the email to always send regardless of if there were additional recipients or not.

if(empty(outputs('Compose_Additional_Recipients_Emails')), '', outputs('Compose_Additional_Recipients_Emails'))

This one is resolved ✅

On my SharePoint: Get items which is on a recurrent schedule I am slowly getting there but getting myself confused with the apply to each and it's getting clunky.

I have the same expression in the optional attendees field:

if(empty(outputs('Compose_Additional_Recipients_Emails')), '', outputs('Compose_Additional_Recipients_Emails'))

This is working correctly BUT there is a mid point probation apply to each below and then the two will be repeated in the yes field condition. Do I need to repeat the Select and Compose in all four apply to each actions? Is there anyway I can have a single select and compose action at the top that feeds all four apply to each actions? I did try it but each time it put multiple apply to each actions in.

Thanks and if you need any further information, please let me know.

Was this reply helpful? Yes No