MS Flow expression - how to concatenate New Line into string variable

(0) Share

Report

Posted on by livingstonep

358

I am building a flow, and need to append values into a string variable for an audit trail

so I have this:

concat(string(utcNow()), ': ', 'Approved by Data Protection', Char(13))

but I get an error when trying to save the expression ...

in the list following the update (using the variable) it looks like this:

2019-05-21T08:28:43.2692428Z: Approved by Health & Safety2019-05-21T08:30:02.4883027Z: Approved by Data Protection

when it should look like this:

2019-05-21T08:28:43.2692428Z: Approved by Health & Safety
2019-05-21T08:30:02.4883027Z: Approved by Data Protection

what am I doing wrong, and how can I include a new line/line feed into the variable

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (2)

Verified answer

v-bacao-msft on at

Like (5)

Report

Hi @livingstonep ,

You can add a carriage return directly to the Value of Append to string variable action.

Best Regards,

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

Like (0)

Report
Is this still a viable solution? I can't seem to get it to work.

What I have:

concat(utcNow(),':',items('Apply_to_each_2'),'HTTP request failed.')

What I get:

2019-09-30T06:52:14.1109671Z:testHTTP request failed.{"error": {"code": 502,"source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net","clientRequestId": "f8a32b88-1b63-4317-ba04-2ba5a2c21599","message": "BadGateway","innerError": {"status": 502,"message": "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\r\nclientRequestId: f8a32b88-1b63-4317-ba04-2ba5a2c21599\r\nserviceRequestId: db31099f-80c2-9000-0496-715c4af5a497","source":"https://mycompany.sharepoint.com/sites/test/_api/web/lists/GetByTitle('test')/items?$select=Title&$filter=Modified%20ge%20'September%2020,%202019'","errors": ["-2147024860","Microsoft.SharePoint.SPQueryThrottledException"]}}}

What I want:

2019-09-30T06:52:14.1109671Z:testHTTP request failed. { "error": { "code": 502, "source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net", "clientRequestId": "f8a32b88-1b63-4317-ba04-2ba5a2c21599", "message": "BadGateway", "innerError": { "status": 502, "message": "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\r\nclientRequestId: f8a32b88-1b63-4317-ba04-2ba5a2c21599\r\nserviceRequestId: db31099f-80c2-9000-0496-715c4af5a497", "source": "https://mycompany.sharepoint.com/sites/test/_api/web/lists/GetByTitle('test')/items?$select=Title&$filter=Modified%20ge%20'September%2020,%202019'", "errors": [ "-2147024860", "Microsoft.SharePoint.SPQueryThrottledException" ] } } }

How can I:

Get the new line after the timestamp?

Prettify the body to be indented JSON?

Thank you!

Was this reply helpful? Yes No
sarahmcd9000 32 on at

Like (1)

Report

Adding a space with enter is also no longer working for me

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

Like (1)

Report
Me neither.
I've tried:

1. Variable with single quote, ENTER, single quote

' '

2. Variable with ENTER only, no quotes

3. ENTER between two dynamic values

None of these create a new line when using Append to String Variable.

Was this reply helpful? Yes No
Verified answer

livingstonep 358 on at

Like (10)

Report
@ericonline @sarahmcd9000 @v-bacao-msft
try this in Notepad or whatever your favourite text editor is:

Concat(variables("VarName"), ' " this is a new line in the target object", ' " this is a new line in the target object")
Paste the above into your target object using Expression:

this works for list columns in an Update, in Compose operations, and in variables
here is an example:

and the concatenated New Line in the list:

hope this helps - if it does, please mark it as solution

Was this reply helpful? Yes No
etalon 37 on at

Like (1)

Report

This is an FYI for future me: If your output is being viewed in HTML (ie a field for an email), just add <br> to the string that is being appended to create the line break.

Was this reply helpful? Yes No
manvinder277 21 on at

Like (1)

Report

use concat and {" \n\n"} ... yes with double quotes
example >>> concat('string 1',{" \n\n"},'String 2')

This will output
string1
string2

Was this reply helpful? Yes No
DeeTronSEAM 396 on at

Like (2)

Report

@manvinder277 Does this still work for you? When I try to use that concat expression, PAutomate flags the expression as invalid.

So far all I've found that works is to declare a variable and stick a linefeed in it, then use that variable where I want a linefeed. E.g.

concat(
  body('Parse_JSON_of_the_filtered_Scenario_2_collection')?['ScenarioID']
  , '|'
  , body('Parse_JSON_of_the_filtered_Scenario_2_collection')?['AD_DisplayName']
  , '|'
  , body('Parse_JSON_of_the_filtered_Scenario_2_collection')?['AD_UserPrincipalName']
  , '|'
  , body('Parse_JSON_of_the_filtered_Scenario_2_collection')?['AD_Title']
  , variables('strLineFeedCharacter')
)

Was this reply helpful? Yes No
nejhade 80 on at

Like (0)

Report

not working for me. Creating variable with space/enter and adding it into concat function.
then sending that concat variable into mail.
Mail doesn't get new line. I tried all way. Don't know why its nt working. at run flow I am getting new line but in a outlook mail box , new line is not coming. Please help. trying since last 2 days.

I have initialized variable 'MailBody' where I have If condition in Concat statement in it.
ex:
concat('I approve the below request:','
',if(equals(triggerOutputs()?['body/TYPE'],'ADP'),concat('Name : ',triggerOutputs()?['body/NAME'],'
','KBC : ',triggerOutputs()?['body/KBC'],'
','PQR : ',triggerOutputs()?['body/PQR']),concat('Name : ',triggerOutputs()?['body/NAME'],'
','XYZ : ',triggerOutputs()?['body/XYZ'],'
','ABC : ',triggerOutputs()?['body/ABC'],'
','EFG : ',triggerOutputs()?['body/EFG'])))

then I have added variable to the sent mail activity where I have link to create another mail then above mail body executes, I have tried all way(adding<br>, created variable with enter and added, <\n> line) to add new line but its not working. I am getting all the values in single line.
ex: Name:ValueXYZ:ValueABC:ValueEFG:Value
Expected:
Name:Value
XYZ:Value
ABC:Value
EFG:Value

Was this reply helpful? Yes No
DeeTronSEAM 396 on at

Like (0)

Report

Hola, @nejhade

Sorry to hear you're having problems with this. I do know things change rapidly with PAuto and PApps, so it's quite possible that what worked before is something that doesn't anymore. But, let me try to provide some ideas that might help you zero in on the fix:

I have many flows that send HTML emails using the Outlook "Send an email from a shared mailbox" action. They do have line feeds galore in them...though they are HTML <br\> and <p></p> tags....and they properly create linebreaks in our users' Outlook email reader. So, are you injecting your email body into the default body editor or the html editor in your Outlook email action? E.g. ..

default:

versus what's there when you click on the editHTML button (aka <\>) all the way to the right:

As I'm not sure what action you're using for the email-Send, this may not be valid. But I will say that if you're using the Outlook email sending actions, I strongly urge you to create your email body variable as HTML and ensure it contains proper HTML formatting. That seems to work fine for me.....although there are many quirks about how Outlook renders HTML emails...something that many email marketing experts have posted many blog posts documenting, bitching, moaning, and sometimes circumventing.

Hope that helps. Good luck.

As for creating a linebreak character, they way I do it now is different than the way I described above with a space and enter/return in a variable. Now I use a formula that decodes the carriageReturn+lineBreak character codes (URI-encoded) :

value formula:
decodeUriComponent('%0D%0A')

aka ASCII(13)+ASCII(10), aka CHAR(13)+CHAR(10), aka CrLf.

Was this reply helpful? Yes No