Hello community,
I'm currently using a SharePoint list to store confidential data input through a PowerApp. The data needs to be viewable and editable by not just the item creator, but a second (and potentially 3rd), named individual that is input through the app interface (and visible/editable by no one else, as the data is sensitive). Over in the SharePoint community it has been suggested that I set the list permissions to view/edit for all and then use the "send an HTTP request to SharePoint" connector to break inherited permissions and then set the new unique permissions on an item by item basis.
I have managed to find some flow instructions on this, but these usually show how to use this connector to identify the 'created by user'. However, in addition to this, I need to be able to set additional permissions for the named individuals, whose user email will be submitted in the list item itself.
Could anyone help me with some flow design details for if I am looking to set the permissions based on a named column(s), rather than 'created by'? I will need to set permissions for a maximum of 3 people, the creator, and up to two named contacts.
Any help would be much appreciated as this appears to be the last major hurdle on getting this app up and running!
Many thanks :)