Get unique and common values from 2 collections

(0) Share

Report

Posted on by Sam4

229

Hi,

I have two collections with the following items:

colBase: [1, 2, 3]

colRec: [3, 4, 5]

With this info I want to split colRec in two collections. One including the items that are in colBase and another one with items that are not in colBase. So in the example above, I should get

colRec1: [3]

colRec2: [4, 5]

I'm trying to find the right formulas to do this but not sure it is possible. Any help to point me in the right direction is appreciated.

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (2)

Report
Re: Get unique and common values from 2 collections

@Sam4

Here's my take on it:

//starting collections ClearCollect(colBase, [1, 2, 3]); ClearColelct(colRec, [3, 4, 5]); //solution collections ClearCollect(colInColBase, Filter(colRec, Value in colBase.Value); ClearCollect(colNotInColBase, Filter(colRec, !(Value in colBase.Value));

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Sam4 229 on at

Like (0)

Report

Re: Get unique and common values from 2 collections

thanks @mdevaney This worked for me. (apologies for the delay, I lost the access to my account and just recovered!)

Was this reply helpful? Yes No