Read Only at Field Level

(0) Share

Report

Posted on by PietPoelsma

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:

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 with Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PietPoelsma 67 on at

Like (0)

Report
Copy link

Link copied!
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."?
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?
How do you prevent that locked fields are updated via an Excel import?

Kind regards,
Piet

Was this reply helpful? Yes No