Unanswered

Managing Inventory Values (Delivery/Restock) Through PowerApps

(0) Share

Report

Posted on by Applications

Good morning all!

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?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Applications on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Applications on at

Like (0)

Report

Any thoughts on how to accomplish this by chance?

Was this reply helpful? Yes No
Applications on at

Like (0)

Report

Still looking for help, thank you all!

Was this reply helpful? Yes No
Applications on at

Like (0)

Report

Hey all, still looking for support on this if anyone knows how to achieve the goal? Thanks

Was this reply helpful? Yes No