Answered

Inventory Management Adding Existing Quantity from Input Screen to Excel

(0) Share

Report

Posted on by Kimberly112

I am using the Barcode scanner to input supplies into the Inventory management system I built in power apps. I am using Excel tables as my data source.

I already have inventory in the excel sheet, specifically quantities of supplies. How can I input the new quantity of supplies received with the excel column already containing the existing quantity updated? (basically how to I add new quantity + existing quantity to get total quantity)?

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 154,477 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Kimberly112 ,

The figure should be something like this

LookUp( Table, BarcodeField = First(BarcodeReaderName.Barcodes).Value ).QuantityField + Value(YourNewQuantityBox.Text)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kimberly112 4 on at

Like (0)

Report
Copy link

Link copied!

That seems to work. I am new to Power apps....is there any way you could help with a Patch code for excel as well?

Was this reply helpful? Yes No
WarrenBelz 154,477 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Kimberly112 ,

What are you trying to patch ? Also note that if you have access to SharePoint lists, you should consider changing as Excel is a quite restrictive data source.

Was this reply helpful? Yes No
Kimberly112 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
I am trying to take the information (inventory management of medications) using a barcode scanner to obtain 4 different pieces of data required for the inventory and also additional information such as medication name, NDC, dose, qty of boxes/bottles, qty of pills, and a couple more pieces of information that is input into application.

The reason I am using excel is that I have multiple formulas written into excel to breakdown the information from the barcode because the output is just a string of 50-60 numbers.

I do have SharePoint lists and I could add the formulas into Lists, if that will make it easier.

Was this reply helpful? Yes No