Take Manager's approval if users wants to edit the submitted / saved record

(0) Share

Report

Posted on by Prem4253

652

Hello,

My PowerApps form is connected with SharePoint list. There are multiple fields, of which there is Status dropdown column with Completed and In Progress.

I'm using below code to disable all the fields with the form when the status says Completed

If(DataCardValue10.Text ="Completed",DisplayMode.Disabled,DisplayMode.Edit)

I'm looking for a way to allow users to still Edit any of the record only when after we have approval from Manager.

For Instance: there are 5 entries into the form. Of which 3 records are In Progress and 2 are completed.

For some reason I want to Edit one of the Completed record. But all the fields are locked. So to edit one of the record, I should take my managers approval and once my managers approves, I should be able to edit one of the records which is needed.

Can someone please advise how can we achieve this. Or should this be done in Power Automate.

Thanks,

Prem

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @Prem4253

You are going to need an additional field that you set when a manager approves and only make the field available on the manager's sign-in. If you want to identify the manager of the user that created the record, if you put this on the Visible of the field control in a gallery or Form with this will make it visible (or not) if the user's manager is signed in.
User().Email = Office365Users.ManagerV2(ThisItem.'Created By'.Email).mail

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @Prem4253,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

@WarrenBelz

Not too sure on how to achieve as per your solution.

New to PowerApps. So if you can elaborate more on how to achieve this, will be much appreciated.

Thanks,

Prem

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

@Prem4253,

Which part to you need clarification on ? The code I posted will return true or false as to whether the logged in user is the manager of the person who created the record, so you would make this the Visible property of the new field, Their Manager (only) could then update this field with a value and you could then test that this is present to unlock the other fields.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No