Hi all,
I have a flow that I thought was working but turns out has a flaw.
So the person running the flow has access to the item in sharepoint because being member of a group. My plan was to - on saving the item in PowerApps have a flow that runs as the user that removes the group and adds the user to have specific rights to the item.
However...... because the user has rights to the item already by being a part of the group it then deciding not to add the individual access to the record. But if i delete the access first the user would then lose all access to be able to add their own access.
This seems to only be happening via PowerAutomate and if I try to do the same in sharepoint itself there is no issue in adding a user that is already part of the group.
So my way of testing this was that I ran the save (as administrator of the sharepoint site) and it doesnt add the user to the list item. However if i remove the user from the group that has access and run the same flow - they are then given individual access.
I am sure someone has had this issue before but not sure what to type to find the current status.
Any help gratefully recieved
Dan