Unanswered

Collection: Can you add a column which is a lookup for the source table?

(0) Share

Report

Posted on by deg85

I am using a collection to create new records. In the new record I hvae a look up which she be set to the record used to create the collection in the first place. My idea was something like this:

ClearCollect(
collTemp,
AddColumns(
'SourceTable',
"lookup",<sourcetable>
)
);

ForAll(
collTemp,
Patch(
TargetTable,
Defaults('TargetTable'),
{
:

'Source Table':collTemp[@lookup]

:
}
)
);

Is there any way this might work? or maybe there is a better way to do it?

Thanks in advance

Mark

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

deg85 85 on at

Like (0)

Report

managed to implement it by using a lookup to the source table. would still be interested to know if there is a better, more efficient way:

ClearCollect(
collTemp,
AddColumns(
'SourceTable',
"Source GUID",sourcetableid
)
);

ForAll(
collTemp,
Patch(
TargetTable,
Defaults('TargetTable'),
{
:
'Source Table':LookUp(SourceTable, sourcetableid=collTemp[@'Source GUID']
:
}
)
);

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (0)

Report
Hi @deg85 ,

I am assuming you are patching a single field with the entire record from Source Table into one field 'Source Table'?

With( { wGUID: AddColumns( SourceTable, "SourceGUID", sourcetableid ) }, ForAll( wGUID As aPatch, Patch( TargetTable, Defaults(TargetTable), { 'Source Table': LookUp( SourceTable, sourcetableid=aPatch.SourceGUID ) } ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No