Answered

Showing two Sharepiont Lists Appended in single Power App Gallery

(0) Share

Report

Posted on by Massingc1983

122

I am working with two sharepoint lists, "List1 - Open", "List 2 - Archive" both have exactly the same columns. I am trying to append the lists into one single lists within powerapps so all the items can be viewed in a single gallery. List 2 has over 12,000 items and list one 2000, when i create a collection i am not seeing all the items within the gallery.

Collection Code

ClearCollect(CompleteList,'List1 - Open','List 2 - Archive')
 
I understand this is due to the amount of items in the sharepoint lists and the collection limit but is there a different approach i should be using to be able to view and filter this data?
 
Kind rehards
 
Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

MS.Ragavendar 5,004 Super User 2025 Season 2 on at

Like (0)

Report

@Massingc1983,

This is due to the delegation limit in power apps.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Kindly follow the standards - https://www.matthewdevaney.com/sharepoint-delegation-cheat-sheet-for-power-apps/

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @Massingc1983,

The maximum you are going to be able to collect with that code is 2,000 from each list. I have a blog that may allow collection of all items - you will however need to have a unique numeric identifier other than the ID in both lists (you can actually copy the ID into this field when the record is created).

I will however caution you that collections much more than 4,000 - 5,000 records suffer performance issues, which increase the bigger the number - 14,000 items will likely cause some challenges in user expectations.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No