You’re offline. This is a read only version of the page.
122
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:
Share
ReportWith(
{
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.
My collection:
Thank you very much.
Hi @Edward00,
If the ColAddCart is the list behind the Gallery, you could use:
All responses (
Answers (
With(
{
wQty:
LookUp(CurrentProductsStock, ThisItem.Product.ID = ID && Size = Dropdown4.Selected.Value).Quantity
},
If(
Value(Self.Text) <= wQty,
Patch(
colAddCart,
ThisItem,
{
QTY: Value(Self.Text),
TotalPrice: Value(Self.Text) * ThisItem.Product.Price
}
),
Patch(
colAddCart,
ThisItem,
{
QTY: wQty,
TotalPrice: wQty * ThisItem.Product.Price,
}
);
Reset(Self);
Set(
varShowWarning,
true
);
)
)
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
