Unanswered

lookup header label.text

(0) Share

Report

Posted on by TD3

Good Morning All,

I'm trying to do what should be , in my head, a simple look up.. value below shows the hard coded version. where it returns the value in column

LookUp( BMW_RACI_Register, ProjNum = UniID, 'ColumnA' )

what I would like is

ColumnA

to read a value that sits in a text box. e.g.

LookUp( BMW_RACI_Register, ProjNum = UniID, Label1.Text )

however the outcome of this doesn't return the column header that = Label 1. Text.. it shows the value that is in the text box rather than the value in the field of the share point list were the column name = Label 1. Text.

hope this make sense and any help with this would be good.

tom

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PVosEska 329 on at

Like (0)

Report
Hi @TD3 ,

So you want to do a LookUp() of where ProjNum is equal to Label1.Text, and return the ColumnA?

Why not use:
LookUp( BMW_RACI_Register, ProjNum = Label1.Text, 'ColumnA' )
Or if ProjNum is a value and not a string:

LookUp( BMW_RACI_Register, ProjNum = Value(Label1.Text), 'ColumnA' )

In your 3rd code, you basically say you want to return the value of Label1.Text, but this should be part of the LookUp() and not the result.

I hope i understood correctly, if not, feel free to ask !

Was this reply helpful? Yes No
TD3 6 on at

Like (0)

Report

Hi,

Thanks for the reply.

sorry I wasn't very clear.. I don't want to hard code the column name. the column name would be in a label text.. effectively the column name would be a variable of sorts.

Tom

Was this reply helpful? Yes No
PVosEska 329 on at

Like (0)

Report

Okay, i have to dissapoint you then... It is currently not possible to have Dynamic column names ( column names that would change depending on other values)

Even using the Onchange preperty of the textbox to create a variable that is used as the return of the lookup, just produces the variable value, and not the sharepoint column value

Was this reply helpful? Yes No
TD3 6 on at

Like (0)

Report

Thanks, no worries.

I have restructured my lists so they work better with one each other, allowing me to hard code the title

thank you for the clarification.

Was this reply helpful? Yes No
Verified answer

PVosEska 329 on at

Like (0)

Report

Great! Please mark my answer as the solution, so it can be closed.

Regards and good luck,

Was this reply helpful? Yes No