Sharepoint 365: New field with concatenated data

Question

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.

Answer 1

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:

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:

Then you can try create a flow, here is a simple demo(Manually) in my end:

Details:

Use concat() function:
First select concat():

Then select the column you want and outputs:

Test Result:

Workflow2013:

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.