Fuzzy or approximate matching in Power Automate

Like (1) Share

Report

Posted on 22 Dec 2021 21:33:09 by Community Power Pla...

I have a flow that automatically updates an end users information in an excel table based off a MS Forms submission. However, right now the inputted email has to be an exact match for it to update. For example, if in my excel their email (key column) is example@gmail.com but in the MS Forms they input (key value) Example@gmail.com it won't be able to update - because of the capitalized E.

This is also the same problem if they add a space before or after the email. Is it possible for Power Automate to find the email besides these small inconsistencies?

All responses (5)

Answers (1)

Verified answer

AnthonyAmador 2,553 Moderator on 07 Jan 2022 at 20:45:47

Like (1)

Report
Re: Fuzzy or approximate matching in Power Automate

Hi @Anonymous

To add dynamic content to the expression, type the expression, then click the Dynamic content tab again and select the Dynamic content you need, for example.

The expression should be look like this.

toLower(outputs('Get_response_details')?['body/rfa0c5b1518a64ec884320a184fe0f950'])

I said "equal to" to "contains" because a thought you were using a condition, however I think the trim() function could help you remove the spaces in the string.

So in the end the expression should be:

trim(toLower(outputs('Get_response_details')?['body/rfa0c5b1518a64ec884320a184fe0f950']))

Just don't copy and paste it because the dynamic content from your form is different.

Hope this helps.

Regards.

Community Support Team - Anthony Amador

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.