Announcements
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,
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
Hello @WarrenBelz
Thank you for replying and sharing your blog to help me.
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?
Manoj Roy
Not sure what you mean - the field type should not matter
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.
@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)
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.....}));
You did not mention SQL as the data source - there is an issue with dates and this article may assist.
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.
I posted the article because I do not use SQL with Power Apps - I am a SharePoint only user, so am probably the wrong person to trouble-shoot this going forward, although your logic seems valid to me.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
