cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

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

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

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

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

Hi @livingstonep ,

 

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

34.PNG2.PNG

 

Best Regards,

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

View solution in original post

Highlighted
Kudo Collector
Kudo Collector

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

@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:

 

NewLine in Flow put in expression.PNG

 

 

this works for list columns in an Update, in Compose operations, and in variables

here is an example:

 

NewLine in Flow Variable.PNG

 

and the concatenated New Line in the list:

 

NewLine in Flow Variable showing in List.PNG

 

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

View solution in original post

7 REPLIES 7
Highlighted
Community Support
Community Support

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

Hi @livingstonep ,

 

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

34.PNG2.PNG

 

Best Regards,

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

View solution in original post

Highlighted
Super User
Super User

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

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.')

image.png

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:

  1. Get the new line after the timestamp?
  2. Prettify the body to be indented JSON?

Thank you!

Highlighted
Frequent Visitor

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

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

Highlighted
Super User
Super User

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

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.

Highlighted
Kudo Collector
Kudo Collector

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

@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:

 

NewLine in Flow put in expression.PNG

 

 

this works for list columns in an Update, in Compose operations, and in variables

here is an example:

 

NewLine in Flow Variable.PNG

 

and the concatenated New Line in the list:

 

NewLine in Flow Variable showing in List.PNG

 

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

View solution in original post

Highlighted
Frequent Visitor

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

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.

Highlighted
Frequent Visitor

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

use concat and {" \n\n"} ... yes with double quotes

example >>> concat('string 1',{" \n\n"},'String 2')

 

This will output

string1

string2

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,669)