web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Data Processing, best ...
Power Automate
Unanswered

Data Processing, best way to compare Streets from User Fields??

(0) ShareShare
ReportReport
Posted on by 184

Hey, I'm currently learning data processing using practical examples ... and no ... I don't make any money with it.

 

I have a street directory of around 12,000 streets.


Can someone who may have learned a job in data processing or have massive practical experience tell me what is the best way to use the database to compare?


In general, replace everything that is “ß” as “ss” (in Germany we have those stupid signs)?
Should I replace all spaces with no spaces so that I always get a contiguous string if there are no hyphens in it?


I've already read a lot but can't decide what the best way is to compare user input with the database.
(In this case we are talking about documents that are read out via AI and then flown into Excel with a plausible street)


I read about the Levenshtein distance method and thats pretty sexy, but unfortunately I can't get it implemented in power automate.


If you have any other tips or literature that you can read to get on the right path, It would be grateful.
Thank you best Regards

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard