We want assign multiple SharePoint Security groups to the “Recipient email addresses” field in the “Send an email”-Action.
As of the related help-page, the variable types can be Text or Collection:
|Recipient email addresses||Email addresses for recipients of the email message that the action sends. Use commas or semicolons to separate multiple email addresses. Do not select a null variable.|| |
Does that mean, that we have to retrieve all users from all groups and put the email-addresses in a collection, which can then be assigned?
That would be a hack of work. In one business case, we have 7 groups and in one of the branches another 5 groups. This is a library with guidelines and if specific users are approving a guideline, an info mail will be send around the globe to the related groups (depending on language and scope).
Am I missing something, or is this a unwanted limitation?
With kind regards, Ronny
Best answer by GarrettView original
Nobody from Nintex???
As each group should have its own email alias e.g. email@example.com, you can just use that.
You don’t need to extract the users from the group.
To Field: firstname.lastname@example.org; email@example.com; firstname.lastname@example.org;
Note - Using %var% to signify a variable - Nintex O365 way.
%group_email% = “email@example.com; firstname.lastname@example.org; email@example.com;”
To Field: %group_email%
Sorry bro, my bad!
Create a workflow (run periodically) to extract the users email and build a string. Preferable save the string for re-use - SPO multiline column.
The NWC “Get members of a SharePoint group” action only list groups from the primary site and not document folders or lists.
PowerShell “Get-PnPGroupMember” cmdlet can also get the job done.
Uncertain about Power Automate
SharePoint REST API (see item 3)
The SharePoint REST API returns result as XML. so query the XML
OK, I see. I will follow: Create a workflow (run periodically) to extract the users email and build a string. Preferable save the string for re-use.
I will have a custom list with group names and related e-mail addresses, which will be updated through the mentioned workflow, running on a daily basis.
Too sad, we cannot assign multiple groups to the “Recipient email addresses” field in the “Send an email”-Action.
But thanks, anyway