none
SP Online infopath form and user profile

    Question

  • Hi,

    I am working on form where i have to select multiple user using people picker. like user1;user2;user3

    on form submission i have to route workflow to user enter in people picker. for example workflow first move to user1 than move to user 2 and than user3.

    Please guide me how can i enter/allow enter multiple users.  how to split users so that assigned task to each user.

    how to get each user manager and email address.

    Thanks in advance.


    iffi

    Monday, January 30, 2017 6:12 AM

All replies

  • Hi imughal,

    >> Extract values from the multiple-value enabled people picker column.

    We can extract values from the multiple-value enabled people picker column in SharePoint Designer Workflow.

    Here are the steps:

    1. Set Variable: Users to Current Item:Users

    2. Use "Find string in string (output to Variable:index)" action to find “;” in the multiple-value people picker column. The index will return -1 if doesn't find the searched for string.

    Note: Use semicolon to delimit the value.

    3. If the index in not less than 0, Set Variable: loop to Yes and insert a loop with condition.

    Copy from Variable:Users, starting at 0 for Variable: index characters (Output to Variable: substring)

    then Replace [%Variable: substring%], with   in Variable: Users (Output to Variable: Users )

    then Find ; in Variable: Users (Output to Variable: index )

    If Variable: index is less than 0,  Set Variable: loop to No

    For more detail about the steps, please read the following article:

    https://social.technet.microsoft.com/Forums/en-US/a8a890b5-f5fb-447f-b96f-9f3abdb7e178/forum-faq-sharepoint-2013-extracting-values-from-a-multivalue-enabled-lookup-column-and-merge?forum=sharepointgeneral

    >> Get user manager.

    SharePoint 2010 Workflow includes an action called Lookup Manager of a User. This action was not included in SharePoint 2013 Workflow.  We can call to the REST endpoint for the User Profile Service in SharePoint 2013 Workflow using "Call Http Web Service" action to achieve it.

    A demo about how to retrieve user profile information in SharePoint 2013 Workflow:

    https://collab365.community/retrieving-user-profile-properties-in-a-sharepoint-2013-workflow/

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Tuesday, January 31, 2017 3:29 AM
  • Hi imughal,

    I am checking to see how things are going there on this issue.

    Have you achieved that requirement using the Workflow?

    If you think the post is helpful, you can mark that as answer to help other community members find the helpful information quickly.

    You can also share your own solution here and mark it as answer, and we can learn from each other.

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, February 8, 2017 1:22 AM