Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamics CRM CDS display my assigned entities (security role, Teams, etc)

Looking for some help with how to show an Authenticated users personally assigned entities from Dynamics CRM.  I currently have the PowerApp connected and all the entities available, I am just struggling with how to have the information displayed only be what is currently assigned to the user accessing the PowerApp.


ex) I open App, select "Check My Access" button which takes me to a new page that displays certain assigned entities (Manager, Business Unit, Security Roles, Teams, etc).


Any help would be greatly appreciated!  Thank you


Hi madamski115,


Showing assignments like Security Roles and Teams should be doable.  For instance, let's say you've stored the CDS user record in varUser.  If you want to put a Gallery of the currently selected user's assigned roles on the form, you can set the Gallery Items to:

varUser.'Security Roles (systemuserroles_association)'


Showing a gallery of teams would work the same way.  Manager and Business Unit are different, as those are simple lookup fields that can be displayed using a label control.



Super User
Super User

Hi @Anonymous,

Are you looking for a way to view all privileges assigned to users? Not sure if you wanted to list all those within a canvas app, but a way is with the XrmToolBox Privilege Discovery tool:

Hope this helps...

Not applicable

@thjeffri thank you so much for this info! I will give this a try

Not applicable

When you say "Stored the CDS user record in varUser" do you mean a Set function on the OnSelect?  Also would the Gallery itself link to the Security Roles data source or Users data source?

Not applicable

In our case it looks like we use the general 'Users' dataset from the CDS so my Gallery Items looks like this:


Users.'Security Roles (systemuserroles_association)'


When I do this, I get the error "The Specified Column is not available in this context"


Not sure what I am doing wrong, but standard Filtering wont work due to the dataset size exceeding 2000 records (in Users dataset)

To your earlier question, there are any number of ways you can store a User record in a variable.  The simplest might be to have a gallery of users and Set() the variable to whatever the selected user from that gallery is.  Or, you could do a Lookup() on the Users entity if you have a known value as an input.  Based on your question, I was assuming that you probably have a form for one user record, and that's where you are trying to insert a gallery of roles.


In my scenario, I said I had stored the User record in varUser, because we need to narrow our scenario down to just one user record.  So when I have varUser.'Security Roles (systemuserroles_association)', I am essentially telling CDS to return the list of associated roles for the one user in varUser.


The challenge with Users.'Security Roles (systemuserroles_association)' is that you are essentially saying to CDS "return all the roles associated to all users", which I don't think CDS can make sense of.

Not applicable

Thank you for this information.  If I wanted the stored user to be the current user accessing the app, as in no selection criteria on the app (just the user itself) how would that look with a Lookup or Set variable?


I appreciate all of your help! I am still very much a novice with PowerApps

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,018)