Answered

Merge multiline string into single line

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I designed a flow, that grabs value stored in the "subject" field from the body of the email.

I used Html to Text option to convert email into text. While fetching the subject, it split into two lines. For my flow to work I need the value of subject in single line.

Below image is output of HTML to TEXT action output.

The highlighted text I want to capture into a single line.
Html to Text.PNG

The string function I used is

substring(body('Html_to_text'),add(indexOf(body('Html_to_text'), 'Subject'),7),sub(indexOf(body('Html_to_text'), 'Please'),add(indexOf(body('Html_to_text'),'Subject'),7))).

Is there any way I can merge the multiline string into one?

Help much appreciated!

Thanks

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous

Check out the following solutions:

https://powerusers.microsoft.com/t5/Building-Flows/remove-line-break/td-p/521210

https://powerusers.microsoft.com/t5/Building-Flows/Replace-Newline-in-Flow-Expression/m-p/58873#M5411

HTH

Jay

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

It seems much easier will be remove CR/LF from the string.

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

@VictorIvanidze refer to the posts, this is covered... the typical approaches for removing an LB don't work

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Jay-Encodian ,

Thanks for your reply.

I tried working with URI component. However, when I compare the value of the subject with text field, my conditions are getting failed.

My subject got
uriComponentToString(replace(uriComponent(variables('SubjectLine')),'%0A',' ')).

It is showing me string output. But my comparison conditions are failing.

Help much appreciated!

Thank you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VictorIvanidze ,

Thanks for your reply. May I know which expression to use for removing CR/LF from the string in MS flow?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

syntax is: replace(text: string, oldText: string, newText: string)

So you have try to use something like
replace(variables('Subject'),variables('CRLF'),'')

Have a look at this flow:

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous, thanks for your cudo but please tell me if it's really working for you?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VictorIvanidze ,

I haven't tried this solution. it worked for me with uricomponent solution.

Thanks for your help.

Was this reply helpful? Yes No
jamesoza 3 on at

Like (0)

Report
Copy link

Link copied!

Sometimes I use online tools such as MultiLine to Single Line which help to test and expected results we can get.

Was this reply helpful? Yes No