Answered

Searching and filter from two columns

(0) Share

Report

Posted on by dalacarelia_196

648

Hello out there
I want to make a nice solution , today i use dropdown with banks clearing nr series like ( 1000 - 1500 ) then it loops out Bank name , In my list i have High and Low i the serie , amount of numbers in the serie like Avanza Bank have 19 different Clearing numbers

I want to make Textfield to enter the clearing number , and Bank name will show up like in my dd solution
As long i use 1 column and Startswith it works as long i use those numbers like in avanza 9550 or 955 but how to solve numbers in between
Like Avanza 9558 will not work when i use the two columns like i do .

LookUp(SweBankkonton; StartsWith(Low; TextInput1.Text)).Title

pls anyone 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,393 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dalacarelia_196 ,

Probably something like this

LookUp( SweBankkonton; Value(TextInput1.Text) >= Low && Value(TextInput1.Text) <= High )

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
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you sir , i make my selfe to complicated , i am so glad for the time and effort you give 🙂

Was this reply helpful? Yes No