Employee Onboarding Automation

Executive Summary

This project demonstrates an automated employee onboarding solution built with Microsoft Power Automate, Microsoft Entra ID, Excel, and Microsoft 365. The workflow reduces repetitive administrative work by reading new-hire information from an HR spreadsheet, generating standardized identity values, creating the user account, updating the onboarding record, and sending a personalized welcome email.

My Role

I independently designed, built, tested, troubleshot, and documented the workflow. I created the Excel data structure, developed the Power Automate logic, generated display names and user principal names, created temporary passwords, provisioned users in Microsoft Entra ID, updated onboarding status, and configured the welcome email process.

Business Challenge

Manual onboarding can require multiple repetitive steps across HR and IT. Each new hire may require account creation, username generation, temporary password creation, status tracking, and communication of access details. Manual processing increases the risk of inconsistent naming, missing information, delays, and data-entry errors.

Solution

The solution uses an Excel table as the onboarding intake source and Power Automate as the orchestration layer. The workflow:

• Reads employee information from an Excel table.
• Builds the employee display name.
• Generates the first initial, last name, base alias, and final user principal name.
• Creates a temporary password.
• Creates the user in Microsoft Entra ID.
• Updates the Excel onboarding record.
• Sends a personalized welcome email.

Environment

Workflow Implementation

1. Trigger, Excel Intake, and Variable Initialization

The workflow begins with a manual trigger, reads new-hire records from an Excel table, and initializes the variables required for the user principal name, display name, and temporary password.

2. Employee Processing and Username Logic

An Apply to each loop processes every Excel record. The workflow builds the display name and generates the first initial, last name, and base alias used for the account naming convention.

3. Account Creation, Tracking, and Welcome Email

The workflow creates the Microsoft Entra ID account using the generated values, updates the corresponding Excel row, and sends the welcome email.

4. HR Excel Integration

The Excel table provides a structured intake method for new-hire information and a record of onboarding status.

Business Impact

Challenges and Solutions

Dynamic User Principal Name Generation

Challenge: Building a consistent account name from employee data while keeping the logic reusable.

Solution: Separated the first initial, last name, base alias, and final UPN into dedicated Compose and variable actions.

Temporary Password Handling

Challenge: Creating a temporary credential that could be used during account creation and communicated through the onboarding process.

Solution: Generated and stored the temporary password in a workflow variable, then reused it in the account-creation and notification steps.

HR and IT Process Alignment

Challenge: Keeping HR intake information and IT provisioning status aligned.

Solution: Used the Excel table as both the intake source and the status-tracking record, allowing the workflow to update the same row after processing.

Project Outcome

Successfully created a reusable Microsoft 365 onboarding workflow that connects HR intake data with Microsoft Entra ID provisioning, account naming, temporary password generation, status tracking, and welcome-email delivery.

Skills Demonstrated