Forum Discussion
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...
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.
Rob
Los Gallardos
Microsoft Power Automate Community Super User