
Announcements
Good afternoon,
I have a SharePoint list that with strict permissions, but I allow the end user to designate who they want to share access to a particular item with using a person column in the SharePoint list. Basically, when they add the item to the list, they can add names to this person type column and, when my Power Automate flow runs, it will take the names from that column and grant them access to the SharePoint list. I have tested this out and it works well, only granting those users access to that particular item and no other items for which they have not been granted access.
I also give my users the option to go back into this list item and edit it, and one change they can make is who they share the list with. However, this feature is not working as well as I'd like it to.
Essentially, if the user edits an existing list item and adds names to the person type column, I would like Power Automate to check to see which users in the person column have already been granted access previously to ensure that they are not notified twice that they've been granted access (I have email notifications setup for this).
Ultimately, I suppose I am looking for a way in Power Automate to check for names that have been added to the person column which are different from the names that were added when the item was initially created.
Thanks in advance!