Answered

Locking a SharePoint list item field after input

Like (0) Share

Report

Posted on 29 Mar 2019 15:45:45 by Community Power Pla...

I was wondering if there is anyway to lock a field of a SharePoint list item after the user has input the data for that specific field.

For instance, I have a gallery with several projects, each with a start date, but the end date has to be input by the user. After they have input the end date, how can I make sure that no one will be able to change the end date for that project?

Please keep in mind that I am still relatively new to PowerApps.

Categories:

General Questions

All responses (5)

Answers (1)

Community Power Pla... on 12 Apr 2021 at 15:36:52

Like (1)

Report

Re: Locking a SharePoint list item field after input

Thank you. It worked.
RandyHayes 76,287 Super User 2024 Season 1 on 12 Apr 2021 at 15:23:29

Like (1)

Report

Re: Locking a SharePoint list item field after input

@Anonymous

If(IsBlank(endDate) || yourForm.Mode = FormMode.New, Edit, Disabled)
Community Power Pla... on 12 Apr 2021 at 14:03:24

Like (0)

Report

Re: Locking a SharePoint list item field after input

This has worked to lock the field in Edit mode and in the add New view. How can I have the Field available when creating a New item.
Community Power Pla... on 29 Mar 2019 at 16:19:37

Like (1)

Report

Re: Locking a SharePoint list item field after input

@RandyHayes , I just tested your proposal and it worked just fine! Thank you very much.

I am working on a separate control, by the way.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 29 Mar 2019 at 15:58:25

Like (2)

Report

Re: Locking a SharePoint list item field after input

@Anonymous

One of the conditions you can look at is adding a formula to the DisplayMode property of the end date control. Something like this:

DisplayMode : If(IsBlank(endDate), Edit, Disabled)

Now...this is very generic of a formula as I'm not sure of your app design and if this is a form with a datacard, a separate control or if there are other aspects to be considered.

Consider the above formula and feel free to post back if there are some parts you're not getting.