Unanswered

Concat SharePoint Columns and Update Another Column With Output from Concat

(0) Share

Report

Posted on by krispag

I have a Sharepoint List with multiple lookup columns. It is understood that lookup columns are not accessible in calculated columns. So, I would like to build a flow that:

When an item is created or modified
Get list items (Column A, Column B, and Column C)
1. Column C is a Date/Time Column, but I would only like to include the MMDDYYYY in the output below
Concat three values with a space between each and update Column D with the output

Thank you so much!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @krispag
After your trigger action:
1. Add a Compose action

and add the following formula expression:
concat( NAME_OF_COLUMN_A, ' ', NAME_OF_COLUMN_B, ' ', formatDateTime(YOUR_DATE_COLUMN,'MMddyyyy') )

2. Add an Update item action. The ID can be pulled from the trigger action.
Click on the field that needs the concatenated string and select the Compose from the Dynamic content list

Was this reply helpful? Yes No
krispag 22 on at

Like (0)

Report

I am getting an invalid expression error. I tried single and double quotes and got the same. I tried brackets around field with spaces in name, same error. I got the rest of the flow set up. Keep in mind, Driver and Rider columns are both single line text lookup columns.

concat( Driver, ' ', Rider, ' ', formatDateTime(In Service Date/Time,'MMddyyyy') )

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @krispag

For Lookup columns add Value after the column name.
Here's a full example including how you reference a column from the trigger:
concat( triggerOutputs()?['body/Driver/Value'], ' ', triggerOutputs()?['body/Rider/Value'], ' ', formatDateTime(triggerOutputs()?['body/DATEFIELD'],'MMddyyyy') )

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Hi @krispag ,

Based no your reply, I will recommend to use this -

concat('[Driver]', ' ', '[Rider]', ' ', formatDateTime([In Service Date/Time],'MMddyyyy'))

The column names with spaces should be enclosed in single quotes.

Please mark as solution if it helps.

Thanks,

Sandeep

Was this reply helpful? Yes No