web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using Lookup

Power Apps

Unanswered

Using Lookup

(0) Share

Report

Report

Posted on by CC-19121430-0

240

Hello Everyone 🙂

I have a form that i would want to part populate for the user based on an identifier that they would enter 'EMP ID'. so things like name etc.

This doesn't seem to be working:

LookUp(Table_ALL_EMPS, DataCardValue1.Text = "EMP ID" ,'First Name')

It also once an EMP ID is entered on the form return the below error:

Error when trying to retrieve data from the network: syntax error at position 6 in 'EMP ID eq.

As always any help is very much appreciated!

Many thanks

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!
LookUp(Table_ALL_EMPS, DataCardValue1.Text = 'EMP ID' ,'First Name')

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Thanks for the suggestion, when i amend the formula to ' ' from "" i now receive the below error.

Error when trying to retrieve data from the network: syntax error at position 12 in ''' eq EMP ID'. inner exception: syntax error at position 12 in ''' eq EMP ID'.

Cheers
Chris

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Any help is much appreciated!
Thanks
Chris

Was this reply helpful? Yes No
Prabhakar_S 735 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Appy1 ,

Try this formula,

LookUp(Table_ALL_EMPS, 'EMP ID' = DataCardValue1.Text,'First Name')

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No

Join the conversation