question

PowerPlatformUser-2021 avatar image
0 Votes"
PowerPlatformUser-2021 asked JoyZ commented

Sharepoint - security based on "people or group"column from another sharepoint list using power automate

Hi All,

I am a beginner in Power automate. Looking out for help in understanding if the following is possible using Power automate.
Note: SharePoint Online using within Teams
Requirement:
SharePoint List1 :
Fields:
1. Group (Choice)
2. Sub-Group (Choice)
3. Sales (Number)
4. Date ( Date and Time)

SharePoint List2 :
Fields:
1. Group (Single text)
2. Access-Group (People or Group)

SharePoint List1 should have create/edit rights only for "Access-group" based on Group column.
All users must have "view" access to SharePoint List1

Any help on the above is much appreciated.
I have tried to create a flow but am not very much familiar with variables and working with 2 SharePoint lists to achieve the results.

Thanks in advance



office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

@PowerPlatformUser-2021,

I want to confirm some information with you:

What's the type of group?SharePoint group or Microsoft 365 group?

Do you mean when Group(choice) in list1 equals to Access-group(People or Group) in list 2, then grant edit permission to users in list1?

If you want Everyone except external users to view the list, please go to list settings>Permissions for this list>Stop inheriting Permissions> then Grant View Only permissions to this group.

If you want Everyone include external users, enable the Everyone claim first then grant permissions.

 Connect-SPOService -Url https://contoso-admin.sharepoint.com  
 Set-SPOTenant -ShowEveryoneClaim $true

Here is an article about how to set SharePoint list item permissions using MS Flow to Microsoft 365 group or SharePoint group:

https://www.c-sharpcorner.com/article/set-sharepoint-list-item-permission-using-ms-flow/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PowerPlatformUser-2021,

Is there any progress on this issue?

Please feel free to reply.

0 Votes 0 ·

@PowerPlatformUser-2021

,I’m checking how the things are going on about this issue. Whether the post helps you?

You can accept the post as answer if it helps.

Thank you for your understanding and support.

0 Votes 0 ·