Column value in expression

[GerryL]

Hi,

I'm building a Flow that will create calendar events from an Excel file. For the subject line I am trying to use Concat but I can't get the right syntax for it to pull in columns from the excel. This is what I have at the moment for one test, trying to combine text with a column from the table. Only the text comes through. The column name is Term. 

concat('Open Registration ',string(body('Get_rows')?['Term']))

[v-yuazh-msft · Accepted solution]

Hi @ GerryL,

Could you please share a screenshot of the configuration of your flow?

You could take a try to use expression as below:

concat('Open Registration',items('Apply_to_each')?['Term'])

Or you could use expression as below:

concat('Open Registration',item()?['Term'])

I have made a test on my side and I have created a flow as screenshot below:

The flow would run successfully as below:

Regards,
Alice Zhang

[GerryL]

Thanks. The first suggestion worked perfectly.