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




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.

 

Highlighted
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




Don't forget to 'Mark as Solution' and 'Thumbs Up' those who deserve it!
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

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

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!

Users Online
Currently online: 40 members 4,148 guests
Please welcome our newest community members: