Extract emailBody to Excel Append

[Read_BlogStar]

Help me, I’m new.

I am working on an emailBody extractor to excel via appending a string of variable text “ABC” from within the steady string “123 ABC 789” and have come up with the following:

[Trigger: Email Recieved … Additional Filters: by CC]

[For Each … List of Items: [Email Body] … Condition:

For Each Get emailBody
If mail.cc.Contains(“XYZ@gmail.com”)
emailBody = Get emailBody
regexPattern = “(?<123 ABC 789.*?(?=,)”
extractedInfo = System.Text.RegularExpression.Regex.Match(emailBody, regexPattern).Value.Trim
Append Range (WWW.xls, “Sheet”, “A1”, {extractedInfo}
End If
End For Each

[vrdabberu (Varunraj Dabberu)]

Hi @Read_BlogStar

Are you faving any errors. Share your flow once and your exact problem you are facing so that I can gelp you.

Regards

[ashokkarale]

@Read_BlogStar,

What’s the error you are facing?

Thanks,
Ashok