Unanswered

Patching to a SharePoint List but Filtering to a Specific Item and Calculating Values, Inventory Management

(0) Share

Report

Posted on by Applications

I'm trying to use PowerApps to manage my inventory for product ordering, delivery, and restocking, but I'm not sure how to accomplish this in PowerApps.

I have two SharePoint lists I use, one is for pulling in the order information ("Order Information") and the other is referencing the inventory overall ("Inventory Information").

At the moment I have a form for submitting the status change for an order to the order information SP list, but I need it to also update the inventory overall list with the new amount once the item is delivered.

I need it to filter the inventory overall list to match only the item that it being updated, and then either subtract (delivery) or add (restock) to that item. Does anyone know how I can manage this?

Here are some screenshots as well:

Order information list:

Inventory overall list:

The PowerApp:

So I need the formula to filter the 2nd list based on if the text in the ordered item of the PowerApp screen matches and then update the 2nd lists quantities. Hope this helps provide clarity, thanks!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Applications on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone have any thoughts on how to achieve this? Still looking for a response. Thank you!
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Applications ,

From what I understand, you use a form in Edit FormMode with DataSource set on "Order Information" list to gather and save infos about an order.

After that, you need to use the OnSuccess() property of the form.

You can update the data using something like:

With( { item:Lookup('Inventory Information', ItemName = YourForm.LastSubmit.OrderedItem) }, Patch( 'Inventory Information', item, { Stock:item.Stock-YourForm.LastSubmit.Quantity } )

I cannot find where you keep info about the type of operation restock-delivery and also I can't see the name of your columns.