cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HubbardInc
Helper III
Helper III

Filter Dropdown by Another Dropdown

I have a form to submit IT Support Tickets. When an employee selected the equipment lets say "Company Email", I wan't another dropdown menu to show only the items that is related to Company Email. The "Issues" sharepoint list has two columns, Title and equipmentType that is a lookup column. Below are a couple of pictures for reference.

 

equipmentissues.jpgequipmentchoices.jpgissue dropdown.jpgequipment drop down.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @HubbardInc ,

Could you tell me

1)which list do you want to update by using this form?

2)do you want to display title field of ITSupportTicketEquipmentChoices in datacardvalue104?

3)do you want to filter equipmentIssues list based on the selected of datacardvalue104 in datacardvalue29?

4)which field do you want to update by using datacardvalue104? data type?

which field do you want to update by using datacardvalue29? data type?

 

I assume that you want to update  equipmentIssues list by using this form.

datacardvalue104 is used to display title field of ITSupportTicketEquipmentChoices and update equipmentwithisue field(lookup field).

datacardvalue29 is used to display issue field and update issue field(text type.)

 

If so, you could set like this:

datacardvalue104's Items:

Choices(equipmentIssues.equipmentIssues)

datacardvalue104's Update:

datacardvalue104.Selected

datacardvalue29's Items:

Filter(equipmentIssues,equipmentwithisue=datacardvalue104.Selected)

 datacardvalue29's Update:

datacardvalue29.Selected.issue

 

 

 

Best regards,

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

6 REPLIES 6
eka24
Super User
Super User

You didnt shoow the items property but try:

Dropdown1

Distinct(Datasource,CompanyEmail)

 

Dropdown2

Filter(Datasource,CompanyEmail=Dropdown1.Selected.Result)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

HubbardInc_0-1596026331616.png

-and-

HubbardInc_1-1596026360899.png

 

It almost worked but the second dropdown for the issue is not quite working.

 

HubbardInc_0-1596026959992.png

 

eka24
Super User
Super User

The writings on the screen shot is not clear. Add . Value to the Column name before equal to symbol in the second dropdown.

Example; Column.Value=Dropdown1.selected.Result

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Now it doesn't seem to update the sharepoint list item. The update fields are below.

 

HubbardInc_0-1596042993525.png

 

 

HubbardInc_1-1596043013472.png

 

Hi @HubbardInc ,

Could you tell me

1)which list do you want to update by using this form?

2)do you want to display title field of ITSupportTicketEquipmentChoices in datacardvalue104?

3)do you want to filter equipmentIssues list based on the selected of datacardvalue104 in datacardvalue29?

4)which field do you want to update by using datacardvalue104? data type?

which field do you want to update by using datacardvalue29? data type?

 

I assume that you want to update  equipmentIssues list by using this form.

datacardvalue104 is used to display title field of ITSupportTicketEquipmentChoices and update equipmentwithisue field(lookup field).

datacardvalue29 is used to display issue field and update issue field(text type.)

 

If so, you could set like this:

datacardvalue104's Items:

Choices(equipmentIssues.equipmentIssues)

datacardvalue104's Update:

datacardvalue104.Selected

datacardvalue29's Items:

Filter(equipmentIssues,equipmentwithisue=datacardvalue104.Selected)

 datacardvalue29's Update:

datacardvalue29.Selected.issue

 

 

 

Best regards,

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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