How to patch multiple records at once

(2) Share

Report

Posted on by Aurora

364

Hi All,

I am trying to use the patch function to add files to rows of data with a file column in Dataverse. The issue is, I cannot find a way to get all the files from my collection properly uploaded to their related rows. Below is some code I am using:

ForAll(
        colPurchaseList,  
        Patch(
            'AUNA Purchase Request Line Items',
            Defaults('AUNA Purchase Request Line Items'), 
            {
                Item: ThisRecord.Item,
                'Item Description': ThisRecord.Description,
                'PR#': _newPR,
                Quantity: ThisRecord.Quantity,
                Cost: ThisRecord.UnitPrice,
                'Total Cost': ThisRecord.TotalCost,
                'Unit of Measure': ThisRecord.UnitofMeasure, 
                Currency: ThisRecord.Currency, 
                Taxable: ThisRecord.Taxable,
                Hyperlink: ThisRecord.Hyperlink,
                GUID: ThisRecord.GUID
            }
        )
    );
ForAll(
    colPurchaseList,
    ForAll(
        ThisRecord.Attachment,
        Patch(
            'AUNA Purchase Request Line Items',
            LookUp('AUNA Purchase Request Line Items', GUID = ThisRecord.GUID), 
            {
                'PR Document': {
                    FileName: ThisRecord.FileName,
                    Value: ThisRecord.FileContent
                }
            }
        )
    )
);
 
The issue is it only inserts files into the first row created but not all of them. Despite trying to link the GUID value between records, all my files end up in the first row.
 
Does anyone know what I am doing incorrectly here? any feedback is greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

KeithAtherton 3,707 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
Hey. I've encountered a similar issue before and, for me, it helped to alias the records within the nested ForAll() function calls so I'm explicit in which records I'm calling.

I don't know if this code will work but I've tried to illustrate where aliasing can be used - you will likely need trial-and-error to get this code to work:

ForAll( colPurchaseList As PurchaseList, ForAll( PurchaseList.Attachment As Attachment, Patch( 'AUNA Purchase Request Line Items', LookUp('AUNA Purchase Request Line Items', GUID = Attachment.GUID), { 'PR Document': { FileName: Attachment.FileName, Value: Attachment.FileContent } } ) ) );

Was this reply helpful? Yes No
Suggested answer

BriannaReddick 30 on at

Like (0)

Report
Copy link

Link copied!

Oh I've had this happen as well - I agree that finding another way to alias is probably a good solution.

Another thing you could try would be something like this to nest the behavior of adding the attachments right after each record is created instead of as a next set of for all looping.

ForAll(
colPurchaseList,
With(
{CurrentItem: ThisRecord},
Set(PatchedRecord,
Patch(
'AUNA Purchase Request Line Items',
Defaults('AUNA Purchase Request Line Items'),
{
Item: CurrentItem.Item,
'Item Description': CurrentItem.Description,
'PR#': _newPR,
Quantity: CurrentItem.Quantity,
Cost: CurrentItem.UnitPrice,
'Total Cost': CurrentItem.TotalCost,
'Unit of Measure': CurrentItem.UnitofMeasure,
Currency: CurrentItem.Currency,
Taxable: CurrentItem.Taxable,
Hyperlink: CurrentItem.Hyperlink,
GUID: CurrentItem.GUID
}
)
);
ForAll(
CurrentItem.Attachment,
Patch(
'AUNA Purchase Request Line Items',
PatchedRecord,
{
'PR Document': {
FileName: ThisRecord.FileName,
Value: ThisRecord.FileContent
}
}
)
)
)
);

Was this reply helpful? Yes No