How to Automate O365 User Creation Process by Power Automate?⚡

Introduction

The automation of the user creation process in O365 is a game-changer, drastically reducing the time and effort required to onboard new users. By simplifying the user creation process and separating the approval and licensing steps, organizations can benefit from enhanced efficiency, reduced administrative workload, and a smoother onboarding experience for new users.

You just have to fill out the form and submit it, and within 1 second, the Manager gets an email to approve. Even via phone, he/she can approve with one click. Then, within 1 second, a user will be created in O365 with all the details. Parallelly, the System Administrator gets an email notifying about the new user creation, and then he/she just has to assign a license.

By automating the user creation process, the System Administrator only needs to log into the Microsoft 365 Admin Center or Entra Admin Center to assign a license to the newly created user instead of creating and filling in the details of the user.

Prerequisite

• Microsoft Form with relevant attributes. (First name, Last name, Display name, User UPN, Manager UPN, Requester UPN, etc.)
• Basic knowledge of Power Automate functions

Notes

• Both the Microsoft form and the Power Automate flow should be created with the same Microsoft account.
• Rename all actions to identify the flow easily. Here, I have renamed and described the actions to give a better understanding.

Step 1. Log in to Microsoft Power Automate and create a new flow (Automated flow).

Step 2. Give a flow name and choose the flow trigger as "When a new response is submitted"

Step 3. Enter Form ID (All the forms will automatically display, and select the relevant form)

Step 4. Add an action as "Get response details"

• Form ID: Select the relevant Form ID from the list.
• Response Id: Click and enter the attribute Response Id.

Step 5. Add an action as "Initialize variable" and fill as below. Rename action as Password.

Enter the value as Adm and Expression rand(10000,99999).

Step 6. Add an action as "Get user profile (V2) and select Manager UPN in Forms.

Attributes in Microsoft Form will display when we click the blank cell and select the appropriate attribute.