Answered

Append String Variable with Concat and If Statement.

(0) Share

Report

Posted on by cfuka

I am having an issue with appending a string variable. I can get the expression to work with just the concat or just the if statement but not both combined. The if statement needs to be inside the concat.

This is the If statement that works:

if(empty(items('Apply_to_each')?['End_x0020_Year']),concat(items('Apply_to_each')?['Start_x0020_Year'],'/',items('Apply_to_each')?['End_x0020_Month/Value']),concat(items('Apply_to_each')?['Start_x0020_Year'],'/',items('Apply_to_each')?['End_x0020_Year']))

This is the concat that works:

concat('<!DOCTYPE html>
<html>
<head>
<style>
table {
 font-family: arial;
 Font-Size: 12pt;
 border-collapse: collapse;
 width: 100%;
}
</style>
</head>
<body>
<table width="99%">
<tr>
<td width="33%" style="border:none !important"><b>****IF STATEMENT NEEDS TO GO HERE****</b></td>
<td width="33%" style="border:none !important"><b>',items('Apply_to_each')?['Employer'],'</b></td>
<td width="33%" style="border:none !important"><b>',items('Apply_to_each')?['Job_x0020_Title'],'</b></td>
</tr>
<tr>
<td colspan="3" width="99%" style="border:none !important">',items('Apply_to_each')?['Description'],'</td>
</tr>
</table>
</body>
</html>')

Here is the Apply to each in the workflow.

Screenshot 2023-10-26 150756.png

Any help would be great. Thanks.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cfuka

You mention it doesn't work, but do not give details on what exactly doesnt work. Can you detail out what doesnt work so we can help you fix that 🙂

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
cfuka 14 on at

Like (0)

Report

@FLMike The issue is when I place the if statement inside the concat statement. The output comes out like this.

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

@cfuka

Perfect. Ok the reason is, because you are adding the If statement as text not as an actual expression.
that is why it's happening.

can you please paste your entire concat when you have the if also. since it see's it as text instead of an expression within an expression thats what the issue is.

Here is mine (my compose)
you can see it sees it as an expression

Here is my total and then the output

So we just need to make sure how you are typing it in to make sure it sees it as an expression in an expression versus text

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

cfuka 14 on at

Like (0)

Report
@FLMike Thanks for the help. This got me thinking of what i was doing differently. What I was trying to do was something along these lines.
concat(' if( empty(), concat(''), concat('') ) ')
What I needed to do was this instead.
if( empty(), concat(''), concat('') )
Now it is working perfectly. Thanks for the help again.

Was this reply helpful? Yes No
Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Sorry confusing threads, so gad you got it working..

Was this reply helpful? Yes No