web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Using Lookup

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • developerAJ Profile Picture
    4,763 on at
    LookUp(Table_ALL_EMPS, DataCardValue1.Text = 'EMP ID' ,'First Name')

     

  • CC-19121430-0 Profile Picture
    240 on at

    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

  • CC-19121430-0 Profile Picture
    240 on at

    Hello,

    Any help is much appreciated!

    Thanks

    Chris

  • Prabhakar_S Profile Picture
    735 Moderator on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 361

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 339 Super User 2025 Season 2

Last 30 days Overall leaderboard