Filter Dropdown by Another Dropdown

[HubbardInc]

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.

[eka24]

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]

-and-

[HubbardInc]

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

[eka24]

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.

[HubbardInc]

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

[v-yutliu-msft · Accepted solution]

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,