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, ...
SharePoint Online
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