Adding record owners' emails from sharepoint lists in CC in the Send email action

(0) Share

Report

Posted on by Konrad909090

Hi experts,
I have a flow in which I retrieve filtered records from a SharePoint list. I then use the Compose and Filter Array actions to collect the Approvers emails and send them information that they have an unapproved record in the SharePoint list.
The problem is that I also want to add the owners of the records from the person type column in the CC in the send email action.
I have come to the point where I am able to collect these emails but unfortunately they appear as a string between the " “ and \n character at the end, and I am unable to convert them to correctly add them in CC by separating them with a ”;".
At the moment my flow looks like this and what error I have(screenshot attached).

In steps Compose is trying to do join:
join(outputs(‘Compose_to_check_proper_Owners_emails’), ‘;’)

And in Compose step 2 it tries to replace characters:
replace(outputs(‘Compose’), ‘\n’, ‘’)

If more details are needed please let me know

Best regards,
Konrad

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi Konrad909090,

Here's how you can do it:

1. Initialise a Variable - PersonEmail of type Array

2. Add an Append to Array variable action and add the Person column in the Value section

3. Add a Compose action to join the email values in the Person column

4. Use trim to remove any white space and use the output from Compose in the CC field of your Send Email action

Intitialise Variable

Append Variable

Compose Expression:

join(variables('PersonEmail'),';')

CC Expression:

trim(outputs('Compose'))

And that's it. It puts multiple people in the CC section of your email.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Konrad909090 2 on at

Like (0)

Report

Hi @Nandit,
Thanks for your reply.

I ran into another problem in the process.
Trying to find a solution now how to add specific people in CC for a specific Approver.

The idea is that several records can be addressed to one Approver. I would like to give the relevant users in CC in a message to a specific Approver.
Are you able to help me with this?

Thanks in advance
Konrad

Was this reply helpful? Yes No