Power Platform Community Forum Thread Details

I have one gallery with quantity column like this:

I want that when I change the value in the input box, it will not exceed the amount available in the stock.

The desired result is a value of 6

My formula:

With(
 {
 wQty:
 LookUp(CurrentProductsStock,Product.Id=varAddCart.ID&& ThisItem.Size = Dropdown4.Selected.Value).Quantity
 },
If(
 Value(Self.Text) <= wQty,
 Patch(
 colAddCart,
 LookUp(
 colAddCart,
 ThisRecord.CurrentProductsStock.Product.Id = varAddCart.ID && ThisRecord.Size = Dropdown4.Selected.Value
 ),
 {
 CurrentProductsStock: LookUp(CurrentProductsStock,Product.Id = varAddCart.ID && ThisItem.Size=Dropdown4.Selected.Value),
 QTY: Value(Self.Text),
 Size: Dropdown4.Selected.Value,
 TotalPrice: Value(Self.Text) * LookUp(
 Product,
 ID = varAddCart.ID
 ).Price
 }
 ),
 Patch(
 colAddCart,
 LookUp(
 colAddCart,
 ThisRecord.CurrentProductsStock.Product.Id= varAddCart.ID && ThisRecord.Size = Dropdown4.Selected.Value
 ),
 {
 CurrentProductsStock: LookUp(CurrentProductsStock,Product.Id=varAddCart.ID&& ThisItem.Size = Dropdown4.Selected.Value),
 QTY: ThisItem.CurrentProductsStock.Quantity,
 TotalPrice: ThisItem.CurrentProductsStock.Quantity * varAddCart.Price,
 Size: Dropdown4.Selected.Value
 }
 );
 Reset(Self);
 Set(
 varShowWarning,
 true
 );
 
))

Because the quantity available in stock is 6.