cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KathyKinn
Frequent Visitor

Lookup in canvas app

Is it possible to use the Lookup function on a text input in a canvas app or can it only be used on a datacard item? 

I'm trying to display a customer name from a lookup table based on the customer # key in my main table.  It just displays and repeats  the first field value with this code:

LookUp('[sip].[v_CustomerLookup]',customer_bk = customer_bk, customer)

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@KathyKinn 

Yes you can certainly do this in the Default property of the TextInput control.

Your formula for the LookUp is not specifying a proper criteria for finding your record though.

You have customer_bk = customer_bk - This will always be true and you will only get the very first record.  You need to specify the filter criteria for the lookup.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@KathyKinn 

Yes you can certainly do this in the Default property of the TextInput control.

Your formula for the LookUp is not specifying a proper criteria for finding your record though.

You have customer_bk = customer_bk - This will always be true and you will only get the very first record.  You need to specify the filter criteria for the lookup.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
KathyKinn
Frequent Visitor

Thanks!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,167)