cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike-Seitz
Frequent Visitor

Combo Box filter for SharePoint multi-select lookup column

I have two SharePoint lists...

 

TeamMembers (contains employees and leave plan(s) they are eligible for)

-Title(TeamMemberNumber)

-LeavePlans (multi-select lookup into LeavePlans list below)

 

LeavePlans (contains all valid leave plans - Vacation, Personal, Other)

-Title

 

Want to filter Combo Box in PowerApps to allow user to select one of the leave plans they are eligible for.

 

Choices('Team Members'.LeavePlans) in Items property shows ALL leave plans.  What would the FILTER statement look like to select leave plan(s) for a specific team member (entered in text box on same screen) ?

 

Thanks in advance.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mike-Seitz
Frequent Visitor

Was able to solve this myself...

 

1. Captured the team member's leave plans in a collection (from another collection).  Collection contained "Id" and "Value" columns.

 

ClearCollect(colTeamMembers, 

Filter('Team Members' ,'Team Member Number' = txtNewTeamMemberNumber.Text));
ClearCollect(colTeamMemberLeavePlans, First(colTeamMembers).LeavePlans);

 

2. Set combo box Items to the value...

 

colTeamMemberLeavePlans.Value

 

 

View solution in original post

1 REPLY 1
Mike-Seitz
Frequent Visitor

Was able to solve this myself...

 

1. Captured the team member's leave plans in a collection (from another collection).  Collection contained "Id" and "Value" columns.

 

ClearCollect(colTeamMembers, 

Filter('Team Members' ,'Team Member Number' = txtNewTeamMemberNumber.Text));
ClearCollect(colTeamMemberLeavePlans, First(colTeamMembers).LeavePlans);

 

2. Set combo box Items to the value...

 

colTeamMemberLeavePlans.Value

 

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

Top Solution Authors
Top Kudoed Authors
Users online (3,367)