Answered

Creating new collection vs adding columns directly in Gallery

(0) Share

Report

Posted on by rbn_ai

Hi Folks,

I have a canvas app which shows some details in a gallery. Most columns are coming from a single collection (colA). There's a status column in the gallery which depends on data in a table in data verse. This table data is already available in a local collection(colB).

I need to show the status value in gallery. Now I can create a new collection(colC) and add the status column using add columns to the colA and lookup colB and use colC as items of gallery. Or I can just directly do this inside gallery with out creating new collection but putting AddColumns(colA..) as items in gallery.

colA - can have a maximum of 1000 items

From a performance standpoint which is the better approach. I feel I should try to not use extra collection as it might cause more RAM usage. Does the same happen with Gallery?

Any insights will be appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Hi @rbn_ai ,

You can use function in the Gallery controls to display values from other collections, and it will also have better performance than creating another collection. It will also use RAM and CPU resource, but less than creating another collection. But honestly, if the number of colA items remains to 1000 or a little larger, there is no significant difference.

Best regards,

Was this reply helpful? Yes No
rbn_ai 22 on at

Like (0)

Report

hi @v-jefferni

Thanks for the response. I understand the difference is less in my scenario, but wanted to know which is the best practice. Appreciate the input.

Was this reply helpful? Yes No