Lookup function with condition by ID but datatype is lookup

(0) Share

Report

Posted on by irfnnzmi

Hello everyone i am new in here,

So i wanna lookup row by id but the field datatype is lookup, how can i achieve that ?

LookUp([@'Transaction Approval Histories'], Regarding = "473826292",Subject);

As sample of above the "Regarding" field is lookup datatype.

Thank you for Answer.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , @irfnnzmi
The LookUp column will return record in Power Apps.
So if you want to use lookup for this field , you need to use this code :

LookUp([@'Transaction Approval Histories'], Regarding.Id = 473826292).Subject

And you can also use the :
Set(dataTest,[@'Transaction Approval Histories'])
And you can see your table return in the global varabiles:
Then we can see your [Regarding] column return and then determine which field you need lookup in this record type column.

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
irfnnzmi 6 on at

Like (0)

Report
Copy link

Link copied!

Hi! @v-yueyun-msft
Thank you for answer ,

but i still cant assign Regarding.Id or Regarding.Value. as you can see in below

after some debuging. i got the regarding column have this value.

and it produce by using this program
then how can i access Value property if using Regarding.Value doesn't work ?

Best Regards

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI , @irfnnzmi
According to description, how do you get "regarding column have this value":
Can you show me your Table "[@'Transaction Approval Histories']" in your Power Apps,like this:
And can you show me your Regarding data here :

And dose your Regarding column open the allow multiple selection in your side ?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
irfnnzmi 6 on at

Like (0)

Report
Copy link

Link copied!

HI @v-yueyun-msft

Thank you for answer,
as your request i only found this colomn "_regardingobjectid_value",

and when i check it on here its just question mark "?"

The name of "Regarding" colomn is found in this menu

and this is the configuration of regarding colomn

Best Regards

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , @irfnnzmi
I test it in my side , you can try to use this code :
LookUp([@'Transaction Approval Histories'], Regarding.Name = "xxxx" ).Subject

This is my Lookup column in Dataverse and test app:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No