Table of Contents

    Mini Project: Employee Management App

    Rumman Ansari June 04, 2026 16 views Subject Details

    Mini Project: Employee Management App

    The Employee Management App is a practical mini project in Microsoft Power Apps where learners build a simple employee roster application. The app allows users to view employee records, search employees, add new employee records, edit existing employee details, and save changes to a connected data source.

    This mini project is suitable after learning Power Apps interface, Dataverse basics, forms, galleries, controls, functions, navigation, and Excel/SharePoint integration. It gives learners hands-on experience with a real business scenario: managing employee information in a structured app.

    Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) describes a similar roster manager app connected to a SharePoint Online list, where users browse the full employee roster, add new records, edit existing records, and save changes through a validated Power Apps form connected live to SharePoint. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Project Title

    Mini Project: Employee Management App using Power Apps and SharePoint

    This project can also be called Employee Roster App or Roster Manager App. The project is designed for beginners who want to understand how Power Apps connects to SharePoint data and provides a user-friendly interface for managing records.

    Project Overview

    In this mini project, students will create a canvas app that connects to a SharePoint list named EmployeeList or RosterList. The SharePoint list will store employee details, and the Power Apps canvas app will provide screens for browsing, viewing, adding, and editing employee records.

    Microsoft Learn explains that when a canvas app is created from a SharePoint or Microsoft List, Power Apps Studio opens an app with three screens: a Browse screen to scroll through list items, a Details screen to show information about a single item, and an Edit screen to create or update an item. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Therefore, this Employee Management App can follow the same beginner-friendly structure: Browse employees, view one employee’s details, and add or edit employee records.

    Project Objectives

    The main objective of this mini project is to help learners apply Power Apps concepts in a complete business app.

    • Create a SharePoint list to store employee records.
    • Connect a Power Apps canvas app to the SharePoint list.
    • Display employee records using a gallery.
    • View selected employee details using a display form.
    • Add new employee records using an edit form.
    • Edit existing employee records using an edit form.
    • Use buttons for navigation and actions.
    • Use formulas such as Navigate, Back, SubmitForm, ResetForm, and Patch where needed.
    • Test the app end-to-end and verify changes in SharePoint.

    Enterprise learning content for Microsoft Power Apps 2024: Building a canvas app from scratch in Power Apps 2024 describes a common canvas app as a CRUD app, meaning an app designed to create, read, update, and delete records in a data source. It also mentions a functional three-screen CRUD app, galleries linked to data sources, forms for viewing and editing records, and navigation using Navigate and Back functions. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    What Students Will Learn

    • How to design a small business app from a real-world requirement.
    • How SharePoint list columns become app fields in Power Apps.
    • How to use a gallery to show multiple employee records.
    • How to use forms to view, add, and update employee information.
    • How to use Power Fx formulas for navigation and saving data.
    • How to test whether Power Apps and SharePoint are connected correctly.
    • How to improve user experience with search, filter, and clear screen design.

    Enterprise learning content for Getting Started with Canvas Apps in Power Apps states that learners build a blank canvas app, connect it to data, design browse, detail, and input screens, then save, publish, and share the app. [4](https://learning.cloud.microsoft/detail/6aedee44-680d-4c05-b8d7-89e5eff8a25a?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Suggested Data Source

    For this mini project, use a SharePoint Online list as the data source. The list can be named EmployeeList or RosterList. Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) uses a SharePoint Online list named RosterList as the data source for a roster manager app. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    SharePoint is a good beginner-friendly data source for this project because it supports structured list columns and integrates directly with Power Apps.

    Suggested SharePoint List Structure

    The following table shows a suggested employee list structure. The column ideas are based on the roster dataset described in [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2), where fields such as Emp Name, Emp No, Enterprise ID, Gender, Career Level, Management Level, Location, NA Ops comments, and People Lead are mapped to Power Apps form controls. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Column Name Suggested Type Purpose Power Apps Control
    Emp Name Single line of text Stores employee full name Text input
    Emp No Number Stores employee number Number input
    Enterprise ID Single line of text Stores employee enterprise ID or login ID Text input
    Gender Choice Stores gender option Dropdown
    Career Level Choice Stores employee career level Dropdown
    Management Level Number Stores management level Number input
    Location Choice Stores work location Dropdown
    Status Choice Stores Active or Inactive status Dropdown
    People Lead Person or text-based field Stores people lead information Person field or text input based on design

    Project Screens

    This mini project can be designed with four screens. Microsoft Learn’s SharePoint list app pattern includes Browse, Details, and Edit screens, and this project adds a Home screen for a clearer student-friendly user journey. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Screen Name Purpose Main Controls
    HomeScreen Welcome page and starting point Labels, buttons, icons
    BrowseScreen Shows all employees in a gallery Gallery, search box, sort/filter controls
    DetailScreen Shows details of selected employee Display form, Edit button, Back button
    EditScreen Adds or edits employee record Edit form, Save button, Cancel button

    Project Architecture

    The Employee Management App uses SharePoint as the data source and Power Apps as the user interface. The user works inside the app, and the app reads or writes employee records to the SharePoint list. 

    User
 |
 v
Power Apps Canvas App
 |
 +--> Home Screen
 |
 +--> Browse Screen
 |       |
 |       v
 |    Employee Gallery
 |
 +--> Detail Screen
 |       |
 |       v
 |    Display Form
 |
 +--> Edit Screen
         |
         v
      Edit Form / SubmitForm / Patch
         |
         v
SharePoint List: EmployeeList or RosterList

    Microsoft Learn states that when users add or edit information in an app created from a SharePoint or Microsoft List, the information in SharePoint or Lists also updates. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Step 1: Create the SharePoint List

    First, create a SharePoint Online list to store employee records. Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) says that in the roster app exercise, the data source is a SharePoint Online list named RosterList. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Suggested list name: 

    EmployeeList

    Add columns such as Emp Name, Emp No, Enterprise ID, Gender, Career Level, Management Level, Location, Status, and People Lead. These fields are suggested for the mini project and are aligned with the roster-style employee dataset described in [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2). [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 2: Create a Canvas App

    Create a canvas app in Power Apps and connect it to the SharePoint list. Microsoft Learn explains that a user can create an app by signing in to Power Apps and connecting to a SharePoint list, or by creating an app directly from a list in SharePoint or Microsoft Lists. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    For this mini project, learners can choose either approach:

    • Create the app from Power Apps by connecting to the SharePoint list.
    • Create the app directly from SharePoint or Microsoft Lists using the Power Apps integration option.

    Microsoft Learn states that the generated app opens in Power Apps Studio, where makers design, build, and manage the app. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Step 3: Design the Home Screen

    The Home screen introduces the app. It should be simple and clear.

    Suggested controls:

    • App title label: Employee Management App
    • Short description label
    • Button: View Employees
    • Button: Add Employee

    Suggested formula for View Employees button: 

    Navigate(BrowseScreen)

    Enterprise learning content for Microsoft Power Apps 2024: Building a canvas app from scratch in Power Apps 2024 states that learners navigate between screens using Power Apps Navigate and Back functions. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 4: Design the Browse Screen

    The Browse screen shows all employee records in a gallery. Microsoft Learn says the Browse screen in a generated app lets users scroll through all items in the list. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Suggested controls:

    • Text input for search
    • Gallery to show employees
    • New Employee button
    • Home or Back button

    Suggested gallery fields:

    • Employee Name
    • Employee Number
    • Career Level
    • Location
    • Status

    Enterprise learning content for Microsoft Power Apps 2024: Building a canvas app from scratch in Power Apps 2024 mentions creating interactive galleries linked to a data source and creating a search box and filter for more efficient, dynamic data display. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 5: Open Employee Details from Gallery

    When the user selects an employee from the gallery, the app should navigate to the Detail screen and show the selected employee’s information.

    Suggested formula on gallery item or next arrow: 

    Navigate(DetailScreen)

    This formula is an instructional example based on the documented use of Navigate for moving between screens in canvas apps. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 6: Design the Detail Screen

    The Detail screen shows all information about the selected employee. Microsoft Learn says the Details screen in a generated SharePoint list app shows all information about a single item in the list. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Suggested controls:

    • Display form connected to EmployeeList or RosterList
    • Edit button
    • Back button

    Suggested Back button formula: 

    Back()

    Enterprise learning content explicitly mentions using Back for navigation between screens in Power Apps. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 7: Design the Edit Screen

    The Edit screen allows the user to add a new employee or update an existing employee record. Microsoft Learn says the Edit screen in a generated SharePoint list app is used to create an item or update information about an existing item. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)

    Suggested controls:

    • Edit form connected to EmployeeList or RosterList
    • Save button
    • Cancel button

    Suggested Save button formula: 

    SubmitForm(EmployeeEditForm)

    Microsoft Learn’s SharePoint forms integration content says the SharePointIntegration OnSave action submits changes to SharePointForm1 using SubmitForm, and the form’s OnSuccess formula executes when the form is successfully submitted. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)

    Step 8: Add New Employee Logic

    The New Employee button should open the Edit screen in new-record mode. Microsoft Learn’s SharePoint forms integration content says the OnNew action sets SharePointForm1 in new mode using NewForm. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)

    Suggested formula: 

    NewForm(EmployeeEditForm);
Navigate(EditScreen)

    This formula is an instructional example based on the documented use of NewForm for new mode and Navigate for screen movement. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)[3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 9: Edit Existing Employee Logic

    The Edit button on the Detail screen should open the Edit screen in edit mode. Microsoft Learn’s SharePoint forms integration content says the OnEdit action sets SharePointForm1 in edit mode using EditForm. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)

    Suggested formula: 

    EditForm(EmployeeEditForm);
Navigate(EditScreen)

    This formula is an instructional example based on the documented use of EditForm for edit mode and Navigate for screen movement. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)[3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 10: Cancel Button Logic

    The Cancel button should reset changes and return the user to the previous screen. Microsoft Learn’s SharePoint forms integration content says the OnCancel action resets changes using ResetForm. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)

    Suggested formula: 

    ResetForm(EmployeeEditForm);
Back()

    This formula is an instructional example based on the documented use of ResetForm for cancel/reset behavior and Back for returning to the previous screen. [5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)[3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Step 11: Verify Data Save in SharePoint

    After saving an employee record, students should verify that the record appears in the SharePoint list. Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) instructs learners to preview the app, add an employee, save the form, confirm the app navigates back to BrowseScreen, confirm the new employee appears in the gallery, then open RosterList in SharePoint and refresh to confirm the new row appears. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    This validation step is important because it confirms that the Power Apps app and SharePoint list are connected correctly.

    Optional: Use Patch for Direct Record Updates

    Beginners can first use SubmitForm because it is easier with forms. After that, learners can explore Patch for direct updates. Microsoft Learn explains that the Patch function modifies or creates one or more records in a data source, and that Patch can be used in complex situations, such as updates that require no user interaction or forms that span multiple screens. [6](https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch)

    Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) states that Patch writes data directly to SharePoint without using the form, and gives examples such as adding a new employee, updating career level, and marking a selected employee as inactive. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Example formula for adding an employee: 

    Patch(
    RosterList,
    Defaults(RosterList),
    {
        'Emp Name': "Riya Desai",
        'Career Level': {Value: "SE"},
        Location: {Value: "Pune"}
    }
)

    The example above is taken from the pattern shown in [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2). [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Suggested App Features

    Feature Description Learning Concept
    Employee Gallery Shows list of all employees Gallery and Items property
    Search Employee Allows users to search employee records Search/filter logic
    Employee Details Shows selected employee information Display form
    Add Employee Creates a new employee record NewForm and SubmitForm
    Edit Employee Updates existing employee data EditForm and SubmitForm
    Mark Inactive Updates employee status Patch function

    The CRUD, gallery, form, navigation, search, and filter concepts are supported by enterprise learning content for building a canvas app from scratch in Power Apps. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Suggested Form Fields

    The edit form can include the following fields:

    • Emp Name
    • Emp No
    • Enterprise ID
    • Gender
    • Career Level
    • Management Level
    • Location
    • Status
    • People Lead

    These fields are aligned with the roster-style SharePoint list column mapping described in [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2). [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    Validation Ideas

    Validation helps prevent incorrect or incomplete employee records. The source material confirms the roster app uses a validated Power Apps form connected live to SharePoint, but it does not provide all validation rules for this specific mini project. Therefore, the following validation rules are suggested for educational use:

    • Emp Name should not be blank.
    • Emp No should be numeric.
    • Enterprise ID should not be blank.
    • Career Level should be selected from available choices.
    • Location should be selected from available choices.
    • Status should be Active or Inactive.

    These validation rules are project suggestions. The cited internal roster exercise explicitly supports the idea of a validated Power Apps form, but does not specify these exact validation rules. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Testing Checklist

    Test the Employee Management App carefully before publishing or submitting the project.

    Test Case Expected Result
    Open the app Home screen loads correctly
    Click View Employees Browse screen opens
    Select an employee Detail screen shows selected employee
    Click Add Employee Edit screen opens in new mode
    Fill valid employee details and save New employee appears in gallery and SharePoint list
    Edit an existing employee and save Updated employee data appears in app and SharePoint list
    Click Cancel Form resets and user returns without saving changes

    Internal learning material [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) specifically includes an end-to-end test where learners preview the app, tap Add Employee, fill required fields, tap Save, verify the employee appears in the gallery, and refresh SharePoint to confirm the new row appears. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Expected Output

    After completing this mini project, the learner should have a working Employee Management App with:

    • A Home screen for app entry.
    • A Browse screen showing employees in a gallery.
    • A Detail screen showing selected employee details.
    • An Edit screen for adding or editing employee records.
    • A SharePoint list storing employee records.
    • Working Save and Cancel actions.
    • Basic navigation between screens.
    • Verified data updates in SharePoint.

    Microsoft Learn supports the three-screen SharePoint app pattern of Browse, Details, and Edit screens, and the internal roster exercise supports the live SharePoint-connected employee roster scenario. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)[1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Project Enhancement Ideas

    After completing the basic version, learners can improve the app with additional features. These are suggested enhancements for practice:

    • Add search by employee name or enterprise ID.
    • Add filter by location, career level, or status.
    • Add color indicator for Active and Inactive employees.
    • Add a dashboard showing total employees and active employees.
    • Add role-based screens for admin and viewer users.
    • Add Power Automate approval or notification for new employee creation.

    The search and filter enhancement is supported by enterprise learning content that mentions creating a search box and filter for more efficient dynamic data display in a canvas app. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})

    The other enhancement ideas are additional project suggestions for practice and are not directly specified in the cited sources.

    Mini Project Workflow

    1. Create SharePoint list for employee records.
    2. Add required columns and sample employee data.
    3. Create a canvas app connected to the SharePoint list.
    4. Create or customize Home, Browse, Detail, and Edit screens.
    5. Add gallery to display employee records.
    6. Add display form for employee details.
    7. Add edit form for new and existing records.
    8. Add navigation buttons using Navigate and Back.
    9. Add SubmitForm for saving form data.
    10. Test the app and verify SharePoint updates.

    This workflow combines the Microsoft Learn three-screen SharePoint app pattern, the enterprise CRUD app learning content, and the internal roster app exercise. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)[3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})[1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Project Viva / Presentation Points

    Students can explain the project using the following points:

    • The app is created using Microsoft Power Apps canvas app.
    • The data source is a SharePoint Online list.
    • The app manages employee records.
    • The Browse screen shows all employees.
    • The Detail screen shows selected employee information.
    • The Edit screen is used for adding and updating employee records.
    • SubmitForm saves form data to SharePoint.
    • Patch can be used for direct record update scenarios.
    • The app is tested by adding a new employee and verifying the record in SharePoint.

    These explanation points are based on the cited SharePoint canvas app pattern, SharePoint form integration, Patch function documentation, and internal roster exercise. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)[5](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration)[6](https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch)[1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Common Mistakes in This Mini Project

    • Not creating the SharePoint list columns correctly.
    • Connecting the app to the wrong SharePoint list.
    • Using a display form when an edit form is needed.
    • Forgetting to set the form data source.
    • Writing navigation formulas on the wrong control property.
    • Not testing whether saved data appears in SharePoint.
    • Using Patch without understanding SharePoint column types.

    The need to verify saved rows in SharePoint is directly supported by [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2), which instructs learners to refresh RosterList and confirm the new employee row appears. [1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Best Practices

    • Use meaningful screen names such as HomeScreen, BrowseScreen, DetailScreen, and EditScreen.
    • Use meaningful control names such as EmployeeGallery and EmployeeEditForm.
    • Keep the app layout simple and clear.
    • Use galleries for multiple employee records.
    • Use display forms for read-only employee details.
    • Use edit forms for new and update operations.
    • Test the app with sample records before sharing.
    • Verify SharePoint data after saving from Power Apps.

    The gallery, form, navigation, and testing practices are supported by the enterprise CRUD app learning content and internal roster exercise. [3](https://learning.cloud.microsoft/detail/6dd3bcf2-3800-4091-8f44-8fc3e1052f1f?context={%22subEntityId%22:{%22source%22:%22M365Search%22}})[1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Mini Project Summary

    The Employee Management App is a beginner-friendly Power Apps mini project that teaches how to create a practical business application using Power Apps and SharePoint. The app allows users to browse employee records, view selected employee details, add new employees, edit existing employee information, and save updates to SharePoint.

    The project uses important Power Apps concepts such as screens, galleries, forms, controls, formulas, navigation, SubmitForm, Patch, and SharePoint integration. It is a useful project because it combines multiple topics into one complete working app.

    Microsoft Learn supports the three-screen list app pattern, while [Roster_PowerApps_SharePoint_Exercise.docx](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1&EntityRepresentationId=972ffc1d-b938-4a95-95da-918f18c23fd2) supports the employee roster app scenario connected live to SharePoint. [2](https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/app-from-sharepoint)[1](https://ts.accenture.com/sites/PowerAppsTrainings/_layouts/15/Doc.aspx?sourcedoc=%7B2A877483-8762-45A0-9783-473F3C8F9E04%7D&file=Roster_PowerApps_SharePoint_Exercise.docx&action=default&mobileredirect=true&DefaultItemOpen=1)

    Conclusion

    The Mini Project: Employee Management App helps learners understand how Power Apps can be used to solve a real business problem. Instead of managing employee data manually in a raw list, users can interact with the data through a clean app interface.

    This project is especially useful because it connects Power Apps with SharePoint, one of the most common Microsoft 365 data sources. Learners practice creating screens, connecting data, displaying records in a gallery, using forms, adding navigation, saving data, and verifying results in SharePoint.

    The project also prepares students for more advanced Power Apps development. After completing this app, learners can improve it with search, filters, dashboard cards, role-based screens, Power Automate notifications, and better UX design.

    Overall, this mini project gives learners a complete hands-on experience and helps them understand how Power Apps can be used to build practical employee management solutions.

    Microsoft Power Platform Mastery