You’re offline. This is a read only version of the page.
Definitely, data validation and street address verification should be done before submitting a form.
However, we have a list of US street addresses that were already entered without any validation. We want to check that those addresses are valid.
I'd like to build an app with a form to retrieve those old addresses from a spreadsheet and verify them. We need to verify the address spelling, and the street address matches the city, and zip code.
Any suggestion on how to achieve this? Any PowerApps tools to serve this purpose? Please, point me in the right direction, and I'll take care of the rest.
@jbrit2020 wrote:Yeah...I'm not sure this is feasible without a datasource you can query freely. But try the following URLs:
https://www.youtube.com/watch?v=68RijxjKaC8
https://www.youtube.com/watch?v=cj2cC8EBj-I
I think you might be able to at least make your job slightly easier but not fully automated.
Thank you, this helped!
Yeah...I'm not sure this is feasible without a datasource you can query freely. But try the following URLs:
https://www.youtube.com/watch?v=68RijxjKaC8
https://www.youtube.com/watch?v=cj2cC8EBj-I
I think you might be able to at least make your job slightly easier but not fully automated.
@jbrit2020 wrote:
Do you have a dataset that contains the correct addresses as well?
How do you propose to validate the addresses?
Is it something you want to do manually?
Besides verifying do you also want to correct them?
No, there is no dataset with the correct addresses.
I'd like to verify the addresses with google. For now, I manually copy and paste the address into google, and check if google recognize the address, or if give me a suggested matching address. When needed, I manually make address changes.
Here is what I would like to:
- Have the app query google for "111 Street Name, City , State, ZIP" and return on a label: correct or incorrect.
in addition, if possible
- return the query result with a matching address or addresses
Anything that can speed up and help automating the current manual process of googling the address.
It doesn't have to be fully automated. We just need help making this process faster.
Do you have a dataset that contains the correct addresses as well?
How do you propose to validate the addresses?
Is it something you want to do manually?
Besides verifying do you also want to correct them?
#1
WarrenBelz
89
Most Valuable Professional
#2
MS.Ragavendar
60
#3
stampcoin
48
Share
Report
All responses (
Answers (
