Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
  • 1.  Remove line breaks from concated multitext

    Posted Nov 30, 2021 02:54 AM
    Hi, i am storing multiple multitext values in a sharepoint list and want to preview and concat these values in a list.
    But i need to remove the linebreaks (in case there are some) to show it in one line.


    This is how my formula currently looks like.


    Can someone help me out here?

    ------------------------------
    Fabian Heil
    ------------------------------


  • 2.  RE: Remove line breaks from concated multitext

    Top Contributor
    Posted 21 days ago
    Hi @Fabian Heil,
    This should work
    Substitute(
       Concat(
          Filter(
             'RIS - ISA Positionen',
    	     Title = ThisItem.Title &&
             ISA_x002d_Schicht = ThisItem.'ISA Schicht'
          ),
          FreieStrecke_x002f_Bahnhof & " / "
       ),
       Char(10),
       ""
    )​


    ------------------------------
    Warren Belz
    Queensland Australia
    ------------------------------