You’re offline. This is a read only version of the page.
Hello everyone!
I have successfully created an app to manage inventory. With the app we are already able to view the current inventory and book the receipt and dispatch of items. The current inventory level of the items changes within the data source, a SharePoint list, as intended.
Within the SharePoint list, next to the columns of the current inventory, we also have the minimum stock necessary, maximum stock and reporting stock (once current inventory hits this level we need to reorder this good).
Ideally we would like to have the app compare the current levels of inventory with the reporting stock and filter which goods need to be reordered. If possible it would be great to then have a notification of some sort alerting that goods need to be ordered with the exact items and amount of products that need to be ordered.
Do you have any idea on how I could implement such functionality please?
I do not seem to find anything online and my little trials have been unsuccessful.
Thank you very much, your help is much appreciated!! 😊
Hi @sophie4 ,
Rough structure using your field names - note that there are Delegation limitations to this
Share
Report
All responses (
Answers (
155,415
Filter(
AddColumns(
SPList,
OrderQty,
Inventory - ReportingStock
),
OrderQty < YourToleranceNumber
)YourToleranceNumber is how close you want to get- OrderQty would be the amount based on what you have posted.
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
