Unanswered

Trim and format phone number

(0) Share

Report

Posted on by Davyjones

Hi Experts,

I have string which is a phone number, I want to remove the 1(country code) in the number if it exist and then format it. I don't know if there is connector to use or expression if any and how to write an expression for this. Please help.

Example:

if the input is 13214325432, I would like to have it as 321-432-5432.

If the input is 3214325432, I would like to have it as 321-432-5432.

For now the first character will be either 1 or nothing as shown above since we deal with only US.

Thanks in advance for your help.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

CFernandes 8,402 Most Valuable Professional on at

Like (2)

Report

@Davy

@Jcook has excellently explained this in his blog post https://flowaltdelete.ca/2020/07/02/power-automate-format-phone-number-easy/

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Davyjones 20 on at

Like (0)

Report

@CFernandes Thanks for your response.
I came across that post too, it does not explain trimming the 1 when it occurs.

Was this reply helpful? Yes No
Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

@Davy No worries, you want to remove the 1.

Compose 1 - string(13214325432)
Compose 2 - substring(outputs('Compose'),1,sub(length(outputs('Compose')),1))

Output

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Davyjones 20 on at

Like (0)

Report

@CFernandes Thanks for taking your time in helping me.

You have got me way forward than where I was. One last thing since its now string which is what i what in the end. How do i seperate it as ###-###-#### because @Jcook article helps us to format a number and since this is now a string please let me how can this be done.

Thanks in advance for your response.

Was this reply helpful? Yes No
Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report
@Davy

Sure thing. You can convert to number by using the fomula
int(outputs('Compose_2'))

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Davyjones 20 on at

Like (0)

Report

Thank you so much, for your time and solution with screenshots.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@Davy I am glad my solution worked 🙂. Have a wonderful weekend..

Was this reply helpful? Yes No