cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wagnerfraga
Frequent Visitor

Compare two collections and list only no matchin data

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)

idname_idskill typeskill
21DesignUX
51DesignDESIGN

 

skilllist - table to populate the drop down

idskilltypeskill
34DesignDESIGN
48DesignCREATIVE DESIGN
49DesignCREATIVE/CONTENT STRATEGY
52DesignUX
65AppANDROID
72AppPHONEGAP

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yutliu-msft
Community Support
Community Support

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

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks so much @v-yutliu-msft 

You are badass!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,160)