cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kobra_Pistola
Level: Powered On

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			John.Smith@email.com				
Location 2			Sharon.jones@email.com;John.Smith@email.com	
Location 3			Sharon.Jones@email.com				

 

Desired Output on Sharepoint:

Location			emails						People Column
Location 1			John.Smith@email.com				John Smith
Location 2			Sharon.jones@email.com;John.Smith@email.com	Sharon Jones; John Smith
Location 3			Sharon.Jones@email.com				Sharon Jones

 

-Thanks

3 REPLIES 3
Community Support Team
Community Support Team

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

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:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,
Alice Zhang

TaurangaNZ
Level: Powered On

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

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?

TaurangaNZ
Level: Powered On

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

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

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,608)