SparePartManagement is a PowerApps application designed to efficiently manage spare parts inventory. The application consists of four main screens: Main Screen, Stock Screen, Historical Screen, and FormScreen. It integrates with SharePoint List for data storage and provides functionalities for parts withdrawal, refill, and inventory history tracking.
- Dashboard: Displays an overview of the stock for all tools.
- Buttons:
- Part WithDraw: Function for withdrawing parts.
- Refill: Function for refilling parts.
- Historical Record: View transaction history.
- Stock Status: View stock status.
- ComboBoxSearchBox: Search tools and sort by stock status.
- Details: View quantity for each Part Number and Full Stock.
- Update Button: Update transaction history.
- Holdover: Shows the last record date.
- Buttons:
- Withdraw: Withdraw parts.
- Refill: Refill parts.
- Filters: Filter by date, shift, PartNumber, Check, Sort direction by date, part name.
- Refill and Withdraw Entry: Function for entering refill and withdraw details.
- Submit: Automatically updates the quantity for the Part Number.
- Update Historical: Allows updating history based on previous and current quantities without affecting current stock. This is a unique feature of the system.
Data is stored in SharePoint List. You can import the app from the PowerApps source with two files:
- WidgetOnly: For customizing the app.
- Final App: The final version of the app.
- SharePoint List: Import from the Import folder.
- Images: Images used in the app are stored in the Image folder.
Demo.mp4
-
Import SharePoint List:
- Open SharePoint and navigate to the Import folder.
- Follow the import steps as guided.
-
Import PowerApps:
- Download the WidgetOnly or Final App file.
- Open PowerApps and import the application.
We hope you find the SparePartManagement app useful and customizable to your needs!