Merge Two Collection of Two different Gallery

[manojrohit16]

Hello there,

I have two different Gallery and I want to merge those two Gallery into one using Collection.

ie.

Gallery1

ID: 1 ;Name: "abc",

ID: 2 ;Name: "abc",

ID: 3 ;Name: "abc"

Gallery2

ID: 1 ;Name1: "abc",

ID: 2 ;Name1: "abc",

ID: 3 ;Name1: "abc"

Expectation:

ID  Name    Name1

1    abc       abc

2    abc       abc

3    abc       abc

Please let me know how to achieve this output.

Regards,

[WarrenBelz · Accepted solution]

Hi @manojrohit16 ,

This blog of mine should assist you here.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[manojrohit16]

Hello @WarrenBelz 

Thank you for replying and sharing your blog to help me. 

[manojrohit16]

Hello @WarrenBelz ,

Your blog helped me a lot and I was stuck in output like I merged two columns from one collection to another.

Problem:
I have an issue with date control. It saves only one date from the gallery not others.

Can you please suggest to me why am I facing such an issue?

Regards,

Manoj Roy

[WarrenBelz]

Hi @manojrohit16 ,

Not sure what you mean - the field type should not matter

[manojrohit16]

Thank you for your message.

I was stuck to merge two collections into one and your blog helped to solve the issue but I use Date control in one Gallery and have an issue with date control. like only the first date of the gallery saved in db and others as blank.

I tried to troubleshoot that issue but I don't get any issue there so just want to know is there any limitation with date control or is anything that I need to understand before I apply the code that you have doe in your blog.

Regards,

Manoj Roy

[WarrenBelz]

@manojrohit16 ,

There is not restriction with Date fields - they should copy like any other field. I am assuming this field is in one of the collections (not just in the gallery)

[manojrohit16]

Hello @WarrenBelz ,

Following are the Steps :

Steps:

1. I  created a collection of two galleries.(Gallery1,Gallery2)

2. Save Merged Collections into another Gallery(Gallery3), I can see all the data perfectly in it.

3. I patch the Gallery Data into Sql like Below:
forall(Gallery3.AllItems,Patch(Db,Defaults(Db),{ field1: txtbox, etc.....}));

[WarrenBelz]

Hi @manojrohit16 ,

You did not mention SQL as the data source - there is an issue with dates and this article may assist. 

[manojrohit16]

Hello @WarrenBelz ,

Thank you for sharing the article, I read it and come to the point that it is having an issue with datetime type while I have only the date type in SQL. If I'm wrong to understand the article then please let me know.

You can see that I can get the first row of date but the rest is blank.

Regards,

Manoj Roy