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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Aprensivo 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Aprensivo 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Aprensivo 10 on at

Like (0)

Report

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...?

Was this reply helpful? Yes No