cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Slowpoke
Resolver II
Resolver II

Mutliple collections in a gallery.

Hi everyone,

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

Slowpoke_0-1662044092763.png


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.

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@Slowpoke 

Then you can combine them into a single collection.  

Collect(alldata,varcol, varcat, varekip,varperi)

View solution in original post

6 REPLIES 6
Drrickryp
Super User
Super User

@Slowpoke 

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

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

Drrickryp
Super User
Super User

@Slowpoke 

Then you can combine them into a single collection.  

Collect(alldata,varcol, varcat, varekip,varperi)

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
Super User

@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. 

Ok thank you for your quick answers

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,264)