split by first space

Like (0) Share

Report

Posted on 2 Dec 2021 13:29:45 by MaxF

Hallo,

I have a String which looks like this: 16 Streetname 23

The number at the beginning can be random. So it can be 3, 5, 8, 22.....

So I just want to extract the part: Streetname 23

thanks for any kind of help

All responses (4)

Answers (1)

tom_riha 10,093 Most Valuable Professional on 05 Dec 2021 at 14:06:36

Like (0)

Report

Re: split by first space

Hello @MaxF ,

since Power Automate doesn't support regular expression, I don't think it's doable. You could go character by character and check if it's a number, but that would be a terrible solution. Therefore, I don't have a solution for situations when there's no space.
MaxF 22 on 04 Dec 2021 at 11:30:59

Like (0)

Report

Re: split by first space

Hallo Tom,

thanks, your solution works for me because of that i accept your answer.
The problem what have now, there was probably a display error in sharepoint where I want to store it,
Because when I look in details the string looks like this: 16Streetname 3
Because now it always returns me only the 3, which is correct according to your solution.
Do you have a solution for this(16Streetname 3) scenario too?
I still want only the string: Streetname 3
The numbers can still be random. 1,2,10, 22...
miguelcas Microsoft Employee on 02 Dec 2021 at 17:48:41

Like (1)

Report
Re: split by first space

Hi @MaxF
Here is a way using expressions to get the string that you are looking for:
substring(variables('StringToSplit'),add(indexOf(variables('StringToSplit'),' '),1), sub(length(variables('StringToSplit')),add(indexOf(variables('StringToSplit'),' '),1)))
I would recommend you to put this expressions into a compose action in order to get the string. This function will eliminate all characters before the first blank space from a string. in the function you need to replace the variables('StringToSplit') with your string as a variable, text or dynamic content.

If you want to learn more about expressions and functions here are some MS Docs to consider.
Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs
Microsoft Flow - Expressions and how to use them - Power Platform Community

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.
Verified answer

tom_riha 10,093 Most Valuable Professional on 02 Dec 2021 at 17:21:52

Like (3)

Report
Re: split by first space

Hello @MaxF ,

you could split it by the space, then skip the first object, and join the rest again using spaces.

join(skip(split(<string>, ' '),1), ' ')

Community site session details

split by first space

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

split by first space

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates