Hi,
I am trying to patch back a new available qty, when an item from a collection is removed.
The collection is a shopping basket created from a sharepoint list called 'Staff Shop List'
The basket is visible to the user and they can delete items from it
I then want to return the qty back to 'available' stock.
The two Material fields are the same format
I am using this formula
Patch('Staff Shop List',Lookup( 'Staff Shop List', Material = MaterialBought), { Available: Available + ThisItem.Qty })
I get the error
"invocation of unknown or unsupported function"
Am i missing something from the formula, or is it the wrong way to udpate the available back?
Thanks
Solved! Go to Solution.
Hey! Patch Function is wrong 😕
ForAll(
Filter(
'Staff Shop List';
Material = MaterialBought
);
Patch(
'Staff Shop List';
Defaults('Staff Shop List');
{
Available: Available + ThisItem.Qty
}
)
);;
Hey! Patch Function is wrong 😕
ForAll(
Filter(
'Staff Shop List';
Material = MaterialBought
);
Patch(
'Staff Shop List';
Defaults('Staff Shop List');
{
Available: Available + ThisItem.Qty
}
)
);;
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |