Power App: InventorySync
An efficient approach to a niche need for inventory management and reporting that combines Power Apps, Power Automate, and D365 FSCM's backend - Dataverse.
Jeff Stiles
5/28/20251 min read
InventorySync is an app I created to explore Power App and Power Automate functionality using the same backend as D365 FSCM (Dataverse). Read on below to learn more!
Use Case
Features
Performance
Bio-life industry manufacturers require greater granularity and management of their inventory. Often times the inventory is temperature sensitive, time sensitive, and heavily regulated. To help meet these needs, I created an app that easily displays inventory records sorted according to "days to expiration", "days in location", and "Stock level".
Additionally, each filter includes a severity marker in the form of green yellow, and red coloring to prioritize worker attention.
InventorySync offers D365 OOB type inventory adjustments, but also mixes in quality control options, image creation, automatic PDF creation, report archiving, and automated managerial approval of any changes. With these features, InventorySync can be tailored to niche inventory management requirements while meeting regulations.
D365 FSCM OOB Adjustments.
Niche tracking: Days to expiration, days in location, and Stock level.
Color-graded priority system.
At-a-glance on-hand inventory searching.
Quality inspection reporting.
Image creation to support quality inspection.
Automatic adjustment/inspection PDF report generation.
Automatic archiving of report.
Automatic managerial approval of adjustments.
Local caching of data when possible to avoid data source calls.
Patching (updating data source) with power automate instead of power app to avoid using local resources.
Delegable code to offload resource requirements for searching and filtering.
Contact Jeff Stiles for Inquiries
Reach out to discuss projects, skills, or collaboration opportunities.
