Showing results for 
Search instead for 
Did you mean: 
Not applicable

Update People Picker Column in SharePoint Online by email address in another column

We have a mail list that is pretty dynamic depending on coverage.  I would like to be able to upload to a list via access of several emails and locations and then have the emails update to the respective Names in the people lookup column.   Is this something that can be done?


Upload Doc:

Location			emails						
Location 1				
Location 2;	
Location 3				


Desired Output on Sharepoint:

Location			emails						People Column
Location 1				John Smith
Location 2;	Sharon Jones; John Smith
Location 3				Sharon Jones



Community Support
Community Support

Hi @ Kobra_Pistola,


Could you please share more details about the mail list that you mentioned? Is it a uploaded doc document from several emails and locations?


Do you want to insert the mail list to a sharepoint list as you provided? And the people column of the sharepoint list is a lookup type column?

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

Firstly, updating a lookup type column is not supported in microsoft flow currently.

Secondly, if the mail list that you mentioned is a doc document,and you would like to extract information inside the doc document and insert the information inthe sharepoint list, it's also not supported in microsoft flow currently.


If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:


Alice Zhang

I too would like this feature added to Microsoft Flow.  because the users are saying the multi-picker can't be updated by pasting in from the clipboard.  which is true.  we need a flow to update the multi-picker for the user, just like the original poster has requested.  This would save my users many hundreds of hours, so it is a very real requirement of microsoft flow.  Did someone request it as a feature yet?

I thought of another idea, remove the lookup columns all together, and not use it, since it can't be updated via flow.   just parse the textbox each time you need to apply some action to the list item instead.  Ugly I know, because what if you want to add another item in the middle, and what if you want to look up the display name from the lookup table before setting the value i.e. persons name plus email address, you wouldn't be able to.  I think as great as these tools are in 2018,  we always still have to make concessions when it comes to the users requirements, which never goes down well, and sometimes to the point of not using Sharepoint at all.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,708)