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 / Add value of column to...
Power Automate
Unanswered

Add value of column to the "TO" field in "Send an Email v2"

(0) ShareShare
ReportReport
Posted on by

Hi

 

We've got something set up with the help of the community to give us reminders when contracts(files) will expire.

Now, we would like to add something extra to make it even more future proof.

 

I got a sharepoint library setup and I would like to add an extra column where people can add an extra email adres that will receive a reminder for it. 

Note that this is not mandatory

 

TORFS_BE_0-1705930533408.png

 

 

Inside my flow im using the "Send an email (V2) 2".

What I would like to achieve is to get the value (text) of the column (valid email adres) to be added as an extra person/mailbox to receive the reminder in the "TO" field.

 

TORFS_BE_1-1705930533624.png

 

Here is a detail of my flow so far;

Let me know if you need additional info about the current flow.

 

TORFS_BE_2-1705930641647.png

 

 

Thank you

 

 

 

 

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

    Hi @TORFS_BE,

     

    You can check if this extra column is empty or not. If it isn't you can concat the extra email with a ; character to the To field.

     

    Below is an example

    In my example the extra email column is called Extra Email and is of type text.

     

    concat(item()['Author/Email'], if(empty(item()?['ExtraEmail']), '', concat(';',item()?['ExtraEmail'])))

     

    authoremailexample.png

  • TORFS_BE Profile Picture
    on at

    Hi @Expiscornovus 

     

    Thanks for the reply!!

    I have created the column as you mentioned and named it "ExtraEmail" aswell.

    TORFS_BE_0-1706082269244.png

    I tried to place an email adress in one record (pure text) as a test but it didn't work.

    My flow ran successfully but it didn't add the extra email adress I mentioned.

    When I check the output (detail) of the flow I can see it only send out the email to the author.

     

    It seems it doesn't look or place the ";" to add another Email?

    Is there anything we could try to finetune? 

     

    Thank in advance!!

     

    Best regards

    Brian

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 267 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 196

#3
Haque Profile Picture

Haque 182

Last 30 days Overall leaderboard