Subtract input value from stock quantity

(0) Share

Report

Posted on by FilipC2

Hello Community,

I have a Stock Management app in place that keeps stock of multiple assets.

SharePoint Database List:

In the app I have a form were user input data and stores this data in a collection displayed in a gallery so that if needed user will be able to submit multiple lines at one time.

OnSelect of submit button at this moment:

ForAll(vAssetHO, UpdateIf('Asset Management', Model = Dropdown1.Selected.Result, {Quantity: Quantity - Value(DataCardValue6.Text)}))

I am not receiving any errors in the formula but the stock quantity it is not getting updated (subtract input quantity).

Would appreciate any help!

Thank you in advance for your support!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @FilipC2

How about you just keep the code like this? I think it's sufficient enough.
UpdateIf('Asset Management', Model = Dropdown1.Selected.Result, {Quantity: Quantity - Value(DataCardValue6.Text)})

May I know if you are trying to update all these in your gallery in one go?
What was your goal for the ForAll function in your code?

Was this reply helpful? Yes No
FilipC2 on at

Like (0)

Report
Copy link

Link copied!
Hello @cha_cha,
Thank you for your quick reply,

This does not work either ...
I have figured another mistake that I was making. When I was submitting form to save data into collection, Form was also resetting, and my initial formula was wrong because Value(DataCardValue6.Text), was Form data card that was resetting. So my new formula that is mentioning data stored in collection isy
ForAll(vAssetHO, UpdateIf('Asset Management', Title = Label_HOAsset.Text && Model = Label_HOModel.Text, {Quantity: Quantity - Value(Label_HOQuantity.Text)}))
But this is stil not updating database Qty ...

Was this reply helpful? Yes No
FilipC2 on at

Like (0)

Report
Copy link

Link copied!

Strange is that when I highlight Value(Label_HOQuantity.Text) it is saying that it is blank, but this label has value '1' in it...
And same for the other label Value(Label_Quantity.Text)

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @FilipC2

May I know why you are using the ForAll function in your code? I want to know to try to understand how you are building up your code. Because based on your screenshots, and the codes you have shared, I see that there is no need for the ForAll to be added since already has the UpdateIf function.

Another code suggestion would be to use Patch, but I still doubt it will work since I have a limited view of what your structure is.
Patch('Asset Management', Model = Dropdown1.Selected.Result, {Quantity: Quantity - Value(DataCardValue6.Text)})

Was this reply helpful? Yes No
FilipC2 on at

Like (0)

Report
Copy link

Link copied!

I am using ForAll because I have to submit the changes (calculated stock) from a collection like ForAll collection item update stock.

Was this reply helpful? Yes No