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.
