In this article, we will explore how an admin can create new users and send their credentials such as username and password which will enable them to log in to the Power Pages site.
Prerequisites
To see record of newly create user on Power Pages Site:
Configure site settings for WebAPI and table
Create relationship with record table and contact table via lookup column

Create contact relationship with Record table from Table Permissions

Steps to create flow that Auto Generate Password and Send User Credentials
Go to make.powerautomate.com then create new flow and select "Automated cloud flow"

Add this trigger of Dataverse that triggers when record is created in Contacts table

Initialize variables for username and password

Add these compose for generating characters from email, random numbers & characters

Set username variable to these - take first 2 characters from first name & random numbers

Add do until loop action for generating 8 characters long password

Add Update row action for updating password and user name to New Password Input and User name respectively.

The New Password Input column is where the plain text password generated by Power Automate is temporarily stored. However, this column's value is not visible in the Contact table itself for security reasons. It is designed solely to hold the password before it is hashed and stored in the password hash column.













Join the conversation! Your thoughts help the community grow.