Answered

Replacing carriage return and line break in a string

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Meneghino 6,949 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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!

Was this reply helpful? Yes No
degvalentine 195 on at

Like (0)

Report
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.

Was this reply helpful? Yes No