Unanswered

How To filter records more than 2000 records in Combo Box

(0) Share

Report

Posted on by B8

272

I have a Share Point list which has Region , Country and Company which i had added in my PowerApps and using cascading to filter those Three column in my combo Box. But for UNITED STATES their are more the 2000+ company and I can only see 2000 records.

For Region I have Drop Down - East , West , North , South ,

For Country i had added a formula in Combo Box Items : If(!IsBlank(DropdownRegion.Selected.Value),Distinct(Filter('MYSharePointList','Account Region' = DropdownRegion.Selected.Value),'Account Country')) ,

For Company I had added a formula in Combo Box Items : If(!IsBlank(ComboBox1.SelectedItems),Distinct(Filter('MYSharePointList','Account Name Starting Letter' = ComboBox1.Selected.Result),'Account Name')).

But I can only see 2000 records in my Company List when i am selecting UNITEDSTATES.

One more option i had added that when i selected UNITEDSTATES in my country list it give popup to add Company name but still it is showing 2000 records only.

How to perform this issue so that for UNITEDSTATED in get the full list from my sharepoint.

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@B8

see @WarrenBelz 's blog Practical PowerApps for work arounds for delegation issues. If your list does not change, You can use the static Excel connector for it and totally avoid delegation. Up to 15,000 items can be imported and searched in seconds.

FYI: In my blog post https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-using-Zip-Codes-in-your-App/ba-p/200465 I used the US postal service data 42,000+ items in my app.
B8 272 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you explain this in my case because i am new to Power Platform where and what i have to write
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@B8

How often do you need to add new records to your master list?
B8 272 on at

Like
a
(0)

Report
Copy link

Link copied!

Simply Now i have my List Often to add is not mandatory right now. I just need to see my Full List
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@B8

From SharePoint, save your list as an Excel file and then import it into your app from Excel. Call it Excellist

DropdownRegion: Items: {"North","South","East","West"]

ComboBox1: Sort(Distinct( Filter(Excellist, !IsBlank(DropdownRegion.Selected.Value) || 'Account Region' = DropdownRegion.Selected.Value), 'Account Country'), Result)

ComboboxCompany: Filter(Excellist, Len(ComboBox1.SelectedItems)=0 || Country = ComboBox1.Selected.Result)
B8 272 on at

Like
a
(0)

Report
Copy link

Link copied!

Its showing Incompatible type of comparison. These types can't be compared : table , Number

and this is not filtering the Country according to Region
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@B8

Try ComboBox1, Items:

Sort( Distinct( Filter( Excellist, 'Account Region' = DropdownRegion.Selected.Value ), Country ), Result )

ComboboxCompany:

Filter( Table1, Len(ComboBox1.Selected.Result)=0 || Country = ComboBox1.Selected.Result )
B8 272 on at

Like
a
(0)

Report
Copy link

Link copied!

Not working With this code i am unable to fetch Country list and in my company my country is comping