You’re offline. This is a read only version of the page.
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
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
