Create cleansed records in Google Sheet from Sharepoint List items
Recurrence
PREMIUM
SharePoint, Pitney Bowes Data Validation, and Google Sheets
Use this flow to standardize and validate addresses from Sharepoint List in bulk and push cleansed addresses into Google Sheet. Select a List that has header columns as Title (as FirmName), AddressLine1, AddressLine2, City, StateProvince, PostalCode, and Country. To store non-validated addresses, select another List with headers as Status, StatusDescription, and StatusCode (along with the ones mentioned above).
