cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Join two different lists and display data in gallery

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??

 

1 ACCEPTED SOLUTION

Accepted Solutions
Responsive Resident
Responsive Resident

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.

View solution in original post

1 REPLY 1
Responsive Resident
Responsive Resident

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.

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (10,476)