How to implement this use case?
Current Setup: There are around 10+ SharePoint list forms that a team uses for collecting different info from their users. Let's say all of these lists have these 5 columns present in them (ID, First Name, Last Name, Email, Phone No ) and some other columns that are specific to each of those different lists. Each of these SharePoint lists have well over 2k records. Requirement: How can we build a Admin screen with a Gallery that shows these above 5 columns values (along with 6th column for list/form name) from all lists at a time? Since the data is huge in each of these lists, we need to take care of delegation as well. We can use collections to get 2k records from each of these lists OnVisible and then bind all of it into a single collection to show in a gallery but then delegation and app performance will cause issues with around 20k records loaded at a time so what is the best and most efficient way to tackle this problem?