Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
  • 1.  Filter/Search O365 Users for Department (>2.000 Users)

    Posted Nov 05, 2021 05:50 AM
    Hi,

    I am struggeling with how to get certain users from the O365 Users connector by department. By using the SearchUser function, it only searches in the fields name and emails fields. Using the Filter function will only work for companies with less than 2.000 users/items. Is there any other way to achieve this?
    I want to show users that are in the same department as myself. So i would like to filter for "Department = Office365Users.MyProfileV2().department", but the amount of users in total is > 2.000 items, so i get no results


    ------------------------------
    Fabian Heil
    ------------------------------


  • 2.  RE: Filter/Search O365 Users for Department (>2.000 Users)

    Top Contributor
    Posted Nov 08, 2021 01:34 AM
    You might need a custom connector for this, which means premium licensing. If you have that, or the functionality is important enough to justify it, you can do this kind of filtering in the Users endpoint of the Graph API with a combination of the department eq filter and displayName startsWith.

    There's also a chance the Azure AD connector, which I believe is standard license these days, has this functionality. Worth having a look.

    ------------------------------
    Will Page
    Technical consultant
    Christchurch, NZ
    ------------------------------