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 / text from list into bc...
Power Automate
Suggested Answer

text from list into bcc field in an email

(0) ShareShare
ReportReport
Posted on by
How do I make sure the content of a text field is in a format that can work in the To: CC: or BCC: fields in an email message.
Categories:
I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    2,816 on at
    If email addresses come from Excel, SharePoint, Forms, or Dataverse:
    • Validate the field is not empty.
    • Remove unwanted spaces.
    • Ensure addresses are separated by semicolons.
    • Pass the resulting string to the To, CC, or BCC field.
    Example expression:
    replace(trim(variables('RecipientList')), ' ', '')
    This produces a clean recipient list that Power Automate can use successfully in email actions.
  • Suggested answer
    Vish WR Profile Picture
    3,507 on at
     

    Email actions basically just want a clean string with addresses split by semicolons. So the trick is to tidy up your text field before you pass it in. Something like this does the job:

    replace(trim(variables('RecipientList')), ' ', '')

    That trims the ends and pulls out any random spaces that snuck in.

    Couple of things I'd double-check too:

    If the field comes back empty the send step will throw an error, so it's worth guarding against that

    Stick to semicolons between addresses — commas will break it, Outlook's picky like that

    And if your addresses are actually spread across multiple list rows instead of sitting in one field, you'd grab them with a Select and join() them together rather than this approach

    Once you've got that clean semicolon string, just drop it into To, CC or BCC and it'll send fine

      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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 389

#2
Vish WR Profile Picture

Vish WR 331

#3
David_MA Profile Picture

David_MA 298 Super User 2026 Season 1

Last 30 days Overall leaderboard