Sep 24 2024 10:35 PM
Our team has a SharePoint, and there are certain files which are being shared with outside members. I have a list of outside members with all the URLs that they currently have access to. I have the excel file with their email address, I want to add this excel file as a list on SharePoint. Then I will share the list with all the outside members whose IDs are listed in the excel file with the URLs that they access to. But I want the members to see only the rows with their email address and let us know if they still want to retain access to the document. This is for access control.
I have found many videos where I see a similar issue but the list is being created by those users and then they are able to see those items as per item level security, which is not my case.
Here, I have a list already available, so it doesn't have a 'created by' column, how can I apply this access control?
Sep 25 2024 01:52 AM
@AvishekR825 you would need to do this with a flow in Power Automate. An example of setting item level permissions is on YouTube at https://www.youtube.com/watch?v=PYxzWMI8h8I
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Sep 25 2024 02:09 AM
@Rob_Elliott Thanks for sharing this, I have already checked this and it doesn't serve the purpose. It works only when people are creating the items.
In my case I already have inputs in an excel sheet, the same excel sheet contains the email addresses as well of the users. I have added that excel as a list. Now, I want these people to access the list and they should only be able to see the line items which has their email address/ID.
Sep 25 2024 02:16 AM
@AvishekR825 you would just need to change the trigger to "for a selected item" or to "when an item or a file is modified" trigger.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Sep 25 2024 02:17 AM