Filter 2 tables in order to get a result

[PowerBSC_Dev]

Hi Mates, 

I'm creating an app and I have a dropdown that should give me a 'contact person' depending on a "Customer Name" and "Department", let me show you:

So, In my sharepoint Lists, I have 2 Lists: 

The "Contacts and depart" and the "Costumers Contacts".

1. The DropBox Costumer name is linked to the result of the ComboBox, associated to the list "Costumers Contacts" to the 'Title' Column, that is in the previous screen (it should appear the costumer name).
2. The department dropbox is linked to the "Contacts and Depart" list

Note: In the "Contacts and depart" list, i have the contact person column too. 

-----

So, in order to get a Contact Person in the dropbox, i made this formula:

• Distinct('Contacts and depart','Contact Person', Filter(Dropdown11.Selected.Title in Dropdown13.Selected.Result))

However, the formula it doesn't work (probably, it's wrong)

I tried a lot of formulas and i always have an error or otions in blank.

Could you help me to discover the correct formula? 

[PowerBSC_Dev]

I made a update in the formula:

Filter('Contacts and depart', Department = Dropdown13.Selected.Result, Hospital = Dropdown11.Selected.Title)

The formula don't show me any error but I can't see any contact person yet. 

[PowerBSC_Dev · Accepted solution]

Solved!

I had to change the dropdown11 formula to:

Filter('Costumers Contacts',Title = ComboBox11.Selected.Title)