cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dgarza
Regular Visitor

Filter Drop Down Box based on previous selections

I have 4 Lookup fields in my sharepoint list (Drive1, Drive2, Drive3 & Drive4).  The 4 lookup fields all point to a "DriveLetter" list.  The DriveLetter list is a single column with 26 records, A-Z.  If I select a Letter in one of the lookup fields how can I exclude that letter from the other dropdown fields?  I have tried using distinct, filter and search for that past 4 hours and simply can't get it to work or wrap my head around it.  I have searched and tried every example with no luck.

 

Please help...

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuxima-msft
Community Support
Community Support

Hi @dgarza,

 

Do you want to exclude that letter from the other dropdown fields when you select it previous?

I think you can try following workaround:

My Test as next:

 

Data Source:

1.20190205Filterdown1(My SP list name)

20190205filterdropdownSP1.png

2.20190205FilterDropdown2(My SP list name),

Column Drive1,Drive2,Drive3,Drive4 are look up type.

20190205filterdropdown2sp2.jpg

App Test:

Add 4 drop down controls and rename them as Drive1,Drive2,Drive3,Drive4.

Drive1.Items: Choices('20190205FilterDropdown2'.Drive1)

Drive2.Items: Filter(Choices('20190205FilterDropdown2'.Drive2),Value<>(Drive1.Selected.Value))

Drive3.Items: Filter(Choices('20190205FilterDropdown2'.Drive3),Value<>(Drive1.Selected.Value)&&Value<>(Drive2.Selected.Value))

Drive4.Items: Filter(Choices('20190205FilterDropdown2'.Drive4),Value<>(Drive1.Selected.Value)&&Value<>(Drive2.Selected.Value)&&Value<>(Drive3.Selected.Value))

20190205filterdropdownapptest.png

Result Test:

20190205filterdropdown2.gif

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

1 REPLY 1
v-yuxima-msft
Community Support
Community Support

Hi @dgarza,

 

Do you want to exclude that letter from the other dropdown fields when you select it previous?

I think you can try following workaround:

My Test as next:

 

Data Source:

1.20190205Filterdown1(My SP list name)

20190205filterdropdownSP1.png

2.20190205FilterDropdown2(My SP list name),

Column Drive1,Drive2,Drive3,Drive4 are look up type.

20190205filterdropdown2sp2.jpg

App Test:

Add 4 drop down controls and rename them as Drive1,Drive2,Drive3,Drive4.

Drive1.Items: Choices('20190205FilterDropdown2'.Drive1)

Drive2.Items: Filter(Choices('20190205FilterDropdown2'.Drive2),Value<>(Drive1.Selected.Value))

Drive3.Items: Filter(Choices('20190205FilterDropdown2'.Drive3),Value<>(Drive1.Selected.Value)&&Value<>(Drive2.Selected.Value))

Drive4.Items: Filter(Choices('20190205FilterDropdown2'.Drive4),Value<>(Drive1.Selected.Value)&&Value<>(Drive2.Selected.Value)&&Value<>(Drive3.Selected.Value))

20190205filterdropdownapptest.png

Result Test:

20190205filterdropdown2.gif

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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 (1,269)