How to Create Collection in PowerApps with reference SP Lists over 2000

(0) Share

Report

Posted on by jmaur769

I have a PowerApp that references 2 SharePoint lists. One SharePoint list is a list of items, the second is a linked list for a list of lots of all items.

Example:

SharePoint List 1 – List of bicycle types

SharePoint List 2 – A list of all lots of each type added to one table (this contains a reference ID column that corresponds to the appropriate type of bicycle in List 1).

I want to add a column to a collection in the PowerApp for the list of bicycle types that states how many lots of each exist. The issue is that list 1 will never be over 2000, however, the entirety of list 2 will be over 2000. Is there a way to add a column to the collection that will be able to add the column to the collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,029 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jmaur769 ,

Try this - you will need to use your actual list and field names

Clear(colTypes); ForAll( SPList1 As _Data, Collect( colTypes, Table( { Type: _Data.BicycleType, Items: With( { _Matches: Filter( SPList2, ReferenceID = _Data.ID ) }, CountRows(_Matches) ) } ) ) )

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