Power Platform Community Forum Thread Details

Hi,

I am bulk patching some edits from a collection back to Dataverse. The collection was originally loaded from Dataverse. I cet the following Error:

CreatedBy: The Specified Column is Read Only and Cannot be Modified

I understand logically why the error has occurred, You cant modify this column. But, obviously I'm not trying to change that column in the app, just patch back my edited columns. I'm using the bulk patch method, problematic code below:

ForAll(colTPEditingItemsInDataverse,Patch(
 BulkTransportPlanItems,ThisRecord)

This error has only started appearing today, with about a month's worth of it working successfully.

Below is the full code for that button for context:

Set(
 varTPUpdatingStatus,
 "Please Be Patient: Patching Unassigned Sales Orders To Lakeview"
);
ForAll(
 colTPUnassignedBulkSalesItems,
 Patch(
 'LV1_DB.SalesOrder',
 First(
 Filter(
 'LV1_DB.SalesOrder',
 OrderNumber = SalesOrderNumber
 )
 ),
 {Flag20: 0}
 )
);
Set(
 varTPUpdatingStatus,
 "Please Be Patient: Removing Items From Dataverse"
);
Remove(
 BulkTransportPlanItems,
 colTPRemoveFromDataverse
);
Clear(colTPRemoveFromDataverse);
Set(
 varTPUpdatingStatus,
 "Please Be Patient: Patching Unassigned Sales Orders To Lakeview"
);
ForAll(
 colTPAssignedBulkSalesItems,
 Patch(
 'LV1_DB.SalesOrder',
 First(
 Filter(
 'LV1_DB.SalesOrder',
 OrderNumber = SalesOrderNumber
 )
 ),
 {Flag20: 1}
 )
);
Set(
 varTPUpdatingStatus,
 "Please Be Patient: Adding Items To Dataverse"
);
ClearCollect(
 colTPAddingItemsToDataverse,
 Filter(
 colTPAssignedBulkSalesItems,
 ID = ""
 )
);

ForAll(colTPAddingItemsToDataverse,
Patch(
 
 BulkTransportPlanItems,Defaults(BulkTransportPlanItems),ThisRecord
));
Set(
 varTPUpdatingStatus,
 "Please Be Patient: Editing Items In Dataverse"
);
ClearCollect(
 colTPEditingItemsInDataverse,
 Filter(
 colTPAssignedBulkSalesItems,
 ID <> ""
 )
);
ForAll(colTPEditingItemsInDataverse,Patch(
 BulkTransportPlanItems,ThisRecord)
);
Set(
 varTPUpdatingStatus,
 "Done!"
);

Categories:

Building Power Apps