Specifying a mail recipient based on a SharePoint list column with multiple choice answers

(0) Share

Report

Posted on by Aprensivo

Hi there,

I am wondering if somebody could help me.

I have got a Sharepoint list with various columns - one of them is a checkbox that allows multiple answers: Harry, Meghan and Charles.

In the example, I would like Power Automate to check which were selected, and then based on the selection compose and send an email to them, where the email address are as follows:

- Meghan: meghan.m@gov.uk

- Harry: hprince@help.com

- Charles: login@domain.com

PS. I hold the the corresponding email addresses in variables varMaghan, varHarry and varCharles.

Could somebody share an easy way to do it - or hard way, if "easy" is not an option 🙂

many thanks...!

All responses (6)

Answers (0)

Aprensivo 10 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

Sorry for not making myself clear, I really appreciate your patience! I hope the below will help

My SharePoint's list column:

My variables:

I want the flow to:
1. check who was chosen in the sharepoint list (Harry, Meghan, Charles, or any combination of them)
2. send an email based on who was chosen in that list like below, but the "To" should be based on the check done in step 1.,

Have I made it clearer or just muddied the waters more...?
RobElliott 10,166 Super User 2025 Season 1 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

Sorry, I don't understand that at all. How are you setting the variable value?
Aprensivo 10 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

Again apologies! The actual email addresses are actually a string value of the variables I mentioned above. From end user perspective, I do not want them to choose actual email addresses, but choice of values of WHO they want to email without revealing the email addresses.

I will be the first one to say it may be clumsy! 🙂
RobElliott 10,166 Super User 2025 Season 1 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

.. but you must be getting the email addresses from somewhere and not adding them in manually. So where is that? Please don't say you are adding them in manually!
Aprensivo 10 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

I missed giving you that info - maybe not the best practice, but I hold the the corresponding email addresses in variables varMaghan, varHarry and varCharles.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Specifying a mail recipient based on a SharePoint list column with multiple choice answers

Where do you store the email addresses? I mean if I choose Harry, how would the flow know Harry's email address?