Looking to master Power Apps and streamline your data management? At KnowHow Academy, we specialize in helping you build practical skills. In this guide, you’ll learn how to create a functional Power Apps application that performs CRUD (Create, Read, Update, Delete) operations using Forms and Galleries. With these skills, you can simplify your business processes and enhance productivity.

Why This Guide Matters

Power Apps empowers you to build no-code/low-code applications that manage data seamlessly. By following this tutorial, you’ll be able to:

• Create a professional-grade app.
• Connect to Dataverse (or other data sources).
• Design intuitive screens for employee management.
• Implement CRUD functionality in just a few steps.

What You’ll Build

We’ll create a simple Employee Management App that allows you to:

1. Search employees by name using a search bar.
2. View employee data in a gallery.
3. Edit or add employee details using a form.
4. Delete employee records with a single click.

By the end of this guide, you’ll have a fully functional app ready for deployment.

Step 1: Set Up the App Screens

1.1 Create Two Screens

1. Open Power Apps Studio and create a blank app.
2. Add two screens:
   • Screen 1: For displaying the employee list.
   • Screen 2: For showing detailed employee information.

1.2 Add Context Labels

1. Insert a Text Label at the top of both screens.
2. Customize the text (e.g., “Employee Management”) and adjust the font, color, and alignment to match your branding.

Step 2: Display Employee Data in a Gallery

2.1 Add a Gallery Control

1. On Screen 1, insert a Vertical Gallery control.
2. Set the gallery’s Items property to your data source (e.g., a Dataverse table named EmployeeData).
   • Navigate to Add Data and connect your data source.

2.2 Customize the Gallery Layout

1. Choose a layout that includes Title, Subtitle, and Body.
2. Bind the fields in the gallery to relevant columns (e.g., FirstName, Email, and Department).

2.3 Add Custom Styling

1. Insert an HTML Text Control inside the gallery for enhanced design.
2. Use the Style property to apply CSS for a polished look.

Step 3: Add a Search Box

3.1 Insert a Text Input Control

1. Add a Text Input box above the Gallery on Screen 1.
2. Name it txtSearchData and remove any placeholder text.

3.2 Filter the Gallery Based on Search Input

1. Update the Items property of the gallery to enable search functionality:Search(EmployeeData, txtSearchData.Text, "FirstName")
   • Replace EmployeeData with your table name.
   • Replace "FirstName" with the column you want to search.
2. Test the search by typing a name into the input box—the gallery should filter dynamically.

Step 4: Add Navigation Between Screens

4.1 Make the Gallery Rows Clickable

1. Insert a Button or Icon inside each gallery item.
2. Set the button’s OnSelect property to:Navigate(Screen2, ScreenTransition.None, {selectedEmployee: ThisItem})
   • This passes the selected employee’s data to the second screen.

4.2 Display Employee Details on Screen 2

1. Add an Edit Form control to Screen 2.
2. Set the form’s Data Source to EmployeeData and its Item property to:selectedEmployee
3. Add the fields you want to display or edit (e.g., First Name, Last Name, Department).

Step 5: Enable CRUD Operations

5.1 Add Buttons for Create, Edit, and Save

1. Insert icons or buttons for the following actions:

New Record

• OnSelect property:NewForm(EditForm1)

Edit Record

• OnSelect property:EditForm(EditForm1)

Save Changes

• OnSelect property:SubmitForm(EditForm1)
  • Add ResetForm(EditForm1) after submission to clear the form.

5.2 Delete a Record

1. Add a Trash Icon inside the Gallery on Screen 1.
2. Set its OnSelect property to:Remove(EmployeeData, ThisItem)
3. Test to ensure records are removed from both the gallery and the data source.

Step 6: Test and Finalize

1. Search: Ensure the search box filters the gallery correctly.
2. Navigation: Test navigating between screens and displaying the correct employee details.
3. CRUD Actions: Verify that adding, editing, saving, and deleting records work as expected.
4. Polish the Design: Adjust colors, fonts, and layout to align with your organization’s branding.

Take Your Skills Further with KnowHow Academy

This step-by-step guide is just the beginning. At KnowHow Academy, we provide comprehensive training to help you master Power Apps and other Microsoft tools. Whether you’re building internal apps or developing solutions for clients, our tutorials and workshops will take your skills to the next level.

Ready to transform your business with Power Apps? Explore our courses and resources at KnowHow Academy today!