Tuck shop Point of Sales System - Editing the values of an item in sharepoint lists

[TJL550]

Hi, I'm currently working on a tuck shop POS system for a small shop that I help out at, and I have currently run into a problem that I can't yet solve.

What I am trying to do, when I press sale, for one to be taken off the 'stock' value for the selected item, and one to be added to the 'sale' value for the selected item.

I have linked some reference images below.

Thanks Tom

[v-yujincui-msft · Accepted solution]

Hi @TJL550 , 

Maybe you could try to use the Patch() function.

I have made a test for your reference.

1. Here is my SharePoint list.

2. Select the Button and apply the following formula on its OnSelect property as:

Patch('Tuck Shop - Stock Management',Gallery6.Selected,{Stock:Gallery6.Selected.Stock-1,Sold:Gallery6.Selected.Sold+1})

3. Select the Button and apply the following formula on its DisplayMode property as:

If(Gallery6.Selected.Stock-1<0, DisplayMode.Disabled, DisplayMode.Edit)

Result:

Best Regards,
Charlie Choi

[TJL550]

Thank you so much!

This helped a lot!