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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send an https request ...
Power Automate
Unanswered

Send an https request recipient from sharepoint list with multiple selection field.

(0) ShareShare
ReportReport
Posted on by 4

Hello,

 

First time posting here.  I find PowerAutomate really useful and tried using it in organizations for some workflows.  I have a SharePoint list that will trigger a notification to different users (Creator, Director, and CC-multiple selection field).  

 

I'm using the 'Send a https request to Sharepoint' for notification so the message will be sent out by SharePoint.

 

My issue is how can I add the CC recipients without it doing 'apply to each'.  I just want all CC recipients in one email.

 

Thanks

 

mavl_1-1655187190344.png

 

 

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,194 Most Valuable Professional on at

    Hi @mavl,

     

    Is your cc-multiple selection field of type person or group?

     

    If so, you could use a Select action to only retrieve the e-mail addresses from that array. With an expression you could join these items of the array into a comma separated string value.


    Below is an example of that approach.

     

    1. Add a Select Action

    In the Select action select your Recipients field (collection). Switch the Map field to text mode. And use the expression below.

     

    concat('"',item()?['Email'],'"')

     

     

    2. Update your Send an HTTP request to SharePoint action.

    In your body use the following expression for the CC field to join the e-mail values into a string value

     

    join(body('Select'), ',')

     

     

    Below is an example of the whole body value:

     

    {
    "properties":
    {"__metadata": {"type":"SP.Utilities.EmailProperties"},
    "From":"",
    "To": {"results":["@{triggerOutputs()?['body/Author/Email']}"]},
    "CC": {"results":[@{join(body('Select'), ',')}]},
    "Subject":"eTracking slip - @{triggerOutputs()?['body/Title']} ",
    "Body":"Details are as follows:<br /><br />"
    }
    }

     

     

    ccmultiplerecipients.png

     

    This example assumes you have a person or group column setup like below:

     

    recipients_example.png

     

  • mavl Profile Picture
    4 on at

    Hi @Expiscornovus ,

     

    Thank you for the reply.   Yes, the CC field is a multi-selection person or group.  I've tried to follow the instruction you set, but I have this error for the 'select' after running the test.  "The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array."

    mavl_2-1655271480533.png

     

    I really appreciate your help.  Thanks!

     

     

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard