cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sahara22
Helper V
Helper V

How to lookup based on two options

Hello, 

 

Looking for help on how to search a name based on one of the options bellow.

 

Names written in my excel sheet is either "John Smith" or "Mike Harris (@LSA)" 

 

My Formula I'm using below dose not work unfortunately :

 

Filter(Table1,FINAL_LOCATION=
LookUp(
Table1,
EMP_NAME=AUTONAME.Text || EMP_NAME= AUTONAME.Text, " (@LSA)").FINAL_LOCATION)

 

I used the "or" function but shows a red line under the function

 

Any idea what im doing wrong?

 

Thank you 

16 REPLIES 16
joe_hannes_col
Continued Contributor
Continued Contributor

Correct, Find will identify entries in your table that contain AUTONAME.TEXT in the EMP_NAME column, even if AUTONAME.TEXT would not contain (@SLA).

joe_hannes_col
Continued Contributor
Continued Contributor

Came up with yet another (more elegant, imho) solution 😄

LookUp(table1,AUTONAME.Text in emp_name).final_location

Sahara22
Helper V
Helper V

Thanks so much, your the best!

 

So no Zero?

 

Like this?

 

LookUp(Table1,Find(AUTONAME.Text,EMP_NAME).FINAL_LOCATION

Sahara22
Helper V
Helper V

It didnt work,

 

Have to write it like this:

 

LookUp(Table1,Find(AUTONAME.Text,EMP_NAME)>0).FINAL_LOCATION

joe_hannes_col
Continued Contributor
Continued Contributor

In the last reply, I've used the "in" operator instead of the "find" formula (because I don't know if your data source supports delegating find).

LookUp(Table1,AUTONAME.Text in EMP_NAME).FINAL_LOCATION

If you put that into your filter formula, it should work 🙂

Sahara22
Helper V
Helper V

Thanks so much for your help, Im going to get the employees to try the App an get back to you! But i have a feeling Its going to work, so excited!!! 

 

Thank you!! 

joe_hannes_col
Continued Contributor
Continued Contributor

Great to hear that, @Sahara22 🙂

If it works, could you please mark the reply as a solution so others can find it? Thanks 🙂

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,115)