cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Canadiansal
Helper V
Helper V

Lists - max records

I have a dropdown that selects distinct from a Sharepoint list. Currently, I cannot see all the distinct options. Does List have a limit on the number of records? I am currently at 1200 records. Could this be the issue?

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
RandyHayes
Super User
Super User

@Canadiansal 

No, but the Distinct function is not delegable, so if your record count is more than the record limit you have set in the app settings, then you will not get complete results.

I would check your app settings to see what your record limit is currently and adjust as necessary.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

@Canadiansal 

Yeah, if it is only 5 and will never really change, then I would just put it directly in the app, but if there is a chance of changes, then either put them in their own separate list or at least isolate in the app in such a way that it is easy to maintain.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

6 REPLIES 6
RandyHayes
Super User
Super User

@Canadiansal 

No, but the Distinct function is not delegable, so if your record count is more than the record limit you have set in the app settings, then you will not get complete results.

I would check your app settings to see what your record limit is currently and adjust as necessary.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Canadiansal
Helper V
Helper V

You are right - its currently at 500. Do I need to republish after I make the change? Is there an alternative to the select that I can use? can I hard code the values in the dropdown?

RandyHayes
Super User
Super User

@Canadiansal 

Yes, you can increase the record limit (max is 2000) and you would need to republish then.

As for putting static values for your dropdown...yes, you can do that, but my question on that would be based on how many values would you have and how often would it change?  You seemed to go toward a Distinct function for a reason.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Canadiansal
Helper V
Helper V

It probably will not exceed 5. The distinct was an experiment that worked out.

How to use distinct on a data source with 6000 record?

@Canadiansal 

Yeah, if it is only 5 and will never really change, then I would just put it directly in the app, but if there is a chance of changes, then either put them in their own separate list or at least isolate in the app in such a way that it is easy to maintain.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,385)