You’re offline. This is a read only version of the page.
4
SharePoint list for tracking list of Sales project supported by team. I want the list to be visible only to - Created by, Leads & supporting team. I have made the Practice Leads & Supporting team column by person with multiple entries. I created the flow- When an item is created/modified > Stop > grant access. It works if I have only one name under the Leads column and supporting team. But when I select multiple email and multiple leads its doesn't work. Requesting expert guidance here. Kindly help.
Hi @LydiaTouthang,
You should be able to use a Select action for this.
With this action it is possible to only select the email addresses of the people listed in that field. After that you can reuse the body of the Select in a join function and join it together with a semi colon separator as a string value. That expression can be used in the Recipients field of the Grant Access action.
Below is an example
1. Place a Select action directly after the Stop Sharing action. Use the Practice Leads & Support Team field (entire array) in the From field of that Select
2. Switch the Map field of the Select action to text mode with the button on the right side. Use the Practice Leads & Support Team Email field in there
3. Use the below expression (add it via the expression tab) in the Recipients field of the Grant access action.
Share
Report
All responses (
Answers (
join(body('Select'), ';')
