Forum Discussion

Rexter's avatar
Rexter
Brass Contributor
Sep 15, 2025

Concatenate columns in Sharepoint list with JSON?

I want to concatenate First and Last name columns in Sharepoint. I can easily do this in Excel and Access, but this function is not available in Sharepoint. Yes, I know about the Calculation Column, but it looks like more vaporware - more half-baked nonsense from Microsoft. It does not work. Is there a way to use JSON to achieve this?  

SharePoint Online

1 Reply

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Sep 16, 2025

    If your Firstname and Lastname columns are just simple single line of text columns you can format the Fullname single line of text column with the following JSON:

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=[$Firstname] + ' ' + [$Lastname]"
}

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Resources