Hello,
I see that we can get all security roles associated with a user in Canvas PowerApp with 'Security Role' entity using below query. But Is there any way to get all the Team detail user is currently added to from PowerApp?
Query to get User Security roles:
Filter(
Users,
'User Name' = User().Email
).'Security Roles (systemuserroles_association)'
);
Please do let me know if there is any way to these Team details of the user.
Screenshot to get user Team details:
Solved! Go to Solution.
Hi @anshika_anand,
Similar to the role query, have you tried with teammembership_association:
Filter(
Users,
'User Name' = User().Email
).'Teams (teammembership_association)'
);
Cheers
Hi @anshika_anand,
Similar to the role query, have you tried with teammembership_association:
Filter(
Users,
'User Name' = User().Email
).'Teams (teammembership_association)'
);
Cheers
hi, how do u use the formula ?
Hi @SaphirPatrick20, not sure if you solved it but what do you mean by "how do u use the formula"? Cheers
User | Count |
---|---|
19 | |
9 | |
9 | |
5 | |
5 |
User | Count |
---|---|
32 | |
30 | |
18 | |
18 | |
6 |