Answered

Condition to stop someone from editing a record based on a value in another field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to be able to stop people from editing a record via my app, if its 'Status' is Active or Completed.

For my Status column (plain text), I have four types; Pending, Available, Active and Completed.

I then have an 'Edit' button in my gallery that opens the selected record in the Form so that the user can modify existing details . But I want to limit this button to only open a record for modifying provided it's current status in Pending or Available.

Any help on the right way to structure the formula would be much appreciated. I am thinking at this stage that I should be able to do this with an If statement? So if the status equals x&y, open form in edit mode, otherwise...........

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

You could enable/disable the button using this code in its DisplayMode property.

If(Label_Status.Text in ["Pending","Available"] ,DisplayMode.Edit, DisplayMode.Disabled)

Note: I am assuming the status is shown in a Label but you could reference it some other way if needed.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Like
a
(0)

Report
Copy link

Link copied!

Thank heaps - learning new things all the time. Didn't think to use the condition on a different property.
Works perfectly.

Was this reply helpful? Yes No
lflemingcre 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Isn't this just 'Security through obscurity', and not actually secure? The user can edit this via the API or otherwise, meaning that your system/process is not secure and can easily be cracked by anyone, following a quick google search.

Was this reply helpful? Yes No