I have several one to many relationships.
Projects --> Opportunities
Opportunities--> Quotes
Quotes --> Quote lines
Quote lines --> Departments (1:1)
I want a list of projects and departments.
How do i do this in Power Apps.
Thanks
As an attempt to merge columns I tried this..
ClearCollect(CollectionA, AddColumns('Quote Line Items',"ID",'Parent Quote'.'Quote Number'));ClearCollect(CollectionB,AddColumns(Quotes,"OPPID",'Opportunity ID'.'Opportunity ID',"ID",'Quote Number'))
ClearCollect(CollectionC,AddColumns(CollectionA,"OPPID",LookUp(CollectionB,ID = CollectionA.ID).OPPID))
but this expression:
CollectionB,ID = CollectionA.ID
gives me an 'Invalid argument type' error
1,055
