How to get lookup field value on Power App load form ?

(0) Share

Report

Posted on by SKY05

Hi All,

OnStart property of App, I am getting the Item ID using below code.

If(
!IsBlank(Param("ItemId")),
Set(
varGetItem,
First(
Filter(
'CustomerList',
ID = Value(Param("ItemId"))
)
)
)
)

Using this variable "varGetItem", This is nothing but item ID. I want to get the value of other columns.

varGetItem.ColumnName (SingleLine) - This is working fine.

But one of the field is lookup filed. From the lookup field I am not able to get the value.

ex:- varGetItem.LookupFieldColumn (Lookup Column)

Can you please help me into this.

Thanks

Categories:

Building Power Apps

I have the same question (1)

All responses (6)

Answers (0)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @SKY05

You can use the "Value" function to extract the ID of the lookup field, and then use the "Lookup" function to retrieve the corresponding record from the lookup table.

Try this formula,

Lookup('LookupTable', ID = Value(varGetItem.LookupFieldColumn), 'LookupField')

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
SKY05 20 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thanks a lot for your reply.
Here my main List is called "RequestDetail" and Lookup field is called "CustomerName" which is lookup from 'Customer' list and Get Information From 'Customer' column.
And Lookup list is called "Customer" and Lookupfield is also same name "Customer".
Written code -
LookUp(Customer, ID = Value(varGetItem.CustomerName),Customer)
but getting error -

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this

Lookup(Customer, ID = varGetItem.CustomerName.ID, Customer)

Was this reply helpful? Yes No
SKY05 20 on at

Like (0)

Report
Copy link

Link copied!
Thanks again for your reply but there is no ID property of CustomerName lookup field.
varGetItem.CustomerName.ID

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Can you try this,

Lookup(Customer, ID = varGetItem.CustomerName, Customer)

Was this reply helpful? Yes No
SKY05 20 on at

Like (0)

Report
Copy link

Link copied!

Thanks,
I have tried that as well but there is an error called "Incompitable type of comparision". I am also searching on google to get solution. Thank you so much for your effort.

Was this reply helpful? Yes No