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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.