Response from Forms - filter without Numbers

[IPGeorgiev]

Hi all,

I am new to flow and powerapps - here my current flow:

The answer to one of my questions in the form looks as follows:

12345 John Johnson

So it pretty much is a number and first and last name.

Once the approval is given the next step in my flow is to send a specific mail using send an e-mail v2. In the body of the E-Mail I want to be able to enter the response of the questions I mention above,however without the numbers so that it leaves only the names.

Is this possible?

Thanks!

[IPGeorgiev]

HI again,

I have managed to do this using the info from this :

https://powerusers.microsoft.com/t5/Building-Flows/extract-s-string-between-two-characters/td-p/8083...

however now what I need to do is to get the value before the space , so in the example from the previous post I want to get just 12345 displayed.

Can anyone help me?

[Gristy]

look up using the function split, and then just use the first item returned in the array.

[ChristianAbata · Accepted solution]

Sure you can. You need to add a function that split your answer like this

 

As you can see in this example in the first compose I've your answer and in the second the function.

[IPGeorgiev]

Thanks a lot for the response - however can you please advise what should I put in the first compose? As I am unable to get the desired result.

Thanks!