Filtering Text Input box

[cma2438]

I have a Dropdown box that the user would select a manager after that I have a text input box that would show the selected managers email. I am using the following Code but i can seem to get it to work. 

Filter(HIERARCHY, ManagerFilter.Selected.Value = MGR_NAME).MGR_EMAIL

any idea? or a better way to make it work?

[PSahu]

Try below:

First(Filter(HIERARCHY, MGR_NAME=ManagerFilter.Selected.Value)).MGR_EMAIL.

[iAm_ManCat · Accepted solution]

I would also use LookUp instead as a more efficient call - by using filtering and then a First() you are forcing it to look through all records and filter out remaining records where value=true then select the first (and only record) after that.

If you do a lookup, it only looks up that specific record where value=true.

So:

LookUp(HIERARCHY, MGR_NAME=ManagerFilter.Selected.Value).MGR_EMAIL

[cma2438]

Thanks!