Line break control character when creating issue

[Simon Gautschi]

Dear valued community members,

I am experimenting with auto-creating 'Jira Service Management (Cloud)' issues using Azure Logic Apps.
My Logic app pulls the description of the issue to be created from a SQL database.

I am using the following modules in this order

• SQL Server - Connectors - When an item is created (V2)
• JIRA - Connectors - Create a new issue (V2)

Behind the scene a SQL stored procedure writes data to a simple table with 2 columns

• MessageID
• MessageText

The 'MessageText' value is used in 'Create a new issue (V2)' to fill in the 'description' for the issue to be created.

For better readability and to present data in tables i need to format the text that is created by the SQL stored procedure.

Current state

• The data from the table is treated like a single line
• If i put 'h1.' to the beginning of the line it makes the whole text the biggest heading
• If i put characters for a table like '||Column1||Column2||' it interprets it as a table

So it does recognize control characters to format the description.

What is not working
What i couldn't figure out so far is what character i have to put in to get a new line.

I tried the following, but these are not recognized as control characters and are printed as part of the text.

• \\ from Text Formatting Notation Help
• \n
• <br>

Desired state

How can i include a line break into the text in the SQL database that then actually ends up as an line break in the issue that is created?

Many thanks for helping me out with this

Simon

[Bohdan Solodkov]

You can use \r\n for a line break