Returning text and value in an expression

(0) Share

Report

Posted on by Simmo86

I have the following formula as an expression but trying to put a bullet point before the field is not working:

if(equals(triggerBody()?['cr2f5_otherserviceinterest'],''),'','• ' & triggerBody()?['cr2f5_otherserviceinterest'])

How can you return the field but also a bullet point at the beginning as text? Also, is there any way of adding a return at the end of the expression i.e. returning to a new line if the above value is false.

Basically trying to return values in a bullet point list based on selection but if nothing is selected, not have loads of blank rows.

Many thanks in advance,

Alex

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-zhos-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Simmo86 ,

I suggest you use the concat() function here.

I have made a test on my side, please take a try with the following workaround:

The expression is:

if(equals(empty(triggerBody()?['ProblemStatus']),bool(true)),'',concat('• ',triggerBody()?['ProblemStatus']))

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Simmo86 69 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you so much for this, what about adding a carriage return at the end of this formula? I.e. Starting a new line?

Many thanks,

Alex

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Simmo86 ,

I am afraid there is no function to add a carriage return in the expression.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No