cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Post Prodigy
Post Prodigy

Drop down List Items Limites to 500?

I tried to show 1300 items on dropdown and I failed!

I tried combobox too, and collection.

 

How to fix this?

1 ACCEPTED SOLUTION

Accepted Solutions
PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Gorilla_8,

 

The Default collection limit of PowerApps in 500. You can increase this limit till 2000. 

Go to Settings -> General ->  change the limit to 2000.

 

PriyankaMadan10_0-1628005296419.png

 

 

 

 

View solution in original post

6 REPLIES 6
BCLS776
Community Champion
Community Champion

If you are using a SharePoint list, try increasing the row limit from 500 to 2000. Keep in mind that Distinct() is typically not delegable.

 

Hope that helps!

PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @Gorilla_8,

 

The Default collection limit of PowerApps in 500. You can increase this limit till 2000. 

Go to Settings -> General ->  change the limit to 2000.

 

PriyankaMadan10_0-1628005296419.png

 

 

 

 

View solution in original post

Gorilla_8
Post Prodigy
Post Prodigy

@PG_WorXz10 

 

If the DataSource is SharePoint and is more than 2000 records?

Hi @Gorilla_8 , 

 

Independent of the data source 2000 limit is of PowerApps, only 2000 records will be fetched in a single server hit.  

Gorilla_8
Post Prodigy
Post Prodigy

So, if I got a CDS datasource with 4000 items I can't show?

Hi @Gorilla_8 ,

 

In depends on the type of operation you need to perform. If you want to bind data in collection 2000 you can bind using default method or you can bind 2 collection with  2000 and combine into signal collection having 4000. 

If you want to search data you directly pass the entity/table name no need to binding the data in collection. 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,547)