cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanhuxley24
Frequent Visitor

LookUp (These types can't be compared: Text, Numbers)

I'm trying to LookUp the value of what's entered in the text box. I wanted it to display the value from the excel database I have in the Label I created so that when they enter an EID, they would know it's correct because it shows the name.

 

However, my code doesn't work. See the image below.

LookUp.png

1 ACCEPTED SOLUTION

Accepted Solutions
adgkred
Resolver III
Resolver III

 Hi @vanhuxley24,

You can use The Text() function to convert your number to a string of text. Once both types are set to text, your comparison should work. Should look like Text('Empd ID/New Kronos').

View solution in original post

2 REPLIES 2
adgkred
Resolver III
Resolver III

 Hi @vanhuxley24,

You can use The Text() function to convert your number to a string of text. Once both types are set to text, your comparison should work. Should look like Text('Empd ID/New Kronos').

Thank you! 

I got it by doing this "LookUp(Database, Text('Emp ID/New Kronos') = Text(EIDEntry)).'Employee Name'"

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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,736)