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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Lock CRM form

(0) ShareShare
ReportReport
Posted on by 35

Hello everyone

 

I have high priority task. please help me in below task.

 

I want to lock CRM form,

 

and set rights that particular user can see locked form.

i want to set security that only specific user can see that form.

 

in my canvas app, backend is data verse so need to lock database form for security caserne. 

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @dyna009 ,

     

    If you deactivate the record in Dataverse it will lock the record for the user automatically.  The user would have the ability to "reactivate" the record if required though unless you put in a Plugin to stop the reactivation.    

  • dyna009 Profile Picture
    35 on at

    hi @dpoggemann 

     

    i have thousand of record and i have 200+ users.

     

    So how can i do

  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @dyna009 ,

     

    Make sure I understand what you are asking...

    1. For the thousand records, do you have different owners of these records being any of the 200+ users?  
    2. Are you trying to allow only the "Owner" of the records to "View" the records and never be able to update them but just view or are you trying to allow them to "Add" / "Edit" until you get to a specific point where you are trying to then lock it down?

     

    Overall Security Roles in Dataverse allow you to assign roles to users and then the roles will control access to the tables.  You can assign multiple levels of security from (Read, Write, Create, Delete, Share, etc.) and you can then also provide security at the User, Business Unit, Business Unit and Child Business Units, and Organization levels.

     

    Note, there are even more things you can do here with Owner and Access Team assignments, hierarchical security, etc. but leaving this out for now as it will get more advanced.

     

    Base example...

    • Create a custom table called Session that is User / Team owned
    • You create two records
      • Session 1 - Owned by User A
      • Session 2 - Owned by User B
    • A role can be created and assigned to User A and User B that they can do the following:
      • View Session entities that they own
    • This role would allow User A to only see their session and User B to only see their session and if you gave no other security in the role then they would not be able to Edit, Add, Delete, Share, etc. any of the Session records.

     

    Multiple options here...  Please see the following:  https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds#tablerecord-ownership which is specific to above but there are a number of additional security concepts in Dataverse in this document.

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @dyna009

    To you get this resolved? To supplement on @dpoggemann, there are several ways to sastify this. Here are some options:

    1. Use model-driven apps for the forms instead of canvas apps as this can be managed automatically with the security roles. Regardless if you use model-driven or canvas, you should setup the privilege correctly, by ensuring the users that need to view the lock form have only "view" privileges in their security roles assigned.
    2. In the canvas app, asusming you using the Edit Form control, have a Power FX expression on the "DefaultMode" property to something like this:
    If(RecordInfo(Gallery1.SelectedItem, DataSourceInfo.EditPermission), FormMode.Edit, FormMode.View)​​

     

    EricRegnier_1-1654929997991.png

    Hope this helps!

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard