Lookup result refer to other label

(0) Share

Report

Posted on by Flashback

145

Hello,

i would like to ask, if have a my problem any solution.

I have Label1 where name of SQL column is made from Concatenate text and Dropdown.

I have this lookup function in other Label2

LookUp(CachedBallances, ComboBox3.Selected.helpEtalon = CodeBalance, here i need refer to Label1 with column name)

If i use LookUp(CachedBallances, ComboBox3.Selected.helpEtalon = CodeBalance, Label1.Text) in Label2 i have name of the column but i need his value.

Exist any way?

Thank you very much

Jakub

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Flashback

You cannot refer to objects, columns, filed names, controls, etc. by reference in PowerApps.

You can vote on this Idea in the idea forum.

What you can do is devise a formula to swith off of the value in your label, such as this:

LookUp(CachedBallances, CodeBalance = ComboBox3.Selected.helpEtalon && Switch(Label1.Text, "columnA", columnA = something, "columnB", columnB = something ) )

Replace strings with your label values and column names and criteria with yours and this will give you what you want as a workaround.

I hope this is helpful for you.
Flashback 145 on at

Like
a
(0)

Report
Copy link

Link copied!

Im new in powerapps and im not sure if understand...

I try this:

LookUp(CachedBallances,CodeBalance = ComboBox3.Selected.helpEtalon &&
Switch(Label1.Text, "TargetValueEtalon4", TargetValueEtalon4,"TargetValueEtalon5", TargetValueEtalon4))

But i still receive error "Expected Text value"

"TargetValueEtalon4" is name of column in SQL (decimal place type) and TargetValueEtalon4 - here i need value from this column (for example 1.000)

What i have wrong?

Thank you
BR
Jakub
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Flashback

Welcome to PowerApps!!

So the issue you have is not with the LookUp formula, it is that you seem to be putting this in a Label text property.

If that is the case, LookUp returns a Record. Text expects a text value.

So, you need to change your LookUp to choose the column you actually want to display in your label:

LookUp(CachedBallances, CodeBalance = ComboBox3.Selected.helpEtalon && Switch(Label1.Text, "TargetValueEtalon4", TargetValueEtalon4, "TargetValueEtalon5", TargetValueEtalon4 ), theColumnYouWantHere )

Replace theColumnYouWantHere with the name of the column you want to display.