Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Spilt string in power apps



How to spilt the string in power apps with comma separtor?




Community Support Team
Community Support Team

Re: Spilt string in power apps

Hi @Mahipal,


Could you please explain a bit for the string here, what the string value contains?

If you would like to seperate the string contains comma, we could take use of the following functions:

1. Substitute ()

Which would replace the comma in the string, and replace by another value, here we use this function to replace comma with a pound character,

2. HashTags ()

Seperate the string contains the pound character, and returns a one-column table that contains the hashtags in the string. If the string contains no hashtags, the function returns a one-column table that's empty.

There is also left() Mid() or right() function available, see:

Left, Mid, and Right functions in PowerApps

Which you may use to split string in PowerApps.


There is no function available to split the string directly, if you would like this to be added in PowerApps, then please consider submit this as an idea.



Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Spilt string in power apps

Currently you can only (*) split a string into two parts based on a character. There is a feature request in the PowerApps Ideas page, please vote it up if you need this functionality in your application.


To split a string into two parts:

First: Left(ValueToSplit, Find(",",ValueToSplit) - 1)
Last: Right(ValueToSplit, Len(ValueToSplit) - Find(",",ValueToSplit))

(*) You could use a custom API where you pass a value and have its return split the string based on some separator. That would work, but it's a lot more complicated than it should.

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 314 members 4,565 guests
Please welcome our newest community members: