Answered

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

(0) Share

Report

Posted on by NicolleAbraham

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

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

NicolleAbraham 93 on at

Like
a
(0)

Report
Copy link

Link copied!

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.