web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get value of lookup co...

Power Apps

Answered

Get value of lookup column from another list

(0) Share

Report

Report

Posted on by Ardian

39

Everyone, hoping someone can point me in the reigh direction here.

i have 3 lists, Department, Inspection, and actions.

Inspection has a column called department which is a lookup column from departments, and action has a lookup column called related inspection.

I'm trying to get departments on actions with the following code:

AddColumns(

Action,

DebtColumn,

LookUp(

Inspections,

RelatedInspection.Id = Inspections[@ID],

Department

)

)

however the values returned on DebtColumn are empty, where am i going wrong?

Thanks in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Ardian - close but slight revisions below:

AddColumns( Action, DebtColumn, LookUp( Inspections, ID = Value(RelatedInspection.Id), Department.Value ) )
Ardian 39 on at

Like
a
(1)

Report
Copy link

Link copied!
@Amik your a lifesaver, it worked creating a collection as below, but not ideal. Will change it back to your code now.

ClearCollect( mySolution3, AddColumns( Action, _Department, LookUp( _Inspections, RelatedInspection.Value = _Inspections[@Title] ).Department.Value ) );

thank you for your help.

Join the conversation