cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trickytechie
Frequent Visitor

ComboBox is not working with large dataset

I am  stuck in the middle of large dataset in PowerApps. I am cascading the combobox and successfully got it but the problem is my dataset is with large dataset.

 

Example: ComboBox1.Items : Choices(DataSourceName,ColumnName) [This is working fine]

ComboBox2.Items : Filter(DataSourceName, StartsWith(ColumnName.Value, ComboBox1.Selected.Value)).Title [This is also working fine but only when I am selecting 22nd value from combobox1. When I am selecting 23rd value from combobox1 the second combobox is not cascading the values.]

 

I increased the value from 500 to 2000 in AppSetting already but still not working.

 

Please help!!!!

 

6 REPLIES 6
RandyHayes
Super User
Super User

@trickytechie 

How large is the dataset? And what is the DataSource?

Your Filter formula is not delegable, so, if it is large beyond the datasource limits, you will not get accurate results.

_____________________________________________________________________________________
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.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

@RandyHayes ,

 

Dataset has 4K records and source is SharePoint list.

 

 

v-xida-msft
Community Support
Community Support

Hi @trickytechie ,

Could you please share a bit more about the data structure of your SP list?

Could you please share a bit more about the column name that you mentioned? Is it a Choice type column or LookUp type column in your SP list?

 

I suppose that you have faced a Delegation warning issue with the formula that you provided, is it true? If you have faced a Delegation warning issue with your formula, you could only process 500 reocrds locally at most in default (You could change the limit to 2000).

Note: The Choice type column or LookUp type column could not be used within StartsWith() function.

If the position of the corresponding record the 23rd value (selected from your ComboBox1) related to in your SP list is more than 2000, you would not get the corresponding Title value.

 

Please check and see if the following blog would help in your scenario:

https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it

 

As an alternative solution, you could consider take a try to add a extra Single line of text type column ("ExtraColumn") in your SP list to store the same value as that in your Choice column or LookUp column (ColumnName that you mentioned). Then modify your formula as below:

Filter(
'YourSPList',
StartsWith(ExtraColumn, ComboBox1.Selected.Value)
)

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@trickytechie 

That is too large for pulling in all the records in a standard way.  You might need to consider pulling in all the records into a local collection and then using that as your datasource.  Otherwise, you will definitely see the issues you are seeing.

You might want to take a look at this recent post that covers a lot of good ideas on how to pull large lists locally.

 

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.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

Thanks for posting in the community @trickytechie - can you review the above replies and update the thread if they were helpful? If you require further assistance I will do more research as well. 

 

Thank you,

 

@Anonymous 

Hipromark
Regular Visitor

Hello everyone. I was having a similar issue with a large data set and found a way to resolve it.

 

I had a Sharepoint list named 'Customers' wich had 2000 items (meaning 2000 records). This list had the following columns: ID, LastName, FirstName, Lastfirstname.

 

I had a drop down list in which I needed to search for a customer by LastName, FirstName. In my particular case, I was using my previously concatenated column  'Lastfirstname', so I was using this column in the drop down list, but it was not showing me the customers created after record 500. So this is what I did:

1. I inserted a Text input field and named it 'Lastnametxt'

2. Inserted the drop down list and selected the Sharepoint list 'Customers' as datasource for this drop down list

3. Selected the column 'Lastfirstname' as the column the drop down will search into 

4. Then in Advanced > Data > Items I inserted this formula: Filter(Customers, LastName = Lastnametxt.Text)

 

So with this, the user can put the last name of the customer in the text box and then go to the drop down and it shows the customers filtered, even if they are above the record number 500.

 

You can do this also using a combo box and that way you won't need the concatenated column (By the way, I really don't know if it is possible to concatenate columns in Sharepoint, I created my concatenated column in Access before exporting the table to Sharepoint)

 

Please click "Accept as Solution" if my post answered your question and If you found my post helpful consider giving it a "Thumbs Up." 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (1,520)