cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FLOWPA
Helper I
Helper I

Street Addresses verification for data already submitted

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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.

 

 

 

 

View solution in original post

4 REPLIES 4
jbrit2020
Super User
Super User

@FLOWPA 

 

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?

 

 


@jbrit2020 wrote:

@FLOWPA 

 

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.

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.

 

 

 

 

View solution in original post


@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! 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,048)