Answered

How i can disable all the fields if status value will "Submitted"

(0) Share

Report

Posted on by johnjohn123

3,514

I have customized our sharepoint list using power app >> and inside the list we have a drop-down column named "Approval Status". now i want to disable all the fields (disable the whole powerapp form) in-case the "Approval Status" = "Submitted" is this possible? now i can do so for each field separately >> but i am asking if i can do it at the form level instead?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohn123 ,

I think you can use FormMode to control. For example:
If(ThisItem.'Approval Status'.Value="Submitted",FormMode.View,FormMode.Edit)
Hope this helps.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous i can not find any property named "FormMode" .. there is only a property named "DefaultMode"..can you post a screen shot please?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohn123 ,

You are correct. I did some test, it looks this formula doesn't work well, only in a moment it shows the mode as "View", but it comes to back to allow "Edit" again.

I tried "Visible", it works well, but I don't think this is what you want because it shows nothing when the criteria is met; an alternative way might be setting up "Visible" property on the "Save" button, if the "Approval Status"="Submitted", the "Save" button is invisible. Not sure if this is OK for you.

Sorry I didn't try the formula before I responded to you.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohn123 ,

I think your needs can be met. Based on the idea of @Anonymous , I want to add something.
The point is to judge the value of the column when submitting.
If the value is "Submitted", modify the DefaultMode property, otherwise do not modify.

I assume:
"Approval Status" is a choice column. It has two options, one is "Submitted" and the other is "Unsubmitted".

I did a test for you:
1\ This is my test list 'LIST 58'
2\ Add an edit form 'EditForm1' and set its DefaultMode property to:
Thevar // This is a variable name, it will be created later

3\ Add a button control and set its onselect property to:
SubmitForm(EditForm1);If(EditForm1.LastSubmit.'Approval Status'.Value="Submitted",Set(Thevar,FormMode.View),Set(Thevar,FormMode.Edit))

4\ The result is as follows:
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No