web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using collections to m...

Power Apps

Answered

Using collections to merge into one

(0) Share

Report

Report

Posted on by patty789

250

Hi,

I created two collections and i was able to merge them into a Master Collection, but the problem that i am having is that the new column i added to the Master collection is not showing me all of the options.

This is what i have on the OnSelect of a button ClearCollect(MasterCollection, AddColumns(planscol, "elevation", LookUp(colID, number = number,number))). How can i establish the relationship, and how to be able to show of the options coming from the ColID collection into the Master Collection?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@patty789 ,

The issue you have is naming your matching columns the same - you also need to use ForAll if you want each one to match. The last thing is I assume number is not the added column (you already have it).

Clear(MasterCollection); ForAll( planscol As aPlan, Collect( MasterCollection, AddColumns( aPlan, "elevation", LookUp( colID, number=aPlan.number ).YourColumnName ) ) )

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.

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @patty789 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No

Join the conversation