Answered

Static Table or Collection for Speed

(0) Share

Report

Posted on by mwolfe86

Hello,

We have an app that has many different galleries that act as menus and are basically static menu data. Currently we populate these menus using ClearCollect.

Is this the most efficient way to do this or should we import static tables via excel to build the menus? Perhaps it doesn't make any difference at all.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@mwolfe86
Static data loads faster initially since it is already stored on the device. You would have to wait a small bit of time at the start of the app to load data from another source (e.g. SharePoint) into a Collection.

But once you've got menu information inside a Collection its equally fast as static data. I would not worry over it too much 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

I think the difference between ClearCollect and Static would be the loading of the App if the coLlection is OnStart of the App. Also the loading of the Screen if the collection is OnVisible, it may delay it a bit depending on the data. So i would go for Static data in terms of speed.
However note that the after the collection is loaded, the speed may be the same
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
mwolfe86 26 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the responses. I am trying to speed up the appload performance.

Many of these collections reference media images in the app, is there a way to reference that media image in the static table that would be compiled in Excel?

As an example, the Logo field is a reference to media within the app:
ClearCollect(collCountries,
{Country: "Global", Logo: world},
{Country: "Australia", Logo: australia},
{Country: "Belgium", Logo: belgium},
{Country: "Brazil", Logo: brazil},
{Country: "China", Logo: china},
{Country: "Germany", Logo: germany},
{Country: "Hong Kong", Logo: hongkong},
{Country: "India", Logo: india},
{Country: "Indonesia", Logo: indonesia},
{Country: "USA", Logo: usa},
{Country: "Vietnam", Logo: vietnam}
)

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@mwolfe86
No, you cannot make a direct reference to an image from Excel like you have shown below.

You CAN make a reference to a URL if it is stored somewhere, then use it in the Image property of an image.

"https://onedrive.com/folder.image.jpg"

What I would really recommend here is just to make a Collection inside your app to accomplish this, not a static data import.

Best of luck building your app!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
mwolfe86 26 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for the quick feedback. Seems I may be able to address some via tables and others by collections.

Sure would be nice if PowerApps gave you a way to find where all your collections are in use(similar to that of variables), would be an easy way to clean up messes.

Was this reply helpful? Yes No