Answered

How we can allow a ComboBox to filter and get items from sharePoint when the related sharePoint list contain more than 2,000

(1) Share

Report

Posted on by johnjohn123

3,514

I have a SharePoint list named Assets which contain around 3,200 items, as follow (last item has a title = Screen2999):-

Now inside the Power Apps canvas application, i added a ComboBox which is linked to the Assets list inside a form, as follow:-

now the combobox will only show 2000 items out of the 3200 items, which is understandable since Power apps can only get 2000 items per request. but even if i type the Asset title as "Screen2999" inside the combobox i will not get it... so is there a way to allow the Combobox to get any item from SharePoint list as per our filter/search? or the combobox will only filter the 2000 items it already get? if this is the case, then how we can solve this issue?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@johnjohn123 ,

This would be much easier if all the values did not start with Screen (as per this blog of mine). You do not actually need Distinct out of that blog - this will work

With( { _Data: Filter( Assets, StartsWith( Title, Self.SearchText ) ) }, Sort( _Data, Title ) )

but you are going to need to get the entry to Screen2 before you get all the 200s and 2000s.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks this is working well.. finally i am getting something working well for large lists..

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz but i faced another issue, is that previously i were selecting the combobox selected item' Title & ID as follow,, but this not more working after i applied the new formula:-

is there a way to fix this?

Was this reply helpful? Yes No
WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123 ,

That is because you have (I assume) used Distinct (which only returns one column - Value) - did you try the code I posted ?

Was this reply helpful? Yes No