web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps I want to get a list o...

Power Apps

Answered

I want to get a list of security roles associated to the current user

(0) Share

Report

Report

Posted on by powerappnewbie4

53

Hello

I want to find security roles associated with the current logged in user

I can get my current user record as:

LookUp(Users,'Azure AD Object ID' = User().EntraObjectId)

From here, I need to find how to do a many to many relationship with security roles table

Please help!

@WarrenBelz @Amik @happyume

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Mitanshu 1,658 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
1 - In your Canvas App, add Users table and Security Roles Table

2 - In the gallery where you want to display security roles associated to the current user:
Under the Items property use:

LookUp( Users, 'Azure AD Object ID' = User().EntraObjectId ).'Security Roles (systemuserroles_association)'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
pradiptanayak1 26 on at

Like
a
(0)

Report
Copy link

Link copied!

It work if Add the User directly to the Security Role. But When add AAD Security Group (which user belongs to) it not working. We need to compare not with email ?

Was this reply helpful? Yes No

Join the conversation