Help, I'm confuse how to merge with two collection in powerapps

[dhisss]

I'm new at this platform 
and right now I'm stuck in this problem 

So, I have 2 collection that has same kinds of columns but the value for those two collection is not same 
I want to merge these 2 collection, with 
1. If it is same ID, it will fill the blank column
2. If it is not the same id, It will add new row 

like this one:


Can you guys help me 😞

[RusselThomas · Accepted solution]

Hi @dhisss ,

Based on your example, there are some assumptions;

• There is at least one table that has all values - in this case collection2, let's call it our primary table.
• There is another table that has some of the values that already exist in the primary table - in this case collection1, let's call it our mergetable.
• The mergetable does not contain any items that do not already exist in the primary table.

If the above assumptions are accurate, you can try this;

ForAll(collection2,
    Collect(collection3, {
        Code: ThisRecord.Code, 
        Standard: If(IsBlank(LookUp(collection1, Code=ThisRecord.Code, Standard)), ThisRecord.Standard, LookUp(collection1, Code=ThisRecord.Code, Standard)), 
        Aging: ThisRecord.Aging}
    )
)

We basically recollect everything from our primary table into collection3, and just copy the fields from the primary table across, with the exception of the "Standard" field - here we first check to see if any similar entries exist in our mergetable for that particular Code.  If it exists, we pull the "Standard" field from the mergetable, otherwise the Standard field also comes from the primary table.

Hope this helps,

RT

[dhisss]

Hi @RusselThomas 

thank you for this answer

But I'm sorry I think I wrote it not in detail so you have misconception. But it still good knowledge that I can learnt from your answer

I have written again in a post with very detail explanation
I would be feel very grateful if you want to check the detail problem in here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/merge-2-collection-with-same-exact-column/m-...

Thank you 😄