Extraction of a word from a sentence if it is include in a list of word

(0) Share

Report

Posted on by Emmanuel9

Dear members,

Some actions generates a text variable %sentence% storing for instance "FCE - France - Marseille - vélodrome"

I try to look inside this sentence to find if it contains on of the town listed here "Paris, Marseille, Lyon, Dijon".

The result should be obtained even in case of mistake in the spelling so Marseil should send back Marseille. I assume that checking the first 4 characters of the words contained in %sentence% with the first 4 character of the town list would be sufficient.

I reached a result with the flow below but it does not allow any mistake in the spelling as it uses "find common list item".

Many thanks in advance

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Well, if you want to check the first 4 characters, then only include that much in the list you check for. So, instead of using "Paris, Marseille, Lyon, Dijon", use "Pari, Mars, Lyon, Dijo" as the list.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

Emmanuel9 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Finally I used a script to solve the issue.

$sentence = "%EntityName%"
$wordList = "Word List"
$variableName = ""
$sentence = [regex]::Escape($sentence)

#Looking for a match using the 3 first characters
foreach ($word in $wordList) {
    if ($sentence.ToLower().Contains($word.ToLower().Substring(0, 3))) {
        $variableName = $word.Substring(0, 3)
        #Write-Host "The sentence contain $word"
        break
    }
}
Write-output $word

Was this reply helpful? Yes No