Patch Error : invocation of unknown or unsupported function

(0) Share

Report

Posted on by CYT_Dev

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

Categories:

All responses (1)

Answers (1)