Compare two collections and list only no matchin data

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @Anonymous ,
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (8)

Report
Copy link

Link copied!
Hi @Anonymous ,
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks so much @v-yutliu-msft
You are badass!

Was this reply helpful? Yes No