Compare two collections and list only no matchin data

[wagnerfraga]

Hi guys,

sorry if there is an answer to this question, I tried to find but no success.

I have two excel tables:

skillset - Filter(skillset,'name id'=Gallery_resources.Selected.id)

id	name_id	skill type	skill
2	1	Design	UX
5	1	Design	DESIGN

skilllist - table to populate the drop down

id	skilltype	skill
34	Design	DESIGN
48	Design	CREATIVE DESIGN
49	Design	CREATIVE/CONTENT STRATEGY
52	Design	UX
65	App	ANDROID
72	App	PHONEGAP

I am creating a function to add skill in the skillset table.

I want to populate a Drop Down only with skills not added in the skillset table for the user 'name id'=1 (remove the recorded skills for the user 'name id'=1)

Any idea?

thanks

[v-yutliu-msft]

Hi @wagnerfraga ,

Do you want to display items that are not in  skillset?

I've made a similar test for your reference:

Set the drop down's Items:

skilllist

Set the drop down's Value:

skill

Set the drop down's items:

Filter(skilllist,Not(skill in skillset.skill))

Please pay attention to the setting's order.

Best regards,

Community Support Team _ Phoebe Liu

[wagnerfraga]

Hi @v-yutliu-msft 

Thanks for coming back to me so quickly.

Almost there.
I want to display items that are not in skills and related to an specific user id, since I am adding skills to this employee.
I tried this, but it is not working:

Filter(skilllist,Not(skill in skillset.Skill)&&Gallery_resources.Selected.id=skillset.'name id')

do you know why?

Thanks again,

Wagner

[v-yutliu-msft · Accepted solution]

Hi @wagnerfraga ,

Since the two conditions are used to filter two tables, you can't just combine them directly.

I suggest you save the filtered data of skillset as a collection.(You could set the gallery's arrow icon's OnSelect)

ClearCollect(skillset2,Filter(skillset,'name id'=Gallery_resources.Selected.id))

And then filter skilllist:

Filter(skilllist,Not(skill in skillset2.skill))

Best regards,

Community Support Team _ Phoebe Liu

[wagnerfraga]

Thanks so much @v-yutliu-msft 

You are badass!