Answered

Phone number format from forms to sharepoint list or during create rows

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow that move data from Forms to a SharePoint list then one that once a week uses conditions to gather information from the list create a excel table and email it.

I need to have the phone numbers in the Excel file formatted +1 (xxx) xxx-xxxx.

Is there a function/expression I can use either when I move the data from forms to the list that removes all spaces and characters then formats or as I add the rows to my table?

help 2.PNG help 1.PNG

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Could you please explain removing characters? Also provide some sample data.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You could use the expression. See below.

formatNumber(4537893833,'1(###) ###-####')

This will output

1(453) 789-3833

Hope it helps.

Thanks

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

Like (1)

Report
Copy link

Link copied!

@AB Many of the forms responses come in with various spaces or characters. If I can clean the numbers from xxx-xxx xxxx to a xxxxxxxxx then format to xxx-xxx-xxxx or go directly to xxx-xxx-xxxx. I figured out the expression

replace(replace(outputs('Get_response_details')?['body/re974a84bf6db4095b0c3dbbac641c242'],' ',''), '-','') to clean the number of spaces and dashes in my "create item" action

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

Like (1)

Report
Copy link

Link copied!

This gets me the second part. Can I replace and format in 1 expression?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Yes you can. Please see below

formatNumber(replace(replace(outputs('Get_response_details')?['body/re974a84bf6db4095b0c3dbbac641c242'],' ',''), '-',''),'1(###) ###-####')

Change the highlighted portion format accoringly.

Thanks

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

If flow complains about the datatype then convert to int()

formatNumber(int(replace(replace(outputs('Get_response_details')?['body/re974a84bf6db4095b0c3dbbac641c242'],' ',''), '-','')),'1(###) ###-####')

Was this reply helpful? Yes No