dropdown list to bring back relevant values depending on what was typed in another card

[stebro1986]

hi all

wondering whether you could help me.

I've got Dropdown box  (dropdown 6), I want to link that to a list the distinct Values to my SharePoint list called (Master L2 to L5)

but I want Dropdown6 to only bring back the values which contains the value in DataCardValue16_1

i.e. If I enter "123" in DataCardValue16_1, I only want Dropdown6 to show me the relevant values showing "123"

I was wondering if you could help me with the formula please

[jcfDaniel]

Hi,

Disctinct is not delegable, so be aware of that.

Taht said, you can leverage the Default property of that dropdown to show a value and also set AllowEmptySelection for when no value is found.

Lookup( Table/Collection, Column = DataCardValue16_1.Text ).ColumnToShow

Regards

[stebro1986]

sorry just to confirm table means my sharepoint list? what is meant by Collection? and I presume Column is the data, I want to bring back?

[jcfDaniel]

Yes, Table/Collection stand for datasource (your list, in this case).

[stebro1986]

LookUp('Master L2 to L5','Org L5' =Dropdown6.SelectedText.Value).'Org L5')

it's not working

basically Dropdown 6 will just bring the relevant values which contains 123 in the Org L5

so if the end user in Datacardvalue16, enters 123, the Dropdown6 could bring back Dept A 123 or Dept B 123

[jcfDaniel]

Remove the last ")" 

What kind of data type is Org L5?