Add line break within an "if" expression

(0) Share

Report

Posted on by Morghan

209

Hello,

I've exhausted my researching skills. Is it possible to add a line break within an "if" expression in SharePoint flow (I'm using expressions in an email body)? I have a list of 5 IF statements, however, if more than one is TRUE, it prints what I want, but all jumbled next to each other. And If I add " " in the email body in between each expression and the first expression is true, then the next is false, and the third is true, it's a double page break that I don't want. First screenshot is what I DO NOT want, the second screenshot is the desired result:

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Morghan,

You mentioned that you have “a list of 5 IF statements”, so I have made the following test which will return items with line breaks.

When an item is created in SharePoint list, send an email. In the email body, input the following if functions and make sure enable Yes for the Is HTML field.

if(equals(triggerBody()?['OData__x0077_ib1'],'test1'),'test1 ','') if(equals(triggerBody()?['nyrl'],'test2'),'test2 ','') if(equals(triggerBody()?['OData__x0066_mb4'],'test3'),'test3 ','')

Then I triggered the flow and all the items will be displayed likes below:

Hope this could be a reference. If you need more help, please share more details on your flow.

Best regards,

Mabel

Was this reply helpful? Yes No
Morghan 209 on at

Like
a
(0)

Report
Copy link

Link copied!

Aw, man! I was so close. Yes, the " " did the trick. Thank you very much @v-yamao-msft!

Was this reply helpful? Yes No
DJSky 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Great solution Mabel! I have an extension of the original question - I would like to add a line break as well, but your solution only seems to work if the whole "value if true" portion is custom text. My "value if true" portion of the formula refers to another field. How do I add the to the end of that?

Current formula: if(equals(items('Apply_to_each')?['Category']?['Value'], 'Create new GID'),items('Apply_to_each')?['Title'],'')

Where I want to add : Current formula: if(equals(items('Apply_to_each')?['Category']?['Value'], 'Create new GID'),items('Apply_to_each')?['Title'] ,'')

I tried this and it didn't work: if(equals(items('Apply_to_each')?['Category']?['Value'], 'Create new GID'),items('Apply_to_each')?['Title']' ','')

Best,

Dennis

Was this reply helpful? Yes No
EmilyC 3 on at

Like
a
(0)

Report
Copy link

Link copied!

I realize a lot of time has passed, but I ran into the same issue and used concat(field,' ') instead of just the field value.

Was this reply helpful? Yes No