Using Text Parser to extract data from standardized email received in Outlook and send to Monday.com

[AC_Tory]

I’ve created the regex, hopefully successfully, here: regex101: build, test, and debug regex

My current Make scenario is Outlook (watch messages) → Text parser (match pattern) → Monday (create an item)

1st concern: Regex/Text Parser: If I use Match Pattern (Advanced) function, I do not get an error but nothing shows up in next step. If I use the Match Pattern function, I am getting this error: “Failed to refresh metadata. Failed to parse named capture groups.”

• Global Match NO
• Case Sensitive NO
• Multiline NO
• Singleline NO
• Continue the execution NO

2nd concern: do I need a module between Outlook and Text Parser Match Pattern? How do I direct Text Parser to pull from email body content? The text* box? Do I need a Text Parser (HTML to Text) step?

[Stoyan_Vatov]

Hey there,

can you share some screenshots of the scenario and the module setup as well?

[AC_Tory]

Current Modules:

Text Parser setup: Text should be Outlook email body content, but currently just pasted email for testing.

When I click Save on Test Parser:

On Monday step, the Text Parser results don’t populate (two examples):

[AC_Tory]

I reduced my regex to just the first capture group: “ .*\n.*\n.*\n(?.*) Appointment “ and hit save. This does not throw error code and the capture group shows up in Monday module. So the error is something in my regex - but my regex is correct in the builder https://regex101.com/r/n3Zj8m/2 - how do I determine the error if it’s only in Make?

[Stoyan_Vatov]

I just copy pasted the regex and the text in a default Match pattern module and it worked directly. I get the same error but I can see the items in the next module without an issue. Try refreshing the scenario maybe?

[AC_Tory]

I created another new scenario to start from scratch and replicate what you said and it still did not work. The first group (type) generated but that was it, the rest was blank.

[AC_Tory]

I continue to get errors, even when I remove most of the regex and try again:

[AC_Tory]

Trial and error discovered this: Make.com Text Parser Match Pattern does not like “ ?s: ” (e.g. (?s:.*) to select all remaining content including line breaks). It’s acceptable in regex101 builder under Java but causes error seen above (failed to refresh metadata. invalid regular expression: invalid group) when used in Make.