Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Not all items that show in "Items" show in the drop-down

Posted on 25 Nov 2024 13:22:54 by 66
Hi everyone,
 
I have encountered an issue when I look at the Items tab at the code, there appears to be more records than in the actual combobox dropdown. Is there anyway that this is some sort of lagging issue? I have about 30 comboboxes on this form so I can't easily delete and re-add them.
 
Here is my code on Items,
 
Sort(Filter(Office365Groups.ListGroupMembers("403b0c07-d5fa-48e8-9603-0c05511d1f17").value,!IsBlank(mail),Not("#EXT" in userPrincipalName)),displayName,SortOrder.Ascending)
 
 Here are the results if I highlight it to view the table,
 
 
And here are the dropdown items,
 
 
As you can see there are quite a few L names missing.
 
Does anyone know why this could be?
 
TIA
 
 
  • Verified answer
    NicolleAbraham Profile Picture
    NicolleAbraham 66 on 26 Nov 2024 at 09:25:44
    Not all items that show in "Items" show in the drop-down
    I tried to apply the collections but the comboboxes did not even show empty values when I removed the attached data sources. I did have to delete and re-add the comboboxes, luckily they were in a data card so I could delete the entire data card and undo the delete which refreshed them as needed and now the information is shown perfectly.
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,216 on 25 Nov 2024 at 16:21:10
    Not all items that show in "Items" show in the drop-down
    pls try the following:
     
    Filter issue:
    ClearCollect(DebugData,
      Filter(
        Office365Groups.ListGroupMembers("403b0c07-d5fa-48e8-9603-0c05511d1f17").value,
        !IsBlank(mail),
        Not("#EXT" in userPrincipalName)
      )
    )
     

    Power Apps has a default delegation limit of 500 records (which can be increased to 2,000 in Advanced Settings). - Go to Settings > Advanced Settings in Power Apps and increase the data row limit for non-delegable queries to 2,000.
     
    Load the data into a collection when the form loads (e.g., OnVisible or OnStart) to avoid repeated calls to Office365Groups.ListGroupMembers for each ComboBox

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard