cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GerryL
Level: Powered On

Column value in expression

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']))

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Column value in expression

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:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Column value in expression

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:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

 

Regards,
Alice Zhang

View solution in original post

GerryL
Level: Powered On

Re: Column value in expression

Thanks. The first suggestion worked perfectly. 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,143)