The challenge
What was getting in the way
Manual tracking created duplicate entries and forecast errors. A silent delegation issue also prevented warning logic from behaving reliably for managers.
Enterprise Technology
Employee Hours & Forecast Management
Microsoft — EAG Team
A canvas app that hardened employee-hours and availability management against duplicate records and silent logic failures.
Power AppsSQL ServerCanvas AppDelegation
The solution
What was built
The app introduced duplicate-entry detection, delegation-safe local collections, and clear overwrite handling across presales and delivery availability types.
- Canvas app for structured hours and availability input
- Duplicate-entry detection before write
- Delegation-safe local collection patterns
- Overwrite logic for presales and delivery records
- SQL-backed data handling
ProtectedAgainst duplicate entries
StableDelegation warning logic
ExplicitOverwrite behavior
System flow
How the pieces connect
A simplified architecture view. Production details vary by environment, identity model, data policy, and operating constraints.
Enter
Manager inputHours and availability→
Validate
Power AppsDuplicate checks→
Resolve
Local collectionsDelegation-safe logic→
Write
SQL ServerControlled update→
Use
Forecast viewsManager decisionsRelated work
More systems in the same problem family
Start with one workflow
Bring me the process that is slow, manual, or difficult to scale.
In 20 minutes, we can map the bottleneck, identify what is worth automating, and decide whether a proof of value makes sense. No pitch deck required.
Book a complimentary workflow audit →
Can’t find a suitable time on the calendar? Message me on WhatsApp and I’ll do my best to arrange a time that works.
In Riyadh during LEAP 2026 · Remote worldwide · On-site by arrangement