Sharepoint 365: New field with concatenated data

Lars Bo Wassini 156 Reputation points
2020-12-06T11:55:40.17+00:00

I have 2 fields that I need to concatenate into a "Title" field.

Name: String
Location: Lookup

How do I create a new field like: =[Name] & ' - ' & [Location] ???

In Sharepoint 2010 I just made a workflow in Sharepoint Designer.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,520 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Elsie Lu_MSFT 9,756 Reputation points
    2020-12-09T01:48:45.787+00:00

    Hi @LarsBoWassini-6966,

    Thanks for waiting. Are you using SharePoint Online or SharePoint 2010?
    If you are using SharePoint 2010, then you can continue to use Workflow2010, however if you want to use Workflow2010 in SharePoint Online, it is currently not supported. As far as I know, SharePoint Online will no longer support Workflow2010. However, Workflow2013 is still available, so you can use Flow or Workflow2013:
    46393-8.jpg
    Flow:
    You can use compose and concat() function, please refer to this article for more information about the function:
    I created two lists, list1 is the test list, Name is single text column and Location is Lookup column:
    46402-9.jpg
    Then you can try create a flow, here is a simple demo(Manually) in my end:
    46432-10.jpg
    Details:
    46329-11.jpg
    46349-12.jpg

    Use concat() function:
    First select concat():
    46451-13.jpg
    Then select the column you want and outputs:
    46434-14.jpg

    Test Result:
    46435-15.jpg

    Workflow2013:
    46375-16.jpg

    Reference:
    https://sharepoint.stackexchange.com/questions/258023/sharepoint-designer-support-for-sharepoint-online-sites
    https://learn.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments