Forum Discussion
Domi333
Aug 17, 2022Copper Contributor
Converting string type to person group field type in Sharepoint
Hello everyone, I have task to build a flow which will be adding and updating Items in sharepoint list from excel file. I have a issue due to converting string type from Excel (name) to a person fie...
navyjax2
Jan 17, 2024Copper Contributor
Domi333 During your "Apply to each" object that iterates through the body of your Excel items, use the "Search for users (V2)" Office 365 action. The Search term will be the field with the person's name in the items in your loop.
My example below was for a document library I was iterating and updating from a text "FullName" column to a person field I created. If you are using a list, use Update list items. You should have an ID column in your Excel that matches the IDs on your list so you can key off of it. Use the ID from your Excel as the key for the "ID" field in SharePoint.