cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cma2438
Helper II
Helper II

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

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

3 REPLIES 3
PSahu
Advocate II
Advocate II

Try below:

 

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

 

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Thanks!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,923)