cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
livingstonep
Kudo Commander
Kudo Commander

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
v-bacao-msft
Community Support
Community Support

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

@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

8 REPLIES 8
v-bacao-msft
Community Support
Community Support

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

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!

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

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.

@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

etalon
Frequent Visitor

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.

manvinder277
Frequent Visitor

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

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

 

This will output

string1

string2

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

 

DeeTronSEAM_0-1616617929601.png

 

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.

 

DeeTronSEAM_0-1616618612724.png

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

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,555)