Get sharepoint group email

Hi
I have a list of tasks that have Sharepoint Groups assigned to the Send Reminder To column who need to receive an email when the task is coming due. Multiple tasks could be due on the same day.

I have the flow that gets the items and sends an email however I’ve had to hard code the email addresses.
image

I want to be able to send to the members of a sharepoint group.

How can I get the sharepoint group id into a variable that can then be used in the Uri field _api/web/sitegroups(variable_here)/users of a Send an HTTP request to SharePoint

image

I want to incorporate the second flow into the first flow diagram in order to get the email addresses.

There may be multiple Sharepoint Groups in the “Send Reminder To” column.

I only want 1 Summary email to be sent with all the items that are due on that particular day to with all the members of the sharepoint group in the To box.
I don’t want 1 email per task per email address

Any help greatly appreciated

1 Like