Lookup based on Text-input

(0) Share

Report

Posted on by Jbrito09

Hi everyone,

I'm working with an excel file (Roster) and I want to auto-populate the TextLabel(Name) from the if the employee ID is typed in the Text Input(EmpID-Box).

can you please tell me what is wrong with my code?

Below you have the code and screenshots:

LookUp(Roster,'Emp ID'='EmpID-Box').'First Name'

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

BlessedCobba 459 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
the code should look something more like

LookUp(Roster,'Emp ID'='EmpID-Box','First Name')

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Jbrito09

LookUp(Roster,'Emp ID'=Value('EmpID-Box'.Text),'First Name')

Was this reply helpful? Yes No
Jbrito09 8 on at

Like (0)

Report
Copy link

Link copied!

@BlessedCobba thanks so much but it doesn't work.

Was this reply helpful? Yes No
Jbrito09 8 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp thanks so much, it doesn't work. still not getting the first name populated.
see below the errors that power apps is advising:

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Jbrito09

It seems to be saying that 'Emp ID' is text and not a number. In that case:

LookUp(Roster,'Emp ID'='EmpID-Box'.Text ,'First Name') // makes them both text

Or try LookUp(Roster,Value('Emp ID') =Value('EmpID-Box'.Text),'First Name') //makes them both numbers

Was this reply helpful? Yes No
Jbrito09 8 on at

Like (0)

Report
Copy link

Link copied!

Converting both as numbers works!
thank you so much.

Was this reply helpful? Yes No