Announcements
I have created two collections 1 and 2. Collection 1 has some people and scores which are all initialized with 0's. Collection 2 has some people and scores which are already well evaluated. So now I would like to join these two collections and keep values from Collection 2 if there are duplicate people. However, I tried so many ways and did not get good solution on it. Could anyone show some clues about it?
Hi this post is very similar to this, please take a look: https://powerusers.microsoft.com/t5/Building-Power-Apps/Join-two-collections/td-p/395929
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Try
ClearCollect( ColMerge, Col1, Col2 )
@karolyuan
Collect(Collection3,Collection2,Filter(Collection1, !(ID in Collection2.ID))
I have tried this solution, but it turns out everyone's score will be updated to the same. It doesn't update with the proper person.
This cannot remove duplicate people from collection 1.
Use Distinct Function on your collection.
Awesome! Thank you so much for your quick and clean answer.😺
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 236 Super User 2026 Season 2
WarrenBelz 188 Most Valuable Professional
Mohsin Ali 130