Answered

How do I concatenate data from multiple SharePoint fields?

(1) Share

Report

Posted on by Spawn10

330

I have a SharePoint list that has three single line of text columns. How do I concatenate (semicolon-delimited) these three columns in a Power Automate Flow?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Power Platform 1919 2,254 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Spawn10,
In Power Automate, you concatenate SharePoint single line of text columns using an Expression, not custom code. you can also use dynamic content also.

Option 1. Using concat() expression (recommended) , this assumes, you are in a apply to each loop.

Add a Compose action (or use directly in any field that supports expressions) and use:

concat( items('Apply_to_each')?['Column1'], '; ', items('Apply_to_each')?['Column2'], '; ', items('Apply_to_each')?['Column3'] )

Replace:
Column1, Column2, Column3 with your actual internal column names
Apply_to_each with the name of your loop, if you’re inside one

Option 2. If you’re not inside an Apply to each

You can reference the SharePoint action directly:

concat( outputs('Get_item')?['body/Column1'], '; ', outputs('Get_item')?['body/Column2'], '; ', outputs('Get_item')?['body/Column3'] )

Notes / best practices
Use '; ' if you want a space after the semicolon
If any column can be empty and you want to avoid ;;, add conditions or use coalesce():

concat( coalesce(items('Apply_to_each')?['Column1'], ''), '; ', coalesce(items('Apply_to_each')?['Column2'], ''), '; ', coalesce(items('Apply_to_each')?['Column3'], '') )

Was this reply helpful? Yes No
Suggested answer

trice602 16,298 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there!

You can use a Compose action and concat() your values along with a semicolumn, shown below. As the old saying goes, works in testing.

concat(items('For_each')?['Title'],';',items('For_each')?['Priority/Value'],';',items('For_each')?['ID'])

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Suggested answer

PieterVeenstra 33 on at

Like
a
(1)

Report
Copy link

Link copied!

Do you have a single record or do you have many records? You could do this a bit cleverer than with an apply to each. In the example below the get items collects the items from a list and then the select connects the three pieces of data.

Was this reply helpful? Yes No