Power Apps Leave Request System

A personal low-code learning build that submits leave requests, routes manager approvals with Power Automate, and tracks status in SharePoint.

Context and constraints

This was Saumya’s first Power Apps application and a personal learning project, not a client engagement. The goal was to build a useful internal-workflow pattern without traditional code while learning how Power Apps handles forms, SharePoint data, and Power Fx.

Saumya’s contribution

Saumya designed, built, tested, and deployed the application. She created the request form, connected the approval flow, configured status tracking, and debugged Power Fx and SharePoint field behavior.

Approach

The application lets an employee submit a leave request, routes it to a manager for approval, and updates the request status. Saumya broke each screen into smaller parts and used diagnostic labels to inspect hidden values while debugging form modes, visibility, scoping, and SharePoint Choice fields.

Tools and workflow

  • Microsoft Power Apps for the application screens and form
  • Power Automate for manager approval routing
  • SharePoint for request records and status
  • Power Fx for patching, filtering, and screen behavior
  • Copilot for context-aware formula assistance

Outcomes

The working application supports request submission, manager approval, dynamic SharePoint status updates, and a color-coded status dashboard.

Limitations and next steps

Leave-balance logic and adaptive role-based views were planned as the next additions.

Continue the thread

Contextual next step

Map the workflow before choosing the tool.

Share only a high-level, non-confidential outline in the first message.

Start a project conversation