lock row editing after being validated by super user

(0) Share

Report

Posted on by Mopadi

Hi,

Can you please assist regarding the following app and tell me if it can be done as I imagine it ?

1 - a first form where associates can view/add/edit/remove their own items.

2 - a second form (or the same) where managers can review the item of their team’s associates, edit/remove and LOCK the editing for associates.

My difficulty is to find a way for the manager to lock the item after review. If possible I would like associates to still be able to see validated items even if they can’t modify them anymore.

Thanks in advance for your help!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mopadi ,

I'm thinking about this -
1. You can add one colun in sharepoint list called 'Review Status' or 'Edit Status'. this will not appear for users, only for manager and the choice will be "Opened (default when created any new item), Locked"
2. Assuming that you are using edit icon in PowerApps to edit the record, so you can control its visibility according to Status.
If Status = Opened -> Edit icon is visible to user who created that item
Status = Locked -> Edit icon is not visible to user who created that item
This status feild only appear for managers so they can change from Opened to Locked and vice versa.

Example -
When I submit a form, its default status is opened and I can modify anything in that using edit icon. It goes to manager then manager click on edit, review it and if everything's good then he mark the status as 'Locked' and as we are controlling icon visibility based on status, it should work fine as expected

Note -
Control icon visibility for user only because maybe there are some chances that manager change status from Locked to Opne in case some addional data required in future. this is just my assumption

Let me know if this helps.
Thanks 😀
Mopadi 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help @Anonymous . I didn’t know icon visibility could be a function of a field value, it could definitely work!

Do you think it is possible to have one more field like you suggest, then set up role, row security level and field level security to achieve the same result ?

I was thinking that role would be set up to see only your own records, and team records for managers.
Row level security would be to enable/disable the edit based on an additional status column.
Field security level would be to hide the status column (in my case not that important I am fine everyone seeing the status).

I have never secured an app, I share my thoughts based on the following page. Possible I didn’t understand correctly how it works.
https://learn.microsoft.com/en-us/power-apps/guidance/planning/security

Mopadi
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It depends on which data source you are using. In Dataverse we have security level upto fields. In sharepoint we have item level only 🙂
Mopadi 8 on at

Like
a
(1)

Report
Copy link

Link copied!

You are so right, I didn’t precise, but I confirm we will get Dataverse capabilities for this project