Unanswered

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

(0) Share

Report

Posted on by TORFS_BE

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

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.

Here is a detail of my flow so far;

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

Thank you

Categories:

Business Process Flows

All responses (2)

Answers (0)

TORFS_BE on at

Like (0)

Report

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

Hi @Expiscornovus

Thanks for the reply!!
I have created the column as you mentioned and named it "ExtraEmail" aswell.
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
Expiscornovus 31,758 Most Valuable Professional on at

Like (0)

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

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'])))