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']))
Solved! Go to 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
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
Thanks. The first suggestion worked perfectly.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
88 | |
58 | |
42 | |
37 | |
36 |
User | Count |
---|---|
85 | |
72 | |
61 | |
56 | |
40 |