Do you want to auto populate SharePoint list columns based on the value in one column using Power Automate? In this tutorial, we will see how to auto populate SharePoint list columns based on value in one column using Power Automate.

For example, I have a SharePoint list called Employee Directory, which contains the following columns:

First name
Last name
Joining Date
Department
Organization Email

Auto-populate Sharepoint list columns based on the value in one column using Power Automate

When a new employee is added to the list, we will automatically generate an email address by using First name and Last name. For example, first name =Grady and Last name = Jenifer, then the email ID will be Grady.jenifer@domain.com

Let’s say another employee joins the organization with the same name, in that case, the email id will be generated as Grady.jenifer1@domain.com.

Let’s see how we can auto-populate the email ID based on the first name and last name column using Power Automate.

Table of Contents:

Auto Populate SharePoint list columns based on the value in one column using Power Automate

Here we will see how we can auto-populate SharePoint list columns based on the value in one column using Power Automate.

Follow the below steps to auto-populate SharePoint list columns based on the value in one column using Power Automate.

1. Open Power Automate Cloud, click on “+Create”, and select Automated Cloud flow.

Auto-populate Sharepoint list columns based on the value in one column Power Automate

Then provide the flow name, and select the When an item is created action. Then click on Create.

auto populate column based on another column sharepoint list Power Automate

Now, you can When an item is created action is added to the flow. Provide the below information:

Site address: Provide the SharePoint site address.
List name: Provide the list name.

auto populate column based on another column sharepoint list in Power Automate

2. Next, we will create the first part of the email. for this, click on +New step -> select Compose action. Then provide the below information:

Inputs: Provide like below

@{triggerOutputs()?['body/Title']}.@{triggerOutputs()?['body/Lastname']}

How to auto populate column based on another column sharepoint list in Power Automate

3. Now we initialize a variable, where we will store their email address, for this click on the +New step -> select Initialize variable action. Then provide the below information:

Name: Provide the variable name
Type: Select the type as string
Value: Provide the value like below:

@{outputs('Compose')}@tsinfo.com

How to auto populate column based on another column sharepoint list using Power Automate

4. We will get the items from the SharePoint list, whose email address contains the firstname.lastname, of the current employee.

For this, click on +New step -> select ‘Get items action. Then provide the below information:

Site address: Provide the SharePoint site address
List name: Provide the list name
Filter query: Provide the query like below: