Hi, I thought it would have been easier to the link I was using as a template in my main post.
Code below:
If(
IsBlank(LookUp(colOrderItems, ProductID = ThisItem.ID)),
Collect(
colOrderItems,
{
ProductID: ThisItem.ID,
Title: ThisItem.Title,
Quantity: 1,
PricePer: ThisItem.Price
}
),
Patch(
colOrderItems,
LookUp(colOrderItems, ProductID = ThisItem.ID),
{
ProductID: ThisItem.ID,
Title: ThisItem.Title,
Quantity: LookUp(colOrderItems, ProductID = ThisItem.ID, Quantity)+1
}
)
);
Reset(txt_Number)
