Unanswered

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)

rpersad 776 on at

Like (0)

Report
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 (0)

Report

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

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

Forgot. Thanks

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report

Were you able to solve the issue?

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

My equation is in brackets

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
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 (0)

Report

That worked fine. Thank you so much brother.

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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 (0)

Report

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

Was this reply helpful? Yes No