cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

removing spaces in a phone number and adding text

I have a field which I need to populate with a text to SMS address. i.e. phonenumber@blahblah.co.nz. Is there a formula I can use in the Text control that would pull the phone number from another field (or from the CDS), strip out the spaces, and add the @blahblah.co.nz text? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: removing spaces in a phone number and adding text

Hi @Caroline,

 

Please use the Substitute function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-replace-substitute

 

The formula should be something like:

 

Substitute(Label1.Text," ","")

Label1 contains the phone number.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: removing spaces in a phone number and adding text

Hi @Caroline,

 

Please use the Substitute function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-replace-substitute

 

The formula should be something like:

 

Substitute(Label1.Text," ","")

Label1 contains the phone number.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,753)