cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anshika_anand
Microsoft
Microsoft

User Team entity details in PowerApps

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:

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Hi @anshika_anand,

Similar to the role query, have you tried with teammembership_association

Filter(
Users,
'User Name' = User().Email
).'Teams (teammembership_association)'
);

Cheers

View solution in original post

3 REPLIES 3
EricRegnier
Super User
Super User

Hi @anshika_anand,

Similar to the role query, have you tried with teammembership_association

Filter(
Users,
'User Name' = User().Email
).'Teams (teammembership_association)'
);

Cheers

SaphirPatrick20
Regular Visitor

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 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,094)