Unanswered

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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
TJL550 14 on at

Like (0)

Report

Thank you so much!
This helped a lot!

Was this reply helpful? Yes No