Answered

Powerapps Inventory Add Subtract Function not working.

(0) Share

Report

Posted on by rroque

350

Here's the code I'm using. Nothing seems to work. Instead of adding and subtracting the inventory it only inserts the number in my text box. Instead if should add or subtract from the inventory. Any help is much appreciated.

Patch(
tblOptrackInventoryImportedDataCSVS,
LookUp (
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value
),
{ON_HAND: Value("ON_HAND") - Value(txtQuantity.Text)}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Sort by

rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!
You can remove .Text after txtQuantity given that you are using the Value() function. If this makes no changes try putting the subtraction equation in brackets.
{ON_HAND: (Value("ON_HAND") - Value(txtQuantity))}

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

No change it throws an error whenI take the text off.

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Forgot. Thanks

Was this reply helpful? Yes No
rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!

Were you able to solve the issue?

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

No I have not resolved. No matter what syntaxt I try nothing works.

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

My equation is in brackets

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rroque,

Value("ON_HAND") does not refer to the value in that column but rather performs the Value() function on the text value 'On_HAND'. When you want to add / subtract a value from the current state in your table, you can combine the With() and LookUp() functions for easy reference to that current column value.

With( { //Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value wLookUp: LookUp( tblOptrackInventoryImportedDataCSVS, FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value ) }, Patch( tblOptrackInventoryImportedDataCSVS, //Use function variable as record reference wLookUp, //Use function variable to reference the current ON_HAND column {ON_HAND: wLookUp.'ON_HAND' - Value(txtQuantity.Text)} ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked fine. Thank you so much brother.

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

So this inventory portal I'm developing has to add the inventory to warehouse and subtract from warehouse.
One of the warehouse is used to replenish inventory. Here's my code I'm wondering if we can combine or shorten the code a bit.
I deduct the from warehouse and add to warehouse.

With(
{
//Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value
wLookUp: LookUp(
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value
)
},
Patch(
tblOptrackInventoryImportedDataCSVS,
//Use function variable as record reference
wLookUp,
//Use function variable to reference the current ON_HAND column
{ON_HAND: wLookUp.ON_HAND - Value(txtQuantity.Text)}
)
);
With(
{
//Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value
wLookUp: LookUp(
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_To_Warehouse.Selected.Value
)
},
Patch(
tblOptrackInventoryImportedDataCSVS,
//Use function variable as record reference
wLookUp,
//Use function variable to reference the current ON_HAND column
{ON_HAND: wLookUp.ON_HAND + Value(txtQuantity.Text)}
)
)

Was this reply helpful? Yes No
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

And more importantly is there a good manual out there that I can buy or download?

Was this reply helpful? Yes No