Team related Security Roles in Canvas App

(1) Share

Report

Posted on by crazyguy

I'm trying to build a canvas app to get all the security roles a User has associated to them.

The User -> Security Role part is working fine.

However when I'm trying to get the Team -> Security Role relationship into my app I get the following error.

The specified column is not accessible in this context.

I'm using the Following Statement First(Teams).'Security Roles'

Is there another way to get the information from this relationship into my canvas app?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @crazyguy ,

Could you please share a bit more about your issue?

Do you want to list all available Security Roles for a specific team?

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Add two Galleries in your app, set the Items property of the first Gallery to following:

Teams

set the Items property of the second Gallery to following:

Gallery1.Selected.'Security Roles'

Please make sure you have configured proper Security Roles for the specific team in your Org. Please consider go to your Power Platform Admin Center, then click Environments tab, find your current Environment, then click "Settings" option, then expand the "Users + permissions" option, then click "Teams" option:

then within the opening Teams record page, switch View option to "All Owner Teams", then select specific team, then click "Manage Roles" option in Top Menus:

then check if you have assigned Security Roles for the selected team.

Best regards,

Was this reply helpful? Yes No
crazyguy 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer but this isn't what I want to do.

I want to have a collection with all the security roles from the user.

So at the start of the app. I'm getting the current user from CDS.

Set( currentUser,LookUp(Users, 'Primary Email' = User().Email ));

With that i'm collecting all of the users directly associated security roles via:
Collect(securityRoles, currentUser.'Security Roles');
This is no problem and working as expected.

Then i'm collecting all teams a user is part of and the teams associated security roles via:

With({teamids : currentUser.'Teams (teammembership_association)'.Team},With({teams:Filter(Teams, Team in teamids)},ForAll(teams, Collect(securityRoles, 'Security Roles')))

And in the last part of this function it gives an error stating "The specified column is not accessible in current context".

if I Select one Team using First(Teams).'Security Roles' is doesn't give that error indeed.

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report
Copy link

Link copied!

Hi @crazyguy ,

have you have solved this problem? Have exactly the same problem.
Just want to find out all security roles of a specific user and all connected teams security roles..
To work with a gallery wouldn't be a way for me as well. Just want to check all security roles at the App start.

BR,
Sven

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Same issue here, just figured out that I need to do this. Will post the solution if I found a way. Doesn't seem straightforward though.

KR,

Felix

Was this reply helpful? Yes No
Verified answer

davidjfafonso on at

Like (0)

Report
Copy link

Link copied!
@crazyguy @Anonymous
This is not the prettiest solution but it will work:

Set(currentUser, LookUp(Users, 'Primary Email' = User().Email)); // User Roles ClearCollect(UserRoles, currentUser.'Security Roles (systemuserroles_association)'); // User Teams ClearCollect(UserTeams, currentUser.'Teams (teammembership_association)'); ClearCollect(UserTeamsAux, UserTeams); // All Roles (User + Teams) ClearCollect(AllUserRoles, UserRoles); ForAll( UserTeams, Collect(AllUserRoles, LookUp(UserTeams, 'Team Name' = First(UserTeamsAux).'Team Name').'Security Roles'); Remove(UserTeamsAux, First(UserTeamsAux)); )

The "AllUserRoles" collection will contain all the roles (user roles + teams roles).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Wow! Great work @davidjfafonso !! Works like a charm at first try. I'll look into what you wrote a bit later but we can definitely work with this.

Was this reply helpful? Yes No