How to Select emails for people picker update in Power Automate


When working with the "Update item" action in Power Automate to update a SharePoint list, using an HTTP request may be a better solution. However, when dealing with a people picker column, the format adds complexity. To select user emails in the desired format, use the "Select" action and put the "Key" on the left side and the claims login on the right side. If Claims is not available, add the claims string before the email address. To replace the double quotes with apostrophes, use an expression with double apostrophes to represent the character. Convert the array into a string and use the expression in the HTTP request to update the people picker column. Updating SharePoint columns via HTTP requests is a key functionality in Power Automate, and while updating a people picker column may be challenging, it follows a similar process with a few additional steps for formatting.


Article 3w

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time