Correlate files to permission groups in SharePoint

(0) Share

Report

Posted on by CarlesMartin

399

Hi guys!

What I am looking for is when I have tons of files, relation them to groups so when I want to send a mail, adding the group it sends to all the people in that group. Ones in "to" and others in "CC".

Example: I want to send a Transmittal note with 4 files. So what i created was a template mail that looks like this. This creates an item with all of the info inside and the files attached. Later, creates a folder in a library with them attachments. Finally, I want to send a mail but dont know what to add or how to do it to create those groupes and be able to send it to different people.

The flow looks like this

Then the other flow which sends the mail is this one:

How should I do it? What I have to change?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

I don’t quite understand what you’re trying to achieve. It might be helpful to have someone at your workplace review your post to see if they can help clarify your goals for someone who isn’t familiar with your specific process.

Was this reply helpful? Yes No
CarlesMartin 399 on at

Like (0)

Report

Hi @David_MA, in the last picture where it appears send an email, I would like to appear in "to" the row I have in the mail template "to", the same in "CC". But not only a person (could be) but also a group of people.

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
I am sorry, but unfortunately your second post doesn't clear things up for me. You need to explain the logic for how the people are determined as to who should be listed in to and cc fields and how it relates to what you are doing. Therefore, I can only give you this as an example.

I have solutions for our Legal department where various forms are submitted for a variety of services offered by the Legal department (contract reviews, lease negotiations, trademark requests, etc.). When the request comes in, an e-mail needs to be sent to the attorneys. On the SharePoint site where the requests are submitted, a SharePoint group has been created, and all of the attorneys are members of the group. The following gets the members of the attorneys' group in order to send the e-mail:

Some notes:

You can get the ID of the group used in the HTTP request by opening the group on the SharePoint site. The group ID is listed at the end of the URL.

It is hard to see in the screen shot, but the character after the e-mail value in the append to string action is a semicolon (;).

The scheme for the parse JSON action is:

{

"type": "object",

"properties": {

"d": {

"type": "object",

"properties": {

"results": {

"type": "array",

"items": {

"type": "object",

"properties": {

"__metadata": {

"type": "object",

"properties": {

"id": {

"type": "string"

},

"uri": {

"type": "string"

},

"type": {

"type": "string"

}

}

},

"Alerts": {

"type": "object",

"properties": {

"__deferred": {

"type": "object",

"properties": {

"uri": {

"type": "string"

}

}

}

}

},

"Groups": {

"type": "object",

"properties": {

"__deferred": {

"type": "object",

"properties": {

"uri": {

"type": "string"

}

}

}

}

},

"Id": {

"type": "integer"

},

"IsHiddenInUI": {

"type": "boolean"

},

"LoginName": {

"type": "string"

},

"Title": {

"type": "string"

},

"PrincipalType": {

"type": "integer"

},

"Email": {

"type": "string"

},

"Expiration": {

"type": "string"

},

"IsEmailAuthenticationGuestUser": {

"type": "boolean"

},

"IsShareByEmailGuestUser": {

"type": "boolean"

},

"IsSiteAdmin": {

"type": "boolean"

},

"UserId": {

"type": "object",

"properties": {

"__metadata": {

"type": "object",

"properties": {

"type": {

"type": "string"

}

}

},

"NameId": {

"type": "string"

},

"NameIdIssuer": {

"type": "string"

}

}

},

"UserPrincipalName": {

"type": "string"

}

},

"required": [

"__metadata",

"Alerts",

"Groups",

"Id",

"IsHiddenInUI",

"LoginName",

"Title",

"PrincipalType",

"Email",

"Expiration",

"IsEmailAuthenticationGuestUser",

"IsShareByEmailGuestUser",

"IsSiteAdmin",

"UserId",

"UserPrincipalName"

]

}

}

}

}

}

}

Hopefully this will assist with what you are trying to do.

Was this reply helpful? Yes No