web

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

News and Announcements icon

Power Platform CommunityForums Power Apps AddColumns -Nested LookUp

Power Apps

Unanswered

AddColumns -Nested LookUp

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am working with a modeldriven app which has 3 entities:

Table1	Table2	Table3
Name: Textfield	Project: Textfield	Product: Textfield
ProjectOwner: Textfield	ProductName: Lookup to Table3	Title: Textfield
ProjectName: Lookup to Table2

In my dropdown, I want to see the Title (table3) linked to a certain ProjectOwner (table1).

I added the following syntax to the items property of my dd, but it didn't work:

AddColumns(
 Filter(
 Table1;
 ProjectOwner = "Person x"
 ); 
 "NewColumn"; 
 LookUp(Table2; Project = ProjectName).ProductName.Title
)

I assume there is a problem with "Project = ProjectName" since ProjectName is also a lookup?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Adrian_Celis 1,652 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

Try to add an alias. In the example below, I will name my filter as ProjectOwners.

AddColumns( Filter( Table1; ProjectOwner = "Person x" ) As ProjectOwners; "NewColumn"; LookUp(Table2; Project = ProjectOwners.ProjectName).ProductName.Title )

Was this reply helpful? Yes No

Join the conversation