SharePoint List to Google Sheets - Number Format

(2) Share

Report

Posted on by GAJames

I've built two flows, one to parse data from an email and store the information in SharePoint and then another to transfer that information into Google Sheets.

Everything works fine, except when a phone number is stored as a number in the SharePoint list it copies across to Google Sheets as text. What can I amend in the flow so that the phone number is stored in Google Sheets as a number?

Thanks

All responses (1)

Answers (0)

sandeepstw on at

Like (0)

Report

Re: SharePoint List to Google Sheets - Number Format

Hi @GAJames ,

Get an item from SharePoint.
Compose a expression to remove non-numeric characters using
int(replace(replace(replace(replace(triggerBody()?['PhoneNumber'], '-', ''), '(', ''), ')', ''), ' ', ''))
then add row in Google Sheet using google sheet connection and login using google.

mark as solution if it helps.

Thanks

Sandeep Mishra