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?
Solved! Go to 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
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
Thanks!