Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Help with understanding dataverse security access

(0) ShareShare
ReportReport
Posted on by

Hi

I'm pretty new to the Power Apps / Power Platform scene.

I have two environments, A and B.

I have created an app in environment B which takes inputs and writes data back to Dataverse tables.

If I then share this app with a user who only has access to environment A, when they log in through the Power Apps phone application, can see and search the data in the app. Is this correct? Should they be able to see the data? How does the security work in this case?

 

Many thanks in advance

Categories:
  • Community Power Platform Member Profile Picture
    on at
    Re: Help with understanding dataverse security access

    Hi @dpoggemann 

    That is great, thanks for your help on this 😊

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Help with understanding dataverse security access

    Hi @Anonymous ,

    No they do not.  You need to share / assign specifically to each environment.  I would go look at the user in that environment and see the role assigned.  You can see the users under the admin.powerplatform.com and going into Settings to access the users.  You can then look at the user and the roles assigned.  Another situation could exist where you assign the user to a security group that is setup as a team in Dataverse with roles assigned.   I assume this is not the situation though but this is actually best practice (see:  https://docs.microsoft.com/en-us/power-platform/admin/database-security#create-or-configure-a-custom-security-role

     

    Thanks,


    Drew 

  • Community Power Platform Member Profile Picture
    on at
    Re: Help with understanding dataverse security access

    Hi @dpoggemann 

     

    Thanks for the reply. That does make sense. Does that apply across environments? I think that's the bit I'm struggling to get my head around. The app and the user are in two different environments. Do privileges and security roles apply across environments?

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Help with understanding dataverse security access

    hi @Anonymous ,

    Yes, if the Gallery is pulling records from the Accounts table and you have the role for the user setup where they can view any Accounts, not just ones assigned to "them" then all the records queried in the gallery will display for the user.  If you setup the Account Entity in the Role so they can only view their own records (User level) for the role the user is assigned then they would only see the records where they are the owner.

     

    Thanks much!

    Drew

  • Community Power Platform Member Profile Picture
    on at
    Re: Help with understanding dataverse security access

    Hi @dpoggemann 

     

    There is a gallery as part of the app that displays items from the accounts table that the user can see and search through. The user, who cannot see the environment the app is built in, can see the data in the gallery when the app is shared with them.

    So the security selected at the time of sharing would control that?

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Help with understanding dataverse security access

    Hi @Anonymous ,

     

    Can you clarify "see and search the data"?  The key item controlling access to the data in the Dataverse is the roles assigned to the user.  When you shared the application with the user you were asked to select a role to assign and this role controls the data access.

     

    Please check out the following article that explains the role based security:  https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds 

     

    Hope this helps.  Please accept if answers your question or Like if helps in any way.

     

    Thanks,


    Drew

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics