Postal Address Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1191830%22%20slang%3D%22en-US%22%3EPostal%20Address%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1191830%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20use%20Bing%20Maps%20API%20or%20Google%20API%20to%20validate%20physical%20addresses%3F%20I%20want%20to%20avoid%20user%20input%20errors%20in%20my%20form.%20When%20I%20add%20a%20%22location%22%20in%20SharePoint%2C%20it%20auto-populates%20the%20address%20as%20I%20type.%20I%20would%20also%20like%20to%20geocode%20the%20address%20to%20store%20the%20coordinates%20of%20the%20property.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1191830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1192284%22%20slang%3D%22en-US%22%3ERe%3A%20Postal%20Address%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192284%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566982%22%20target%3D%22_blank%22%3E%40mposs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStandard%20MS%20Forms%20can't%20do%20that%20whilst%20the%20user%20is%20in%20the%20form%20(I%20haven't%20heard%20of%20Forms%20Pro%20being%20able%20to%20do%20it%20either%20but%20I%20am%20not%20a%20user%20of%20Pro).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20possibly%20try%20taking%20the%20details%20once%20submitted%2C%20and%20using%20Microsoft%20Power%20Automate%20(formerly%20Flow)%20to%20vet%20the%20address%20and%20then%20correct%20any%20inaccurate%20input%20via%20this%20process.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20Just%20had%20a%20thought%2C%20you%20could%20also%20put%20a%20hyper%20link%20to%20Bing%20or%20Google%20maps%20for%20users%20to%20validate%20their%20address%20themselves%20and%20then%20they%20can%20copy%20it%20into%20the%20form.%20It's%20a%20low%20tech%20workaround.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

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.

1 Reply

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