Display Filtered Values by Unique Text

[bpplls]

Hi, I have a dropdown 

called, DropdownID1 that has 2 values

and I have another dropdown called Dropdown2 that has been filtered by the selected value of DropdownID1

and this is the code I used.

Proper(Filter(container.key, EndsWith(key, DropdownID1.SelectedText.Result)))

Dropdown2

Question is how can I display only the "Testche" value on the the Dropdown2?

Thank you in advance!

[CNT · Accepted solution]

@bpplls 

Please try the following,

With({myRecords: Proper(Filter(container.key, EndsWith(key, DropdownID1.SelectedText.Result)))},
	ForAll(myRecords, Left(ThisRecord.key ,Match(ThisRecord.key ,"-").StartMatch-1))
)

Please remember to give a 👍 and accept my solution as it will help others in the future.

[bpplls]

Thank you for your help! It widens my knowledge on With function. 100% helpful

[CNT]

@bpplls 

Glad to help!