Lookup not exact value

(0) Share

Report

Posted on by DANIEL13

Hello there, so I have a excel table as data source te hat is something like this:

DIP LITRES

0 2200

1. 2190

2 2175

.....

I want to the user to type the litres: 2195 for example and the lookup or function return the closest 'Dip'. In excel I can achieve this by using XLookup formula. There is any way to do this in powerapps?

Thanks for the help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

eka24 20,923 on at

Like (0)

Report

You can use LookUp to achieve that:

LookUp (Table1,Litres=Value(Textbox1.Text),Dip)

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

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.

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (2)

Report

Hi @DANIEL13

part of the search set a min and max number something like:

Set(_Min,First(Filter(colData, Liters <= Value(TextInput2.Text))).Liters);
Set(_Max,Last(Filter(colData, Liters >= Value(TextInput2.Text))).Liters);
Set(_Eval, If((_Min+_Max)/2 > Value(TextInput2.Text),_Min,_Max))

the lookup will then be something like:

LookUp(colData,Liters=_Eval,Dip)

when 2174 is looked up, 2 is returned

If 2152 is looked up 3 is returned

hope this will work for you.

Was this reply helpful? Yes No
DANIEL13 24 on at

Like (0)

Report

Thanks Robin you are a legend. I could not work it out by myself

Was this reply helpful? Yes No
andrewfmills 5 on at

Like (0)

Report

I came across this post as I was searching for how to do a similar task. I couldn't get the suggested solution to work unless I changed the code to:
Set(_Min,First(Filter(colData, Value(Liters) <= Value(TextInput2.Text))).Liters);

It appears that Powerapps doesn't recognise my data table as being numerical. Any ideas what I'm doing wrong here? I have the format in Excel set as Number rather than General

Was this reply helpful? Yes No