Power Platform Community Forum Thread Details

Hey guys,

I am trying to make an editable grid using a gallery, i am facing an issue where whenever i keep on save it doesnt override the previous records instead it adds to them in my data verse table.

so for my gallery this is the item for it:

Filter('PO Supplies Details','IR Request ID' = SelectedItem.'IR Request Id')

then I have a button where its visibility is hidden where the grid update should happen:

If(
 IsBlank(
 LookUp(
 colGridUpdates,
 'PO Supplies Detail' = ThisItem.'PO Supplies Detail'
 )
 ),
 Collect(
 colGridUpdates,
 ThisItem
 )
);
UpdateIf(
 colGridUpdates,
 'PO Supplies Detail' = ThisItem.'PO Supplies Detail',
 {
 'Expenditure Type': ExpenditureTypeInp.Text,
 'Deliverables ': DeliverablesInp.Text,
 'PO Id': NewPOID,
 'Date Promised ': DatePromisedInp.SelectedDate,
 Amount: Value(AmountInp.Text),
 'New Quantity ': Value(newQuantityInp.Text),
 'Previous Quantity ': Value(prevQuantityInp.Text),
 'New Unit Price': Value(newUnitPriceInp.Text),
 'Previous Unit Price': Value(preUnitPriceInp.Text),
 UOM: UOMInp.Selected.Value,
 WBS: WBSInp.Text
 }
);

the 'PO Supplies Detail', is the uniquely identifier from my table and then is my save functionality:

Patch(
 'PO Supplies Details',
 ShowColumns(
 colGridUpdates,
 'IR Request ID',
 'PO Id',
 'New Quantity ',
 'Date Promised ',
 'New Unit Price',
 'Expenditure Type',
 'Deliverables ',
 'Previous Quantity ',
 'Previous Unit Price',
 Amount,
 UOM
 )
);
Clear(colGridUpdates);

if anyone can help me with this i would really appreciate it and thank you.