{"id":110878,"date":"2017-08-02T11:00:10","date_gmt":"2017-08-02T18:00:10","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/setting-sharepoint-s-person-choice-and-lookup-fields\/"},"modified":"2017-08-02T11:00:10","modified_gmt":"2017-08-02T18:00:10","slug":"setting-sharepoint-s-person-choice-and-lookup-fields","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/setting-sharepoint-s-person-choice-and-lookup-fields\/","title":{"rendered":"Setting SharePoint\u2019s Person, Choice, and Lookup fields"},"content":{"rendered":"

Flow has always provided the ability to reference various field types from SharePoint ranging from Text and Boolean (Yes\/No) to Person and Choice. However, SharePoint actions in Flow didn\u2019t allow you to set or write<\/u> to complex fields like Person, Choice, Lookup, and Managed Metadata. That changes today! It gives us great pleasure to announce write support for Person, Choice, and Lookup fields<\/strong>, one of the most highly requested features on the Flow Ideas Forum<\/u><\/a>.<\/p>\n

Let\u2019s look at a quick example to learn more. Imagine that you have a SharePoint list to track Travel requests. This list has the following fields. Notice how it\u2019s a mix of Text, Date and Time, Choice, Person, and Lookup.\u00a0<\/p>\n

\"\"<\/p>\n

\"\"<\/h1>\n

Let\u2019s now create an approval flow for incoming travel requests using this template<\/u><\/a> and point it to the Travel Requests list.<\/p>\n

\"\"<\/p>\n

In the Yes branch, let\u2019s add a new action, SharePoint – Update item, and point it to the same site and list as the trigger. Notice how the Update item action now includes all editable fields from the list. The same applies to the Create item action also.<\/p>\n

\"\"<\/p>\n

Furthermore, the list of possible values for the Choice (Approval Status) and Lookup (Team) fields are the same as those presented in SharePoint. For the Person field (Backup Engineer), you\u2019ll have to type in a valid email address.<\/p>\n

\"\"<\/p>\n

We hope you can make use of these new additions as you build out new flows and enhance existing ones.<\/p>\n

Known issues<\/h1>\n

There are two known issues with this release that we will be addressing in the coming weeks.<\/p>\n

    \n
  1. \n

    Once you have created your flow, if you add a new Person, Choice, or Lookup field to your list, attempting to edit and save your Flow will result in an error at runtime. To work around this issue, you must delete and recreate the Update item or Create item action in your flow.<\/p>\n<\/li>\n<\/ol>\n

    Note \u2013 This applies only<\/em> if you edit your Flow, otherwise the flow will continue to run.<\/p>\n

    2. To write to a Person field, you must enter a valid email address for an individual in your organization.<\/p>\n

    Coming soon<\/h1>\n

    We continue to invest in our SharePoint + Flow story and want to ensure that Flow is a worthy successor to SharePoint Designer workflow. Some of the upcoming features on our connector roadmap include:<\/p>\n