web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : yTFg5+FgeyWOxpxbuvrXGJ
Power Automate - Building Flows
Unanswered

sending emails to addresses in a sharepoint list

Like (0) ShareShare
ReportReport
Posted on 18 Feb 2020 12:02:10 by 48

Hello there.....I have a sharepoint list of supplier emails shown above (Supplier List).   I have another list of customers with specific information (CBX).  I want to build a flow that will take the pertinent information in the CBX list and email it to the addresses in the [Contact Email] of the Supplier List. 

 

The problem I am running into is that the email addresses, {Contact Email] in the Supplier List do not show up as selections in the dynamic content.   Is there a special set of sequences I need to follow to send emails to addresses in sharepoint lists?

 

cbx.PNGCapture.PNG

  • Leo_NYC Profile Picture
    48 on 21 Feb 2020 at 02:48:12
    Re: sending emails to addresses in a sharepoint list

    I need any team member to be able to run this flow and it looked like I had to have each team member sync the contact list to to their outlook accounts.  

     

    What I wound up doing is creating a new group called "Energy Suppliers" and added all of the emails of the suppliers as "guests" of the group.  Then their emails were showing up in the "person" column types and I could send emails to them.  So right now the suppliers, if they ever visited the group would wind up knowing who their competitors are.  I wonder if I can make them guests without giving them the ability to actually access or visit the group?  In that way I can keep their identities semi-anonymouse.

     

  • Jcook Profile Picture
    7,779 Most Valuable Professional on 18 Feb 2020 at 19:59:10
    Re: sending emails to addresses in a sharepoint list

    Hello @Leo_NYC 

     

    When checking for dynamic content, you can click the 'See more' option on the dynamic list.

     

    This can be seen in your screenshot that you uploaded.

    Where it says Get Suppliers List in the dynamic content popup, click  'See more'

     

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 18 Feb 2020 at 13:51:28
    Re: sending emails to addresses in a sharepoint list

    hi @Leo_NYC  please after you get your supplier List create an Compose conector with your [Contact Email] and then try to call it as output in your send an email conector.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete