web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Read Only at Field Level
Power Apps - Microsoft Dataverse
Answered

Read Only at Field Level

(0) ShareShare
ReportReport
Posted on by PietPoelsma 67

Dear All,

I would like to implement a Model Driven App in which I apply Read Only/Locking on field level.

I have the following table:

PietPoelsma_1-1658761689622.png

 

Depending on the value in the column M1_LOCKED, M2_LOCKED and M3_LOCKED, I want the associated fields in the columns M1, M2 and M3 to be editable or read only...

 

So IF M1_LOCKED = FALSE THEN M1 is Editable ELSE M1 is Read Only

 

Best regards,

Piet 

Categories:
Microsoft Dataverse
I have the same question (0)
  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on at
    Re: Read Only at Field Level

    @PietPoelsma, use the Business rules to implement this use case. 

    AhmedSalih_0-1658762513823.png

     

    More info https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule

     

    Regards,

    Ahmed

    If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

    My Blog: www.powerplatformplace.com

  • Verified answer
    Ram Prakash Profile Picture
    Ram Prakash 5,576 Super User 2025 Season 2 on at
    Re: Read Only at Field Level

    Hi @PietPoelsma 

     

    There are multiple ways available

     

    1. You can write Business Rules

    2. You can write JavaScript 

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Blog : https://microsoftcrmtechie.blogspot.com

  • PietPoelsma Profile Picture
    PietPoelsma 67 on at
    Re: Read Only at Field Level

    Hi @AhmedSalih  and @rampprakash 

     

    Thanks for your replies.

     

    Is it possible to change the layout, like font, color, shading, of locked fields in a View so it clearly shows they are locked?

     

    In a Form it shows with the lock symbol, that's fine.

  • PietPoelsma Profile Picture
    PietPoelsma 67 on at
    Re: Read Only at Field Level

    Hi @AhmedSalih  and @rampprakash 

     

    Thanks for your replies.

     

    Is it possible to change the layout, like font, color, shading, of locked fields in a View so it clearly shows they are locked?

     

    In a Form it shows with the lock symbol, that's fine.

  • PietPoelsma Profile Picture
    PietPoelsma 67 on at
    Re: Read Only at Field Level

    Hi @rampprakash and @AhmedSalih 

     

    And another question: How do you prevent that locked fields are updated via an Excel import?

    I saw now that it is possible to update a locked field via an Excel Import!🤔

     

    Kind regards,

    Piet

  • Ram Prakash Profile Picture
    Ram Prakash 5,576 Super User 2025 Season 2 on at
    Re: Read Only at Field Level

    Hi @PietPoelsma 

     

    No for 100% Sure, it is Possible.

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Follow me on Twitter : @rampprakashd
    Blog : https://microsoftcrmtechie.blogspot.com

  • PietPoelsma Profile Picture
    PietPoelsma 67 on at
    Re: Read Only at Field Level

    Hi @rampprakash 

     

    That's what you get when you ask more than 1 question 😀

    To which question do you answer with "No for 100% Sure, it is Possible."?

    1. Is it possible to change the layout, like font, color, shading, of locked fields in a View so it clearly shows they are locked? If so, how?
    2. How do you prevent that locked fields are updated via an Excel import?

     

    Kind regards,

    Piet

     

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans