You’re offline. This is a read only version of the page.
2
Hi
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
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
Share
Report
All responses (
Answers (
