Power Automate/Power BI Supplies Stock Inventory
Budget: $30 – $250 USD
Scenario: I want to create an inventory stock control of our supplies. Currently, the stock is dispensed/recorded in my company's secure web application, but the web application is not able to give any indication/alert that the stock needs to be re-ordered.
Desired outcome: I want to create a report in Excel (that will later be put in Power BI) that will show stock on hand, re-order level and re-order quantity (based on last 3 month sales and annual sales history), and when the stock reaches the re-order level, a notification via MS Teams message is sent.
Important points:
1. From the secure web application, you are able to retrieve supply unique code, supply name, supply size, vendor name, supply sales, stock on hand
2. The flow will have to automatically calculate sum of 3 month sales and annual sales to formulate a dynamic re-order level and re-order quantity
Desired outcome: I want to create a report in Excel (that will later be put in Power BI) that will show stock on hand, re-order level and re-order quantity (based on last 3 month sales and annual sales history), and when the stock reaches the re-order level, a notification via MS Teams message is sent.
Important points:
1. From the secure web application, you are able to retrieve supply unique code, supply name, supply size, vendor name, supply sales, stock on hand
2. The flow will have to automatically calculate sum of 3 month sales and annual sales to formulate a dynamic re-order level and re-order quantity