Answered

Merge multiline string into single line

Like (0) Share

Report

Posted on 18 Nov 2020 06:07:26 by Community Power Pla...

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

All responses (9)

Answers (1)

jamesoza 3 on 24 Sep 2023 at 10:19:31

Like (0)

Report

Re: Merge multiline string into single line

Sometimes I use online tools such as MultiLine to Single Line which help to test and expected results we can get.
Community Power Pla... on 26 Nov 2020 at 05:34:20

Like (0)

Report

Re: Merge multiline string into single line

Hi @VictorIvanidze ,

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

Thanks for your help.
VictorIvanidze 12,214 on 23 Nov 2020 at 13:34:26

Like (0)

Report

Re: Merge multiline string into single line

Hi @Anonymous, thanks for your cudo but please tell me if it's really working for you?
VictorIvanidze 12,214 on 19 Nov 2020 at 08:44:30

Like (1)

Report

Re: Merge multiline string into single line

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:
Community Power Pla... on 19 Nov 2020 at 02:41:51

Like (0)

Report

Re: Merge multiline string into single line

Hi @VictorIvanidze ,

Thanks for your reply. May I know which expression to use for removing CR/LF from the string in MS flow?
Community Power Pla... on 19 Nov 2020 at 02:20:30

Like (0)

Report

Re: Merge multiline string into single line

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.
Jay-Encodian 2,920 on 18 Nov 2020 at 14:11:57

Like (0)

Report

Re: Merge multiline string into single line

@VictorIvanidze refer to the posts, this is covered... the typical approaches for removing an LB don't work
VictorIvanidze 12,214 on 18 Nov 2020 at 10:32:50

Like (0)

Report

Re: Merge multiline string into single line

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

Jay-Encodian 2,920 on 18 Nov 2020 at 09:01:04

Like (0)

Report

Re: Merge multiline string into single line

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