Forum Discussion

mposs's avatar
mposs
Copper Contributor
Feb 24, 2020

Postal Address Validation

Is there a way to use Bing Maps API or Google API to validate physical addresses? I want to avoid user input errors in my form. When I add a "location" in SharePoint, it auto-populates the address as I type. I would also like to geocode the address to store the coordinates of the property.

microsoft forms
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Feb 25, 2020

    Hi mposs 

     

    Standard MS Forms can't do that whilst the user is in the form (I haven't heard of Forms Pro being able to do it either but I am not a user of Pro).

     

    You could possibly try taking the details once submitted, and using Microsoft Power Automate (formerly Flow) to vet the address and then correct any inaccurate input via this process.

     

    EDIT: Just had a thought, you could also put a hyper link to Bing or Google maps for users to validate their address themselves and then they can copy it into the form. It's a low tech workaround.

     

    Hope that helps?

     

    Cheers

    Damien

Resources