Exclude items from one collection if they are found in the other collection

[JakFu86]

Greetings!
I have a smilingly easy but hard to code issue with my two collections.

First collection (colAllActiveProjects) gets fed info from dataverse table (Projects).

ClearCollect(

colAllActiveProjects,

Filter('Projects', project_is_active = true && project_is_archived = false)

);

I have another collection (colSubscriptions) and another table (Subscriptions). This gets populated like this:

ClearCollect(

colSubscriptions,

Filter('Subscriptions',

email = User().Email

)

);

The two tables are linked by a lookup field Projects.id -> Subscriptions.projectid.

I have two galleries that display both collections -

Gallery1.Items = colAllActiveProjects

Gallery2.Items = colSubscriptions. 

It works fine and displays all info correctly. but I would like to make it more clear. Meaning - if a user is subscribed to a project, that project is not placed in the Gallery1, it is only visible in Gallery2. I have buttons that add or remove projects from subscriptions. I would just like to have a list of available projects to exclude already subscribed ones.

Anyone?

[DBO_DV]

hey @JakFu86 ,

Can you try something like this? 

RemoveIf(colAllprojects,ID in colSubscriptions.ID)

Should be working like this.

[mmbr1606]

hey @JakFu86 

can u try this please:

ClearCollect(
    colAllActiveProjects,
    Filter(
        'Projects',
        project_is_active = true && project_is_archived = false
    )
);


ClearCollect(
    colSubscriptions,
    Filter(
        'Subscriptions',
        email = User().Email
    )
);


ClearCollect(
    colAllActiveProjects,
    Filter(
        colAllActiveProjects,
        Not(
            projectid in colSubscriptions.projectid
        )
    )
);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings