Answered

Inventory Management Adding Existing Quantity from Input Screen to Excel

Like (0) Share

Report

Posted on 14 Mar 2024 21:50:28 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:

Using Apps Using Formulas

All responses (4)

Answers (1)

Kimberly112 4 on 21 Mar 2024 at 12:09:03

Like (0)

Report

Re: Inventory Management Adding Existing Quantity from Input Screen to Excel

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.
WarrenBelz 148,894 Most Valuable Professional on 20 Mar 2024 at 21:01:32

Like (0)

Report

Re: Inventory Management Adding Existing Quantity from Input Screen to Excel

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.
Kimberly112 4 on 20 Mar 2024 at 13:58:48

Like (0)

Report

Re: Inventory Management Adding Existing Quantity from Input Screen to Excel

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?
Verified answer

WarrenBelz 148,894 Most Valuable Professional on 15 Mar 2024 at 00:08:46

Like (0)

Report
Re: Inventory Management Adding Existing Quantity from Input Screen to Excel

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