Answered

Replacing carriage return and line break in a string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am pulling in a field from a database table through a SQL Server connection that contains all the fields that populate a dropdown - they are separated by a carriage return and a line feed.

My hope is if there is a way to translate a SQL statement like REPLACE(REPLACE(field, CHAR(10), '*'), CHAR(13), '*) which would change them into ** between the dropdown items and then do a split function in PowerApps to get a table of the items to go into the dropdown.

I am coming at a loss on how to approach and accomplish however...

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Meneghino 6,949 on at

Like
a
(3)

Report
Copy link

Link copied!

Start looking at this:
https://docs.microsoft.com/en-us/powerapps/functions/function-split

May work with Char(13) and/or Char(10) as separator
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you, I saw the split part, but wasn't sure if PowerApps recognized line feeds and carriage returns - didn't think to look up if the same Char function existed..... again thanks!
degvalentine 195 on at

Like
a
(0)

Report
Copy link

Link copied!
Here's a solution without using a separate variable, but is a bit uglier. Depending on your situation, might be better.
encode the content
replace newline with a new delimiter
decode the content
split on the new delimiter
In the example, I use "outputs('Compose')" as the content you want to split and a tilde as the new delimiter.
split( decodeUriComponent( replace( encodeUriComponent(outputs('Compose')), '%0A', encodeUriComponent('`') ) ), '`' )
You can find do this with windows-style newlines (CRLF), too: "%0D%0A". Here's a link to the W3 School's table of url-encoded values.

Edit: just noticed @FlowNick found this same solution a long time ago.