Forum Discussion

RBInsightsDelivery23's avatar
RBInsightsDelivery23
Copper Contributor
Mar 30, 2023
Solved

SharePoint - Create user list and send emails

I send out update emails to hundreds of employees biweekly, but the current process is VERY manual. Right now, I just send out the email to the MS Office group and then upload the same details to our...
  • ganeshsanap's avatar
    Mar 31, 2023

    RBInsightsDelivery23 Here's an initial & easy solution you can try for now:

    1. Create a Power automate flow which will run when new item is created in SharePoint list
    2. Use Send an email outlook action in flow to send email notification to M365 group
    3. Create item in SharePoint list to test it.

    You can start with this Power automate flow template (use outlook instead of Gmail): Send an email on new SharePoint list item creation 

    Also, refer this flow template (use item creation trigger only): Send email to Office 365 Group members when a SharePoint item is modified 

     

    Then later you may try to automate distribution list subscription using Power automate flows to add/remove users from M365 group.


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources