Unanswered

I want to decrement a value of my Sharepoint list

(0) Share

Report

Posted on by FabianPowerAppM

Hello, I have a sharepoint list in which a Admin can add the amount of PC's in stock. On a new page, a engineer can click which PC he removed for installation. Now I want to decrement the number of PC's in my list when the engineer clicks on the Button "Removed from stock"

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

So you have a Removed from Stock column, ritght? Is it a Yes/no Column?

You should be able to count the rows where Removed from Stock is different from No.

Another solution would be to have a label with current stock and another that takes 1 from the number in current stock and then patch that column to the source to update current stock.

Note: Watch out for delegation.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @FabianPowerAppM,

Could you please tell me if you something edit grid for you to display/edit data?

Do you want to update the stock quantity once the user clicks the remove button?

I would suggest you add a Gallery or combine a Gallery with an edit form, whatever.

If you have a Gallery display all the data, I would suggest you insert the remove button and set the OnSelect as below:

Patch(List,ThisItem,{Stock:Value(ThisItem.Stock)-1})

Just give more details if the above could not solve your problem.

Was this reply helpful? Yes No
FabianPowerAppM 29 on at

Like (0)

Report

I think its the best when I explain it with pictures:
Here the technican can choose what he wants to pick from the stock. After he clicks "Next" this page appear:
Here he can see the amount and the Item. When he clicks on the button bottom right the amount should subtracted from the amount in the sharepoint list which is here:

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

This will do what you want.

For 1 record:
Patch ( YourTable, YourGallery.Selected, { Lagerbestand: YourGallery.Selected.Lagerbestand- Value(Menge.Text) })

For all records in the gallery at once:
ForAll(
YourGallery.AllItems,
Patch ( YourTable, ThisRecord, { Lagerbestand: ThisRecord.Lagerbestand- Value(Menge.Text) })
)

Was this reply helpful? Yes No
FabianPowerAppM 29 on at

Like (0)

Report

I am a really beginner in PowerApps, can you explain what you mean with Records in Gallery ? 😄

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

A gallery is a list of records... I assumed you are using a gallery for the list of Artikels, so placing the above code in Weiter should do what you need

ForAll(
YourGallery.AllItems,
Patch ( YourTable, ThisRecord, { Lagerbestand: ThisRecord.Lagerbestand- Value(Menge.Text) })
)

Was this reply helpful? Yes No
FabianPowerAppM 29 on at

Like (0)

Report

We are on a good way but somehow he dont find my "Lagerbestand" in the Patch. Look:

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

What's in Gallery5_1 Items?

Was this reply helpful? Yes No
FabianPowerAppM 29 on at

Like (0)

Report

"Auswahl" but IDK what this means. When you click inside the Combobox on a item this happens:
and after clicking add, it appears inside the gallery

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

That must be a collection

Try this:
ForAll(
YourGallery.AllItems,
Patch ( YourTable, Lookup( YourTable, Artikelnummer = ThisRecord.Artikelnummer), { Lagerbestand: ThisRecord.Lagerbestand- Value(Menge.Text) })
)

Was this reply helpful? Yes No