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".
- 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).
- 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?
