Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Locking a SharePoint list item field after input

Like (0) ShareShare
ReportReport
Posted on 29 Mar 2019 15:45:45 by

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:
  • Community Power Platform Member Profile Picture
    on 12 Apr 2021 at 15:36:52
    Re: Locking a SharePoint list item field after input

    Thank you. It worked.

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 12 Apr 2021 at 15:23:29
    Re: Locking a SharePoint list item field after input

    @Anonymous 

    If(IsBlank(endDate) || yourForm.Mode = FormMode.New, Edit, Disabled)

  • Community Power Platform Member Profile Picture
    on 12 Apr 2021 at 14:03:24
    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 Platform Member Profile Picture
    on 29 Mar 2019 at 16:19:37
    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 Profile Picture
    76,287 Super User 2024 Season 1 on 29 Mar 2019 at 15:58:25
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 445 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 193

#3
Pstork1 Profile Picture

Pstork1 166 Most Valuable Professional

Overall leaderboard
Loading started
Loading started