Join two different lists and display data in gallery

[abd3127]

Hi team,

I am trying to display data from 4 different sharepoint lists using the "Add Column" function. The steps for same are given in this post here.

The data is getting displayed as i want. The only problem that i have is the time it takes to display data. It takes more than 1 minute to load and display data. 

The sharepoint lists have around 50 records.

Is there any way that i can reduce this time taken to load the data??

[tommyly · Accepted solution]

Based on the accepted solution from your previous post (and referenced link), one way to speed up your query is to load the data into PowerApps memory first.

If you're dealing with 50 items, you can probably ClearCollect the entirety of your lists into a collection. If you suspect that list could grow, then you may want to implement a design where the users filter their data initially (e.g. select a timeframe or categories, which feed into a filtered ClearCollect statement).

You will notice that when PowerApps is dealing with in-memory collections, performance is way faster.