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
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.
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...
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.
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), ' ')
Michael E. Gernaey
14
Super User 2025 Season 1
stampcoin
14
Churchy
12