Power Platform Community Forum Thread Details

Hi everyone, good afternoon.

I am trying to patch new records to a table in the Dataverse using a collection. When I add to the collection using this code, the checkbox code works fine.

Collect(
colBulkGameAddMultipleStores,
{
CurrentStoreName: ThisItem.NewStyleLocation,
GameAssetStatus:ComboboxCanvas4.Selected.Value,
ICRCount:ComboboxCanvas3.Selected.'ICR Count',
GameCabinetManufacturerVendor:ComboboxCanvas3.Selected.'Game Vendor',
TitleGame: ComboboxCanvas3.Selected.GameName
}
)

When I try and patch to the table using the code below, it states an error that gamecabinetmanufacturervendor is a record and its looking for text. gamecabinetmanufacturervendor is a Lookup column to the Master Asset List.

ForAll(
colBulkGameAddMultipleStores,
Patch(
AmusementAssets,
Defaults(AmusementAssets),
{
CurrentStoreName: ThisRecord.CurrentStoreName,
TitleGame: ThisRecord.TitleGame,
ICRCount:ThisRecord.ICRCount,
GameCabinetManufacturerVendor:ThisRecord.GameCabinetManufacturerVendor,
GameAssetStatus: ThisRecord.GameAssetStatus
}
)
)

Thanks everyone!!

Chris

Categories:

Building Power Apps