Need help with formula

(0) Share

Report

Posted on by LH-23071616-0

I am trying to write a formula that pulls data from a table as a result. Below is the equation:

IfError(LookUp(DataTable1,'BMI Range_Column2'='BMI output','Price Per Area_Column2')),"$0")

Error states:

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
It looks like you're comparing 2 control names, likely in the lookup.
If you want to compare the values from these controls, you'll have to reference them more specifically.
For example, if it's text boxes, add .Text to the end of the control names, like so:
IfError(LookUp(DataTable1,'BMI Range_Column2'.Text='BMI output'.Text,'Price Per Area_Column2')),"$0")
If it's dropdowns, use .Selected, datepickers are .SelectedDate, ect.

Hope this helps!

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like (0)

Report
Copy link

Link copied!

@madlad I am now getting this error

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

what exactly are 'BMI Range_Column3' and 'BI output'? This will tell us more specifically what to put

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like (0)

Report
Copy link

Link copied!

BMI column range 3
BMI output

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

Interesting - what part of the code is the error highlighted?

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
Oh I see now. If DataTable1 is the gallery, try using DataTable1.AllItems.
Something like this:
IfError( LookUp( DataTable1.AllItems, 'BMI Range_Column2'.Text='BMI output'.Text, 'Price Per Area_Column2' ), "$0" )

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like (0)

Report
Copy link

Link copied!

Oddly enough, the AllItems is not a recognized function. I scrolled through all the options and I don't even see "items" as an option.

I also tried to choose price per area_1 as pictured below, and still couldn't fix it.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yet again, that's my bad 😥, I didn't connect the dots that it was a data table, and not a gallery or other datasource. It looks like you're correct, I don't think you can reference values within a datatable like this.
However, if all you need is the value, you could replace "DataTable1" with the datasource for the table, and replace the column names with the values that make that column.
It might take a bit of playing with, but it should be able to work.

Was this reply helpful? Yes No
Verified answer

LH-23071616-0 87 on at

Like (1)

Report
Copy link

Link copied!

thanks! I ended up using the below formula and it worked for me

LookUp('Price Per Area_1',ThisRecord.'BMI Range'='BMI output'.Text,ThisRecord.'Price Per Area')

Was this reply helpful? Yes No