Create distribution list from a SharePoint list

Loubnielsen 

I figured out an alternative solution to creating a workflow that might work.

1. Create your contact list in Sharepoint

2. Return to Classic SharePoint -> List -> Connect to Outlook

3. Accept to connect list to Outlook

4. Outlook should open with the Sharepoint list in the Contacts section. At this point I moved the list into the "Other Contacts" folder to keep it visibly separated 

5. Create a new folder under "My Contacts" (Right click on your email account and select New Folder).

• Name it whatever you want
• Folder Contains: Contact Items

6. Copy the contents from the "Other Contacts" list from step 4 into you new folder from step 5

7. Once copied over, create a New Contact Group

8. Name it whatever you want (I found prefacing the name with a 1. will keep it at the top of any list and easy to find) -> select Add Members

9. From the Address book drop down locate and select the contact folder from step 5

10. Select all -> click Members -> Ok...save and close your new contact group

Now, when you go to compose a new email, To -> Locate and select step 5 contact folder from Address Book drop down ->Click on the Distribution list you created in step 10

Currently I have alerts set up on my Sharepoint list to let me know of any changes. I am then triggered to go into my contact folder from step 5, delete its contents and re-copy/paste the freshly updated list from step 4. Repeat steps to create the distribution group etc...

Loubnielsen Couple years late to the party, but since I was looking for roughly the same answer I figured I'd chime in, in case someone else was looking for my solution.

- Create an empty Outlook Group "examplegroup@test.com"

- Created a MS Flow with a "When an Item is created" trigger. Link to the SharePoint that the list resides

   - "Add member to group"

       -Group Id: "examplegroup@test.com"

       -A user AAD ID for the user to **bleep** to a team: Title

          Note: I changed the name of the title column to Email. Otherwise it might be something like Name Email. Play with the Dynamic content options till you find the right variable.

Now I just use the group email as the distro.

P.S. I made a second Flow to remove someone. It's almost identical except for instead of "Add member to group" its "Remove member from group"

P.P.S. pro tip: since the distro is being stored in an Outlook group instead of SharePoint list, I find it best to also have an action to "Delete item" at the end of the flow so there isn't an option to double up on anything when triggering the flow.

Hi Loubnielsen 

The best way I can think to achieve this is to use Microsoft Flow.

You can create an Office 365 group in Flow and get emails from SharePoint list and add to the group. 

Then you can send emails to that group.

Depends on the permissions you have I suppose. As an "end user", you can sync the list to Outlook, copy the addresses to your contact list and create a "contact group", which you can then address. If you want others in the company to be able to use the group, you will have to create it as a Distribution group in the GAL, and for that you need the necessary permissions on Exchange side.