Check Company Name Record

[AnetaO]

We have a big Approval workflow for requesting different types of code - document class, discipline, supplier (company), all connected to document management standard. 

We have created existing "master" lists (separate for each type of code) with the approved entries. 

The flow has been adapted to validate which type of code is being requested and check if the three letter code already exists. However, the problem persists when attemptint to check if a company had already been approved and is added. We can check for exact match but unfortunately users will sometimes add Ltd instead of Limited or abolish it all together ie Wizard Labs Ltd can be Wizard Labs and Wizard Labs Limited. Ideally, I'd like a condition to check for similaraties in the titles and if exact match (which we have already built) to reject but if there is a probable match to alert the user to reveiw.

Is this possible?

I have been experimenting on a Test list, without the approval flow, only trying to make above condition work with When an Item is Created, Evaluate Type of Code, Get Items (from master list), and then I can only match exactly.

Thanking you.

[ScottShearer]

@AnetaO :

I don't believe that you can achieve your goal by using standard Flow features.  One avenue that you might explore is to create an Azure function that does the type of text analysis that you need and calling that function from Flow.  Here is a link to some documentation to get you started.

[AnetaO]

@ScottShearer 

Thank you Scott. That's unfortunate if being the case. Azure will be way out of my debth to deal with.