You’re offline. This is a read only version of the page.
Hi, I have a scenario where I want to list User with a particular security role. Let's say we have the user with Roles Account Manager, Activity Feed, CEO etc. I want the Users with Role Account Manger only in PowerApps. Can you show us how can it be achieved?
Hi @summitb
This is not a great solution for larger environments, but for smaller environments you could write the Office365 users into a collection, and then filter the collection according to JobTitle.
Write address book into collection:
Share
Report
All responses (
Answers (
1,346
ClearCollect(colAddressBook,Office365Users.SearchUser({searchTerm:"",top:500}))(*If you don't specify the Top parameter, the query only returns 100 results, which depending on your environment, might not be enough for all users)
Filter accordingly:
Filter(colAddressBook,JobTitle="Chief Executive Officer")
Let me know if you don't come right.
twitter: @dawidvh
youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw
>>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<
Hey @DavesTechTips,
I wanted to list users that have certain roles. For example I want to show list of System Adminstrators in the Gallery List in PowerApps. Is there any way out for this?
Hi @summitb
Are you trying to only give users with a specific role access to open the PowerApp, or are you trying to verify that a user has a specific role before allowing him\her to perform a certain action?
The first might not be easy to do, but the second can be done by using the Office 365 Users connector and the following formula which will return true or false.
Office365Users.MyProfileV2().jobTitle = "Top Dog"
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
