Retrieve a SharePoint List Item ID and Copy a Person Field
Question details
Use an item ID to retrieve a Person or Group value from another SharePoint list.

- 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.
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.
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.
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.
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.
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.
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.
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.

Use a SharePoint Designer workflow where supported
Use this approach for an environment that still supports SharePoint Designer workflows.
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.

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.




