Send an email flow from a sharepoint Lookup Field getting all the related email addresses.

(0) Share

Report

Posted on by JJ8810

Hi Everyone,

this is my first time using this forum, i need some help please.

i am building a solution for my company, where we have a Client list with Company name and Email addresses, and i have a communication list where i have a lookup field to the Client list [Company Field], what i want to achieve is to select the company name in the lookup field and have a email field populate all the email addresses who we have captured on the client list for that company in a string can someone assist please

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report
Use the get items step, and filter by using a formula similar to this:

Name eq 'VALUE'

This will then get you the correct row and you can then get the email-adress from there.

Was this reply helpful? Yes No
Verified answer

JJ8810 30 on at

Like (0)

Report

Thanks for the Feedback, below is sample information on the lists I have, The one is our Client List where we capture all out clients we work with, the second list is the communication list, (all sample lists as i may not share any real data), so on my Communication list i have a look up field, and i would like to be able to distinct the information on the lookup to show only 1 instance of the company name, and in a new cell ( next to the company) import all the related email addresses, I have a flow that send an email when a new item is created, but at the current moment I have it set to email address select multiple, and then it send one email to per person selected, and does not send one email to all clients selected. I hope this makes better sense, i have also added my flow i am using

Was this reply helpful? Yes No
JJ8810 30 on at

Like (0)

Report

I Have Tried this and getting an error, i am still very new to flows and can only do the basics

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report

Hi @JJ8810 ,

Unfortunately, we cannot deduplicate the lookup column of the Sharepoint table, because it is bound to the ID.
For your other needs I have a test that I hope will help you.
In my scenario, when I create a new row in list2, flow will filter list1 according to the value selected in the lookup column, and then store all email addresses in list2.

Best Regards,
Dezhi

Was this reply helpful? Yes No