Hello everyone,
I hope you are doing well !
My goal is to create a Sharepoint Lists database that compiles all the annual appraisals in my company, with personalized access based on certain criteria, but I have an issue.
I've created a list with all my fields, which I've then integrated into Power Apps (first by customizing the forms, then by creating an “independent” application). With my administrator access, I can therefore add a new item and modify items already entered, thanks to the Power Apps form.
I'd like the appraisals to be visible and editable by each employee's supervisor. But I don't want all managers to be able to see all the appraisals, only those of their supervisees.
To achieve this, I've shared access to the element with the person concerned, as well as access to the Power Apps application with the form. When she goes to the list, she sees only the item she is authorized to see, and can modify it in grid mode. However, she can't modify it from the form because “she wouldn't have access”.
As a test, I've transferred the authorizations for the whole list to her, and she can add and modify items.
How can I ensure that she can only modify the items to which she has been granted access (because she was enrolled as supervisor within the form for instance) from the Power Apps form?
I hope I've made myself clear.
Thank you very much!
PS : I am new to Power Apps, I hope I chose the right categories ;)