Lookup based on Text Input value

(0) Share

Report

Posted on by ragavanrajan

7,044 Most Valuable Professional

Hello Folks,

I have a scenario where I have two Text Inputs. In the first Text Input box, users will type their asset number and the second Text Input has to show a different field value based on the asset number typed.

Here is the formula I am trying to attempt

LookUp(Table1,TextInput2.Text,Description)

But I am getting the following error

I have tried `Filter and Search` function as well. but no luck.

Any help is appreciated. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @ragavanrajan ,

You are missing the field name you are trying to match

LookUp( Table1, YourFieldName=TextInput2.Text ).Description

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @WarrenBelz Thanks for your reply. I think nearly there. Still getting below warning. How do we solve this please.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @ragavanrajan ,

You will need

LookUp( Table1, YourFieldName=Value(TextInput2.Text) ).Description

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
usav367 8 on at

Like (0)

Report

Thanks for the solution @WarrenBelz.
I am trying to do something exactly similar here. however, the second text input field with lookup formula is not executing after I fill in the first text input. I have the lookup function looking into excel online (confirmed connected). Also, i don't have any errors showing up either. It's just that the lookup query is not executing.
Any help would be appreciated.
Thank you!

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@usav367

That is the most basic of lookups - you need to look at your data. Also please post a new thread with more detail including your code as this is an old closed post.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No