Hi, I'm building an stationary apps and currently have 2 sharepoint list (Stock List & Request List). I'm stuck here where when update button is clicked, onSelect formula if the delivery status is = cancelled, then do patch stock list > In-Stock will add (+) the request quantity and the value will be 10 again.
Thanks for all the help.
@fauzi - not clear on what you have in the Items property for the Delivery Status dropdown, and assuming you want to do this using a Patch function, the pattern below should give you some direction:
Share
Report
All responses (
Answers (
15,689
With(
{
_stock: LookUp(
'MBI Stationary - Stock List',
'Product ID' = "Some ID",
'In-Stock'
)
},
With(
{
_request: LookUp(
'BI Stationary - Request List',
ID = "Some ID",
Qty
)
},
If(
'Your Dropdown'.Selected.Value = "Cancelled",
Patch(
'MBI Stationary - Stock List',
LookUp(
'MBI Stationary - Stock List',
ID = "Some ID"
),
{'In-Stock': (_request + _stock)}
)
)
)
)
