How to build an automated solution with Power Automate
About this guide
Scenario
Bellows College is an educational organization with multiple campuses and programs. Many of Bellow Colleges instructors and administrators need to attend events, and purchase items. Historically tracking these expenses has been a challenge.
Campus administration would like to modernize their expense reporting system by providing employees with a digital way to report expenses.
Throughout this series, you will build applications and perform automation to enable the Bellows College employees to manage expenses.
In this guide, you will create a Power Automate flow to email a copy of the expense report when they create a new Expense Report.
High-Level Lab Steps
The following has been identified as a requirement you must implement to complete the project:
- Employees need to receive an email when an Expense Report is submitted.
Tasks and Job Skills
Exercise 1: Create Expense Report Notification flow
Objective: In this exercise, you will see how to create a Power Automate flow that implements the requirement.
Task 1: Create a flow
Task 2: Create a step to get the Expense Report row
Task 3: Create a step to send an email to confirm submission of an expense report
Task 4: Validate and test the flow
Career Connections
The guides in this series provide foundational Power Platform knowledge, empowering roles such as Business Analyst, Citizen Developer, and Entry-Level Consultant to enhance their job performance by leveraging the platform's capabilities.
As of 2025, average U.S. salaries range from $44,000 to $80,000 for entry-level Business Analysts and $52,000 to $101,000 with five years of experience, while Citizen Developers earn around $129,348 annually. Entry-Level Consultants make approximately $65,224, with experienced consultants at top firms earning significantly higher, starting at $112,000 for undergraduates and $192,000 for MBAs. Please note that these figures are approximate, derived from online sources, and can vary based on factors such as location, industry, qualifications, and company size.
