Evaluating bids

Development of Power App for Miscellaneous Inventory Management

Published on the November 12, 2024 in IT & Programming

About this project

Open

Objective: To create a Microsoft Power App for managing miscellaneous inventory in an AV integration company. The users will be technicians picking up items for various projects, each project assigned a unique QR code. Inventory items will have barcodes.

Specific Requirements:

User Management:

Authentication with individual login for each user or integration with Microsoft accounts.
Ability to track usage and each user’s history within the app.
Inventory Functionality:

Mobile device scanning for barcodes and QR codes to register item check-outs and returns.
Linking of checked-out items to specific project QR codes for efficient project-based tracking.
Excel Template Integration:

Real-time connection with an Excel template that logs inventory changes.
Automated alerts in Excel for low-inventory notifications.
Additional Features:

User-friendly dashboard to view inventory status and active projects.
Flexibility for future customization, such as adding reports and additional integrations.
Technical Requirements:

Mobile-compatible for on-site use.
Real-time integration with Microsoft Excel and Microsoft AD.

Project overview

The general context of this project is to develop a mobile-compatible Power App to streamline and centralize the management of miscellaneous inventory items in an integration company. In this company, technicians frequently access and use various small items (miscellaneous) for multiple projects. Each project is assigned a unique QR code, and each inventory item is identified by a barcode, which technicians scan when checking items in or out. The goal is to facilitate efficient inventory control, track inventory usage per project, and reduce the likelihood of stock shortages. The app needs to offer individual login access for users or integrate with Microsoft Active Directory (AD) for secure authentication. Additionally, it should connect in real time to an Excel template that monitors stock levels and issues alerts when inventory is low, ensuring proactive management. By centralizing inventory tracking, the app will help the company prevent inventory discrepancies, keep the necessary materials readily available for technicians, and ultimately improve operational efficiency across projects.

Category IT & Programming
Subcategory Other
Project size Small
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed

Delivery term: November 20, 2024

Skills needed

Inventory Management Microsoft PowerApps

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!