Answered

I want to get information out the middle of a textbox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So basically I have a column with information of the person. I have it layed out like this:

Name || phone number || email

How can I only get the phone number?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Maybe you can use mid and find.

Mid(text, Find("||",text),length of phone number)

You may have to add 2-3 to your Find result.

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous

@Anonymous's suggestion will work. However, if you apply this against a data value with a phone number that is of variable length, you'll need to add some additional formula to determine the length of the string that you want to extract with the mid function.

An alternative method is to split the input value into a table using the "||" characters as a row separator, to retrieve the second row. Here's the formula to do this.

Last( FirstN(Split("Name || phone number || email", "||"), 2 ) ).Result

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you both for your replies. How can I remove all the spaces that are between the numbers? @timl @Anonymous

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Substitute(Text," ","")

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Anonymous is correct in that the substitute function will strip out the spaces. You can chain these functions like so...

Substitute( Last( FirstN(Split("Name || phone number || email", "||"), 2 ) ).Result, " ", "" )

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Based on the needs that you mentioned, I think the Substitute function and Split function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Set the Text property of the Label to following:

Last(FirstN(Split(Substitute(TextInput2.Text, " ", ""), "||"), 2)).Result

On your side, you should type the following formula:

Last( FirstN( Split( Substitute(PersonInfoTextInputBox.Text, " ", ""), "||" ), 2 ) ).Result

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No