cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Lookup different column

Hi All, 

 

I searched the community but could not find the question to what is probably a real easy question.  

 

We work with parts which have a name and unique 10 digit ID. Parts have relations to multiple other entities. 

In a form it would be great if we could lookup the parts based on the ID not the part name which is the default. 


How can I change that? 

 

Even better would be if you could lookup based on both but that might not be possible? 

 

Thanks in advance! 

 

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Lookup different column

Use the following formula on default of a textbox:
LookUp(YourTable,ID=Textbox1.Text,Name)

 

or

LookUp(YourTable,ID=Value(Textbox1.Text),Name)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Lookup different column

Hi @eka24 ,

 

Thankyou but I'm not quite sure how to do that. Where can I enter formula's? 

I'm now looking for it in the form view as you can see in the appendix, is that correct?

 

 

Thanks!!!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,971)