Converting string type to person group field type in Sharepoint

New Contributor

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 field type in sharepoint list. Is it possible to do that? I didn’t find any solution that would help. 
I would be greatful for any hints and solutions ☺️

1 Reply

@Domi333 if the data in Excel is an email address then in your flow add an Office 365 Users get user profile V2 action and select the email address from the dynamic content box for the input field. But if it's just a name then you have more of a problem as the name might not be unique. You could try to add the name field into the input of the Get user profile action but it will fail if, when you run it, it finds 2 people with the same name.


Los Gallardos
Microsoft Power Automate Community Super User