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
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.
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."
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.