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.

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 (3,124)