Hello everyone,
I am currently setting up a PowerAutomate flow to grant permissions using the "Stop Sharing an item" and "Grant Access to an item" actions of Sharepoint within PowerAutomate. Users shall not be able to read or edit items created by another user as long as the Power Automate flow will let them do it.
The SharePoint list itself is fed by a power app.
For this, users need to be able to have CRUD permissions to make the app work as expected.
I noticed that the PowerAutomate flow will not work (even though it says success) once I share the list with users.
I need to share it so they can create new items. If I remove them from the list, they cannot create new items. At that moment, the flow will run as expected again.
What do I need to change so users can add new items and see items created by other users if they are mentioned in my "Assigned To" column? For data protection reasons they shall not be allowed to see any other items.
Thanks a lot for all your help!