Unanswered

Conditional field-level security

(0) Share

Report

Posted on by Termigez1

Hello,

I need to prevent users from editing values in column A based on values in column B. It can't be done via business rules because users would still be able to make changes for all records using for example Excel Online. Field-level security allows me to completely prohibit users from editing certain column, now I am searching for a way to give them conditional permission to edit it. Is it possible to do?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

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

Like (0)

Report
Copy link

Link copied!

Hello @Termigez1

Hope you are doing good.

Please write JavaScript to Achieve the same.

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
Termigez1 30 on at

Like (0)

Report
Copy link

Link copied!

Hello @rampprakash, thank you for your answer, however it is too vague for me. Will JS code work while editing data using Excel Online functionality or by making a change in Dataverse via Azure Function? I need a solution that works always and everywhere, not only in model-driven form. Business rules (if i remember correctly) are basically JS codes and unfortunately they do not work outside Dataverse. Field-level security is great because it prevents changes in Dataverse called outsiede of Dataverse, however it does not meet all my requirements in its basic form.

Was this reply helpful? Yes No
Shubhk 36 on at

Like (0)

Report
Copy link

Link copied!

Hello @Termigez1

Did you try writing Business Rule for this? Business rules ensure consistent business logic whatever app is accessing that data.

Was this reply helpful? Yes No
benji-7 33 on at

Like (0)

Report
Copy link

Link copied!

I do have a very similar requirement for a dataverse table. I want users who have access to a row, have only permission to see the value from column A of that row if column B is checked.

The answers provided, are not really helpful as JS only works in views and forms. The same with business rules. Users can still see the values if they directly access the table.

Anyone has a solution for that?

Was this reply helpful? Yes No