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
Super User
Super User

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



My loving and understanding partner gives the best advice on fixing errors: "Just type in some different things".

Don't forget to Mark as Solution and Thumbs Up those who deserve it!
3 REPLIES 3
PSahu
Level: Powered On

Re: Filtering Text Input box

Try below:

 

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

 

Super User
Super User

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



My loving and understanding partner gives the best advice on fixing errors: "Just type in some different things".

Don't forget to Mark as Solution and Thumbs Up those who deserve it!
Highlighted
cma2438
Level: Powered On

Re: Filtering Text Input box

Thanks!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 33 members 4,285 guests
Please welcome our newest community members: