Answered

PowerApps: Merge two collections together and populate a gallery with the merged collection

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have two collections in the screen OnVisible. They are:

ClearCollect(colKeyCombos1,Filter('Master Key Log',Branch.Value = gblOffice && Status.Value = "3 Approved" && Assigned_x0020_Keys < Key_x0020_Inventory && 'Key Type'.Value <> "Combination"));

ClearCollect(colKeyCombos2,Filter('Master Key Log',Branch.Value = gblOffice && Status.Value = "3 Approved" && 'Key Type'.Value = "Combination"));

They have exactly the same columns as they're coming from the same Data Source. (Actually, I'd like to combine them into one ClearCollect but I keep getting an error when I try it, so I divided them into two.)

How do I merge them into a different collection, or add colKeyCombos2 to colKeyCombos1?

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SolTeferi on at

Like (1)

Report
Hi @Anonymous ,
To create a new merged collection, you can use the following:
ClearCollect(MergedCollection,colKeyCombos1,colKeyCombos2)
Or, to append the second collection to the first, use the following:
Collect(colKeyCombos1,colKeyCombos2)
Hope that will do it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thank you so much! What I discovered was that if I changed the second one to just a Collect and used the same collection variable (colKeyCombos1), it accomplished what I was looking for.

Was this reply helpful? Yes No
SolTeferi on at

Like (0)

Report

Awesome! That is a good trick too. Thanks!

Was this reply helpful? Yes No