Unanswered

variable with 'new line', doesn't get converted in MS Flow

(0) Share

Report

Posted on by blabla70

Hi,
Could anyone suggest a solution for a inconsistency between PowerApps and PowerAutomate, when converting a new line, Char(13), ?

I tried the following syntax it in the PowerApps TextInput.Default:
Concat(ComboBox.SelectedItems,Value & Char(13) & " ")

In PowerApps this ofcourse displays instead of converting it in a new line, as on the picture bellow

On the other hand it works well and converts in new line, in PowerAutomate 'Send an email (V2)':

But again is incorrect in PowerAutomate 'Create an approval', displays the instead converting it in a new line.

I need in all places (PowerApps, PowerAutomate) to have new line for each item. Any suggestion?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
 is a new line in HTML and there are places where it will automatically convert to a new line character. But if you want to use it as part of a string in a parameter you pass to a flow it should be encoded using Char(10). Char(13) is a carriage return.

Then in Power Automate you can use EncodeURIComponent to get the same character

EncodeUriComponent('%0A')

It works in email because email bodies support HTML. Emails sent by Approvals don't and have to use a specific markdown language. Use markdown to format Power Automate approvals - Power Automate | Microsoft Learn

Was this reply helpful? Yes No
blabla70 on at

Like (0)

Report

I have tried both of these syntaxes:
Concat(ComboBox.SelectedItems,Value & Char(10) & " ")
Concat(ComboBox.SelectedItems,Value & Char(10))

The first syntax converts it correctly in Apps and Send email, but not correctly in PowerAutomate 'Create an approval', it still displays the 

The second syntax only converts in a new line correctly in PowerAutomate 'Create an approval', and it doesn't get converted in new line in any of the other places (Apps, PowerAutomate 'Send an email (V2)' )

Any suggestion?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
Try using a carriage return and new line.

Concat(ComboBox.SelectedItems,Value & Char(10) & Char(13))

As I mentioned, won't work with Approvals since they don't recognize HTML formatting.

Was this reply helpful? Yes No
developerAJ 4,643 on at

Like (0)

Report

Hi @blabla70

As Pstork mentioned it won't work because email is an html format and approval use markup language. but that's not an issue for your work just use replace function to replace in Approval action.
replace(variables('Variable'),' ','')

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
blabla70 on at

Like (0)

Report

Hi developerAJ,
it sounds like a good solution, but I am getting the error when trying the following function tin the Inialize variable action:
replace(variables(triggerBody()['text_6']),' ','')

The error: "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'Template language expression cannot be evaluated: the default fired trigger is not defined at current scope. '.'."

Is there any syntax error?

Thanks in advance

Was this reply helpful? Yes No
developerAJ 4,643 on at

Like (2)

Report
@blabla70

use this
replace(triggerBody()['text_6'],' ','')

or
Initialize a variable(name: Text) and store triggerBody()['text_6'] .in that case use replace(variables('Text'),' ','')

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
blabla70 on at

Like (0)

Report

Correct it get accepted wihout variables(), thanks. But as a second argument, no character is accepted, ' ' a part.
So it removes the but doesnt replace it.
And I would need the second character a to be a new line, or at least other separator. Any idea?

Was this reply helpful? Yes No
developerAJ 4,643 on at

Like (1)

Report

use initialise variable
name it as varnewline ;type string;
value field : just click enter so that cursor goes to new line

now use this variable as second argument of replace function in place of ‘’ single quotes

Was this reply helpful? Yes No
Verified answer

blabla70 on at

Like (0)

Report

Thank you, it works fine!

Was this reply helpful? Yes No
developerAJ 4,643 on at

Like (0)

Report
@blabla70

Please mark this response as Solution

use initialise variable
name it as varnewline ;type string;
value field : just click enter so that cursor goes to new line
This is final formula:

replace(triggerBody()['text_6'],' ',variables('varnewline'))

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No