Announcements
I have a list of users with their roles on the app. The Role column is a multi-select choice column since some users have multiple roles. I wanted to get the logged in user's portal role/s, and I don't really know how to do this since I have not seen a resource about this one. I also can't access some sites (e.g. YT) since my company blocked them. Any help will be appreciated.
Hi @raizanicolem ,
Their Roles separated by commas would be (assuming you have the user's email in another field in the list)
Concat( LookUp( SPList, YourEMailField = User().Email ).Role, Value, "," )
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 the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Thank you so much @WarrenBelz ! I decided to just change the column type to Text and use IsMatch() since I don't know the template of the final list, but your solution will be very handy in the nearby future.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
