cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cma2438
Level: Powered On

Filtering Text Input box

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
iAm_ManCat
Level 10

Re: Filtering Text Input box

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

3 REPLIES 3
PSahu
Level: Powered On

Re: Filtering Text Input box

Try below:

 

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

 

Highlighted
iAm_ManCat
Level 10

Re: Filtering Text Input box

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
Level: Powered On

Re: Filtering Text Input box

Thanks!