Column and Field Security in Power Apps Dataverse [Tutorial]

In this video, you can see how to turn on and configure field-level (column-level) security in Power Apps Dataverse. This feature in Dataverse prevents certain users from viewing, editing or creating data in a given column. Perfect for Datverse HIPPA restrictions or HR restrictions! This security works in any app type (ie Canvas, Model-Driven) using the Dataverse.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-

[zabihkhan]

Nice explanation Sir your videos helps alot, please do create a video on Power Pages Column Level Security 😀

[ticklemedaly]

Always love the content you put together! Got an interesting scenario for you. We have a need where we would enable RLS for everyone to be able to create/edit their own records, but have additional columns that have CLS enabled to restrict edit ability to a small group of other users. Is this possible and does this mean dataverse applies most privileged capability, or does the RLS cancel out the CLS since the group can only edit their own records?

[carlohermus]

Good and clear video.

I have got a question.
I use my own user and roles table in dataverse to be able to handle security within my canvas app. This way I can give some the ability to manage users and roles without them having control in the backend and to use it on screenitems.

Is there a way where I can connect my roles in the teams security? Like when adding a role it will generate a team and when adding a user to role it will add a user to a team?

[arthis]

Hi....how to mask/encrypt the column/data in dataverse table?

[LukasSchauffele]

Great video Brian. I have two questions:

1. Is this the preferred method of making fields read-only on a table level? We want to use the new editable Power Apps grid but need to ensure some fields can't be edited.

2. If Field Security Profiles is the best way, are they solution aware? Can we set up profiles in Dev and deploy into downstream environments or do we need to configure this per environment?

Thank you

[CustersBart]

Hi Brian, Great video!
Does these column-level security also directly integrate in a canvas app?
Like in a Gallery, does it hide the restricted values automatically? Or on SubmitForm, will it not update a read-only field?

[prasannadahal]

Hi Brian, is it true that column level security is not possible for custom dataverse tables?

[saradehond]

So, the field permissions tab is empty. You have a number of items in that that you can edit. How do I add things there?