Forum Discussion

Brass Contributor

Aug 30, 2023

Sending email to sharepoint group in power automate

Hi Team, We have one group with 500 users, We are getting the users from the group and sending the email This is not working as expected, It taking time more than 5 hours to get the users and...

Microsoft Flow

sharepoint

SvenSieverding

Bronze Contributor

Aug 31, 2023

Hi DJoshi2302 ,

You could use a Rest API call to "/_api/SP.Utilities.Utility.SendEmail".

You can send an email to all members of a group (named "SharePoint Group" in my example) in one go.

{
    'properties': {
      'To':['SharePoint Group'],
        'Body': '<h1>Hello Group</h1>',
        'Subject': 'Hello Group'
    }
}

Best Regards,
Sven

DJoshi2302
Brass Contributor
Aug 31, 2023
SvenSieverding

Thank you for your reply,

We used the below approach but in our SharePoint group, there are more than 1000 users present.
In the below approach, it is showing success in the below action but users did not receive the emails

Thank you and best regards
- SvenSieverding
  Bronze Contributor
  Aug 31, 2023
  Hi DJoshi2302 ,
  
  ok....in that case you should think about creating a "mail enabled security group" in Exchange/Azure AD and put all your users in there.
  
  Then you would have a security group you can put into your SharePoint group for handling permissions. And you would have one mail address to send the your mail to, That will be delivered to each group member.
  
  Best Regards,
  Sven