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...
Solved! Go to Solution.
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!
Here's a solution without using a separate variable, but is a bit uglier. Depending on your situation, might be better.
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.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.