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:
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!
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!
