How to Update SharePoint Person Field in Power Automate?

In this Power Automate tutorial, I will show you how to update SharePoint person field in Power Automate. In this tutorial, I will show you how to update a SharePoint list person or group field with a single value and a SharePoint list person column with multiple values based on the choice column using a Power Automate flow.

When I was working on a SharePoint Online list, we recently wanted to update the people picker column value based on the provided choice column value using a Power Automate flow.

This is the SharePoint list named “Mentors” having different columns with datatypes like the below:

Column Name	Datatype
Employee Name	Single line of text – By default Title column
Technology	Choice column
Mentor	Person or Group column

Here, in this SharePoint list “Technology” field is a choice column with different choice values like SharePoint, Salesforce, and Power Automate. Now, based on the choice field values, we are required to update the Person field value.

This is the complete flow structure that I have made in Power Automate.

Let’s create an Automated cloud flow that will trigger automatically when an item is created.

Update a SharePoint person field with a single value using Power Automate

In this section, I will show you how to update a SharePoint person column with a single value based on a choice field using a Power Automate flow.

1. Click on App Launcher -> Select Power Automate. On the Homepage, click on +Create and select “Automated cloud flow”.

In the next window, set the flow name, choose “When an item is created or modified,” and click on Create. Provide Site address and List Name.

2. Next, add the “Condition” control flow action and provide the values as given in the table below.

Choose value	Operator	Choose value
Select value from dynamic content	is equal to	SharePoint

• Add an “Update item” under the If yes condition and provide details like Site address, List Name, and ID. Add the below value :
  • Mentor Claims: Give the email ID or select from the drop-down.

3. Then, click on “If no” to add another condition control. Provide the values as given in the table below.

Choose value	Operator	Choose value
Choose value from dynamic content	is equal to	Salesforce

4. Next, under the “If yes” condition, add the ‘Update item’ flow action and give the below details.

• Site address: Select a specific SharePoint site from the drop-down.
• List Name: Choose a specific SharePoint list
• Id: Take the id from the dynamic content.
• Mentor Claims: Add the email address of a person or choose from the drop-down.

5. Similarly, add another “Condition” control under “If no” and give the values provided in the table.

Choose value	Operator	Choose value
Take choice field value from the dynamic content	is equal to	Power Automate

6. Under the “If yes” condition, add an ‘Update item’ flow action in it. Here are the details below.

• Site address: Select a SharePoint site from the drop-down.
• List Name: Select a list name from the drop-down.
• Id: Take the id from the dynamic content.
• Mentor Claims: Select from the drop-down or else provide the email address.

7. Now, the flow is ready. Click on Save. Test it Manually.

8. Whenever the flow triggers and runs successfully, it updates the person column (Mentor) with the given values.

This is how to work with Power Automate flow to update a SharePoint list person field value.

Update a SharePoint person field with multiple values in Power Automate

Similarly, I will explain how to update a SharePoint online list person field based on a choice column with multiple values using a Power Automate flow.

As mentioned above, I will use another SharePoint list named “Branch -Mentor” with different datatypes here.

Column Name	Datatype
Section Name	A single line of text – By default it is a Title column
Branch	Choice column
Mentors	Person or group column

To fill the multiple values in a person column of the SharePoint list, Toggle the “Allow multiple selections” option in the Edit column of a person field.

Here, based on the choice field value, we wanted to update the person or group [Mentors] column with multiple values using a Power Automate flow.

Follow the same steps that are mentioned above to create a Power Automate flow:

1. To create an “Automated cloud flow” in a Power Automate, navigate to https://make.powerautomate.com/. Then click on +Create -> Select “Automated cloud flow”.

In the next window, provide a flow name, select “When an item is created or modified”, and click on Create. Provide Site address and List Name.

2. Then, add the “Condition” control flow action and set the values as given in the table below.

Choose value	Operator	Choose value
Select from the dynamic content	is equal to	Agriculture (Choice value)

3. Next, click on If yes and add the ”Update item” flow action. In the update item, provide the Site address, List Name, ID, and Person column as provided below.

• Mentor Claims: Give the email address of a user. Set multiple users by clicking on +Add new item.

4. Then, under the “If no” add another condition control and set the values.

Choose value	Operator	Choose Value
Select from the dynamic content	is equal to	B.Tech (Choice value)

5. Under the “If yes” condition, add an ‘Update item’ flow action in it. Here are the details below.

• Site address: Select a SharePoint site from the drop-down.
• List Name: Select a list name from the drop-down.
• Id: Take the id from the dynamic content.
• Mentor Claims: Add the email ID from dynamic content or select from the drop-down. Set multiple users.

6. Now, click on “If no” to add condition control under it. And provide the condition as displayed below.

Choose value	Operator	Choose value
Take from the dynamic content	is equal to	Forensic Science [Choice value]

7. Select “If yes” and add the “Update item” flow action under it. Here are the details.

• Site address: Set a specific site address from the drop-down.
• List Name: Choose the list name from the drop-down.
• Id: Select id from the dynamic content.
• Mentor Claims: Provide the email address of a user, that will retrieve user details. Add multiple users by selecting +Add new item.

8. The next step is to save and run the flow. For that, click on Save. Test it Manually.

9. When the flow is triggered, it runs successfully and updates the SharePoint list people picker column with multiple values.

This is how to update a person field in a SharePoint list with multiple users based on the choice column in a Power Automate flow.

Conclusion

I have shown you how to update a people picker column with single and multiple values in a SharePoint list by a Power Automate flow. This flow will trigger automatically when an item is created or modified in a SharePoint list.

Moreover, I hope this tutorial helped you to get a clear view of updating a SharePoint person column by Power Automate.

You may also like:

• Display SharePoint Person Column in Power Apps Dropdown
• Bind SharePoint Lookup Column in Power Apps Dropdown
• Display Column Names in Power Apps Dropdown
• Power Automate send an email (v2)