Mutliple collections in a gallery.

(0) Share

Report

Posted on by Slowpoke

157

Hi everyone,

I've created mutliple galleries that populate some collections when checked:

Respectively; varcol, varcat, varekip and varperi.

I would like to create a new gallery that regroup all the checked data (so a group of data from varcol, varcat, varekip and varperi.

I tried multiple formulas but none them seem to work.

Do you have any idea of a formula I could use?

I can provide more informations if needed.

Thank you by advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Slowpoke

Is the schema the same for each collection? If not, are there common fields between all the collections?
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes the schema is the same, they all have only a "value" column and that's all.
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Slowpoke

Then you can combine them into a single collection.

Collect(alldata,varcol, varcat, varekip,varperi)
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.

I'm maybe wrong but this solution implies to use a bouton to use the collect function.

Is there a way to not use a bouton or to do something like that : "display(alldata,varcol, varcat, varekip,varperi)"?
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Slowpoke

You can use a button or put it in the OnVisible property of the screen with the gallery to do it automatically but I think that some Action will be required to combine the collections. Also if any of them are changed after you create the collection, ClearCollect() will be required to recreate it.
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok thank you for your quick answers