Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

AD Users Drop Down Limits 100

(0) ShareShare
ReportReport
Posted on by 574

Hi All - I'm trying to create a combo box that shows a list for all my AD users. I have 390 users. If I try this 

 

Collect( AADData, AzureAD.GetGroupMembers("e2450b0d-82eb-4ad5-bd01-06a85001b1f6").value) 

where e2450b0d-82eb-4ad5-bd01-06a85001b1f6 is my All Users group that has 390 Total Members - I only get about 100 - if I try 

Distinct(
Filter(
Office365Users.SearchUser(),
Len(DisplayName) <> 0
),
DisplayName
)

 

I get different names - but still only about 100 

 

Data Row limit is 500  - all other obvious issues like display name etc have been checked.  

 

Ther's gotta be some setting or something I'm missing 

 

All info welcome 

thx 

  • ctedesco3307 Profile Picture
    ctedesco3307 574 on at
    Re: AD Users Drop Down Limits 100

    @LaurensM Thank you Thank you!! 

  • Verified answer
    LaurensM Profile Picture
    LaurensM 12,510 on at
    Re: AD Users Drop Down Limits 100

    Hi @ctedesco3307,

     

    The code between curly brackets is required in the V2 to get a full list without a search term:

    Distinct(
     Filter(
     Office365Users.SearchUserV2({isSearchTermRequired:false}).value,
     Len(DisplayName) > 0
     ),DisplayName
    )

     

    I hope this helps!

  • ctedesco3307 Profile Picture
    ctedesco3307 574 on at
    Re: AD Users Drop Down Limits 100

    @LaurensM - thanks - its not liking the rest of my query though 

    These both  return nothing - I can't even activate the ddown

    Filter(Office365Users.SearchUserV2({top:500}).value, !IsBlank(DisplayName))

    Distinct(Filter(Office365Users.SearchUserV2().value,Len(DisplayName) > 0),DisplayName)

     

  • LaurensM Profile Picture
    LaurensM 12,510 on at
    Re: AD Users Drop Down Limits 100

    Hi @ctedesco3307,

     

    By default the V1 search user will only return 100 unless defined otherwise. You could use the V2 instead - which returns 999 by default (or 500 since your row limit is capped at 500). 

    I will give you both options, but generally it is best practice to use the newer versions of functions/formulas:

     

    //V1
    Office365Users.SearchUser({top: 500})
    
    //V2
    Office365Users.SearchUserV2({isSearchTermRequired:false}).value

     

    If this solves your question, would you be so kind as to accept it as a solution.

    Thanks!

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard