I created a gallery table where the On Change formula in all the fields selects a button (not visible) and will create/update a collection of that row. All rows will patch to my Sharepoint list when I hit save. The formula is below however It points specifically to my List Price saying that "column in the data source you're updating expects a Record type and you are using a Text type". This field in the table is not from a lookup column but rather has a formula in Powerapps that gets pricing from another list and inputs that pricing. How would I change this so it will work?
IsBlank(
LookUp(
colWaste,
ID = ThisItem.ID
);
Collect(
colWaste,
ThisItem
)
);
UpdateIf(
colWaste,
ID = ThisItem.ID,
{
'Product Code': TxtProdCode.Value,
'Quantity/YR': TxtQtyYr.Value,
'Category ID (Name)': DrpCatName.Selected,
Discount: TxtDiscount.Value,
'Requested Price': TxtReqPrice.Value,
'List Price': TxtListPrice.Value,
'Yearly Disc$': TxtYrlyDisc.Value,
'Yearly List$': TxtYrlyList.Value
}
)
I tried other formulas from other posts, but none of them seem to work. Any help would be greatly appreciated. Thanks!
