cancel
Showing results for 
Search instead for 
Did you mean: 

Add optional parameter for separator string to Concat and Concatenate functions

It would be useful to have an additional optional parameter to the Concat and Concatenate functions for a separator string.  This string would be placed between all concatenated strings and not at the end.

For example Concat(MyTable, MyCustomers, ", ")

I am not sure how this could work for Concatenate, but you (Microsoft) made it work in the Power Query M language (Text.Combine).

Thanks.

Status: New
Comments
Anonymous
Not applicable

This would be incredibly useful.

 

My current workaround for it is to just use the Left()Len(), and Concat() together. It goes like this:

Left( 
    Concat( DataSource, Expression ),
    Len( Concat( DataSource, Expression ) - Number )
)

It doesn't look nice and it can be very restrictive at times.

 

@CWesener@linhtran@AndyPennell@Audrie-MSFT@audrieg -- I'm just randomly tagging devs to catch your attention. So, feedback about the idea? This seems to be simple enough.

PowerApps Staff

Adding @GregLi our PM in this area.

Cam
Level: Powered On

yes! i'm stuggling with this issue right now.

 

this suggestion would be awesome

Level: Power Up

I am having this same issue and would like to have a solution to it other than trying to trim the last comma off the string.

currently the solution i have is.

   Mid(
        Concat(
            Collection,
            ", " & Name & " " & Quantity
        ),
        2
    )

It removes the first 2 chara from the string which is comma and space.