Issue with automated flow not capturing keywords correctly with expressions

Like (0) Share

Report

Posted on 7 Sep 2023 23:45:41 by rowanmitschke

I am having an issue. I used an automatic flow to automatically populate an excel sheet using expressions. It is frequently seeming to miss the keywords in the expressions. Is there something I am missing? It does not do this everytime. I've attached a picture of an email form we get from our website, the expressions I use in the flow, and the issue I'm running into. Notice how "type of referral" cell has all the extra stuff from later in the form. It should have caught "Email of Referring Provider" as the stop point and it is not doing so. It sometimes does this in the phone number and email column as well.

Referrals email.png

Excel sheet.png

Referrals flw.png

All responses (2)

Answers (0)

rowanmitschke 6 on 08 Sep 2023 at 15:44:54

Like (0)

Report

Re: Issue with automated flow not capturing keywords correctly with expressions

Here is a sample from another form that has the same issue.

excel.png

expressions.png

email.png
ManishSolanki 15,085 Super User 2025 Season 1 on 08 Sep 2023 at 02:48:54

Like (0)

Report

Re: Issue with automated flow not capturing keywords correctly with expressions

Hi @rowanmitschke

Could you pls share the text obtained from "HTML to text" action, pls replace actual data with sample one.

Thanks