Others

Retrieve a SharePoint List Item ID and Copy a Person Field

Natalie TaylorNatalie Taylor Nov 20, 2026 868 views

Question details

Use an item ID to retrieve a Person or Group value from another SharePoint list.

Retrieve a SharePoint List Item ID and Copy a Person Field
Product
Microsoft SharePoint Lists
Device & OS
not provided
Scenario
A destination list needs to show a person associated with an item in a source list.
Observed behavior
The user wants to match the source item by ID and populate a Person or Group column in the destination list.
Before you start

Confirm that the destination list can identify the source item by its SharePoint ID and that the source list has a Person or Group column. Check that you have permission to read the source list and update the destination list.

Solution 1Recommended

Copy the Person field using Power Automate

Use a flow to find the source item by ID and populate a Person or Group column in the destination list.

The destination list must store or receive the source item's ID, such as through a lookup column. A unique lookup value can help users select the correct source item.

1
Prepare the destination columns

In the destination list, select Add column and create a Person or Group column. Also create a Lookup column pointing to the source list if the source item ID is not already available.

2
Create a flow

Open Power Automate, select Create, and choose an automated cloud flow with the SharePoint trigger When an item is created or modified. Select the destination site and list.

3
Get the source item

Add the SharePoint Get item action and select the source site and list. In its Id field, insert the destination item's source lookup ID or other stored source item ID from dynamic content.

4
Update the destination person

Add the SharePoint Update item action for the destination list. Use the trigger's ID to identify the destination item, supply any required fields, and map the source Person field's Claims value to the destination Person field's Claims input.

5
Prevent repeat updates and test

Add a condition so Update item runs only when the source and destination person values differ. Save the flow, create or edit a destination item, and check that its Person column is populated.

Copy the Person field using Power Automate
Person field configuration: The mapping above assumes single-person columns. Multi-person fields require an array of user objects. Updating the destination item can trigger the flow again, so test the condition carefully.
Free Microsoft Office alternative

Work with exported SharePoint list data in WPS Office

WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface. Open compatible Office files to work with exported list data and move between office suites more easily; WPS does not replace or repair SharePoint workflows.

Review and organize exported SharePoint list data in WPS Spreadsheet.Open and edit compatible Microsoft Excel XLSX and Word DOCX files.Use a familiar office interface for an easier transition.Get free, lightweight tools for everyday document and spreadsheet work.
microsoft office alternative - wps office

Frequently Asked Questions

Can a SharePoint lookup column directly display a Person field?

A Person or Group field is not supported as a direct lookup display field. Instead, use the source item ID to retrieve the item and copy its Person value into a destination Person or Group column.

Where do I get the source item's ID in a flow?

If the destination list has a lookup to the source list, select the lookup ID from the trigger's dynamic content for the Get item action. If you store the ID in another column, use that column instead.

Why does my flow keep running after it updates the item?

The When an item is created or modified trigger also detects the flow's update. Add a condition before Update item so the flow updates only when the destination Person value needs to change.

Can I still use SharePoint Designer workflows in SharePoint Online?

SharePoint 2013 workflows were retired in SharePoint Online on April 2, 2026. Use Power Automate for a new online workflow; check your environment's support before using SharePoint Designer on-premises.