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.
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.
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:
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:
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
Check it out!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021