Copying data from one dataverse table to another

(0) Share

Report

Posted on by CU31120939-0

I am trying to upsert data from one table to another depending if record is already copied or not (so if record already exists then update orthervise insert). I got this from copilot and i understand it but having trouble in getting it to work

ForAll(
    Search(sourceTbl, txtFindValue.Text, 'Value To Find'),
    With(
        {
            inboundRecord: LookUp(destinationTbl, keyCol = ThisRecord.keyCol)
        },
        If(
            Not(IsBlank(inboundRecord)),
            Patch(
                'destinationTbl',
                inboundRecord,
                {
                    col1: ThisRecord.col1,
                    col2: ThisRecord.col2
                }
            ),
            Patch(
                destinationTbl,
                Defaults(destinationTbl),
                {
                    keyCol: ThisRecord.keyCol,
                    col1: ThisRecord.col1,
                    col2: ThisRecord.col2
                }
            )
        );
        Notify("Processed record: " & ThisRecord.keyCol, NotificationType.Success)
    )
)

if ill change ThisRecord.X to hardcorded strings (like "I am a value") and try to use this then it works but for some reason ThisRecord-object exists in the first lookup but it cannot be accessed inside patch-function. Then again inboundRecord-object I able able access inside path function but then I am again not able to do the insert with a new record.

Would you be able to help me?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

CU31121026-0 4 on at

Like (0)

Report
Copy link

Link copied!
Then I have also tried a shorter one where row updates work ok but not insert
ForAll( Filter(SourceTable, SearchColumn = txtSearch.Text), Patch( DestinationTable, LookUp(DestinationTable, KeyColumn = ThisRecord.KeyColumn), { FieldToUpdate1: ThisRecord.FieldToCopy1, FieldToUpdate2: ThisRecord.FieldToCopy2, }, Defaults(DestinationTable), { keyfieldToInsert: ThisRecord.KeyColumn FieldToInsert1: ThisRecord.FieldToCopy1, FieldToInsert2: ThisRecord.FieldToCopy2, } ) )

Was this reply helpful? Yes No
Suggested answer

CU31121026-0 4 on at

Like (0)

Report
Copy link

Link copied!
Ok... So I have a feeling that I might have resolved this one by my self. Seems than with the first code lookup-function didnt update inboundRecords-variable to blank but somehow held previous iteration value!!! I really dont understand this!!!

Did it now like this:
ForAll( Search(sourceTbl, txtFindValue.Text, 'Value To Find'), With( { inboundRecords: Search(destinationTbl, ThisRecord.keyCol, keyCol) outboundRecord: ThisRecord }, If( Not(IsEmpty(inboundRecords)), Patch( destinationTbl, LookUp(destinationTbl, keyCol = ThisRecord.keyCol), { col1: outboundRecord.col1, col2: outboundRecord.col2 } ), Patch( destinationTbl, Defaults(destinationTbl), { keyCol: ThisRecord.keyCol, col1: outboundRecord.col1, col2: outboundRecord.col2 } ) ); ) )

with IsEmpty I am not inspecting if records populated with Search function

Was this reply helpful? Yes No