Power Platform Community Forum Thread Details

I am looking for ideas on how to automate a task. Here is my situation, I have a SharePoint list of emails and I want to use the list to make a distribution list on Outlook. I talked with my IT department and I was told that SharePoint and Outlook currently don't have that option. If you have any ideas or experience with this, I'd like to hear from you. Thanks!

Categories:

Building flows

You can try this process

Concept

Use Power Automate to read email addresses from your SharePoint list and send an email dynamically to those recipients (without creating a formal DL).

How it works

Create a flow with a recurrence trigger (or a manual trigger).
Use Get Items (SharePoint connector) → your email list.
Use an “Append to string variable” loop to combine all addresses into a semicolon-separated string.
Use that string as the To: field in a “Send an email (V2)” Outlook action.