Answered

Concurrent collection not returning all records

(0) Share

Report

Posted on by yplay27

Hello and thanks in advance!

I wrote the following concurrency. This collects data from a sharepoint list called "whereabouts" into the collections ColA, ColB, ColC and ColD and is collected into the final collection called ColWhereabouts2. I've confirmed the data is getting collected properly but it eventually hits it's threshold at 2,000 records. My filter is on the Out of the Box ID column in sharepoint. Any ideas what i'm doing wrong?

Concurrent(
 ClearCollect(
 ColA,
 Filter(
 WhereAbouts,
 ID < 2000
 )
 ),
 ClearCollect(
 ColB,
 Filter(
 WhereAbouts,
 ID > 2000 And ID < 4000
 )
 ),
 ClearCollect(
 ColC,
 Filter(
 WhereAbouts,
 ID > 4000 And ID < 6000
 )
 ),
 ClearCollect(
 ColD,
 Filter(
 WhereAbouts,
 ID > 6000 And ID < 8000
 )
 )
);
ClearCollect(
 ColWhereAbouts2,
 ShowColumns(
 SortByColumns(
 ColA,
 "ID",
 Ascending
 ),
 "Employee",
 "EmployeeEmail",
 "StartDate",
 "EndDate",
 "Location",
 "Department",
 "Whereabout_x0020_Concat",
 "WhereaboutType",
 "ID"
 ),
 ShowColumns(
 SortByColumns(
 ColB,
 "ID",
 Ascending
 ),
 "Employee",
 "EmployeeEmail",
 "StartDate",
 "EndDate",
 "Location",
 "Department",
 "Whereabout_x0020_Concat",
 "WhereaboutType",
 "ID"
 ),
 ShowColumns(
 SortByColumns(
 ColC,
 "ID",
 Ascending
 ),
 "Employee",
 "EmployeeEmail",
 "StartDate",
 "EndDate",
 "Location",
 "Department",
 "Whereabout_x0020_Concat",
 "WhereaboutType",
 "ID"
 ),
 ShowColumns(
 SortByColumns(
 ColD,
 "ID",
 Ascending
 ),
 "Employee",
 "EmployeeEmail",
 "StartDate",
 "EndDate",
 "Location",
 "Department",
 "Whereabout_x0020_Concat",
 "WhereaboutType",
 "ID"
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi @yplay27 ,

]That is because the ID column is only Delegable for equals = not greater than > or less than <. If you want to collect all records, you need to maintain a separate "shadow" numeric field with the ID number in it. I have a blog on the process that may be useful.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
yplay27 70 on at

Like (0)

Report

Your blog post was extremely insightful and helped me solve the problem. Thank you! The solution was to create a shadow field in sharepoint called "IDFilter" and replaced the "ID" field in my code above. I used your powerautomate approach to update the "IDFilter" in sharepoint as this was the quickest solution for me. Once again thank you, you are a powerhouse and your responses are greatly appreciated!

Was this reply helpful? Yes No