Conditional removal of the tail of an email thread

(1) Share

Report

Posted on by olsamuel

Hi,

I want to be able to collect the first part of email threads.

Any thoughts how to do this?

The condition that should decided where to do the cut is typically "Best regards", "Br", but also other key words may be there.

If there is no hit on any of these, the complete email body should be provided as output.

So, what I believe I need is something like

first(split(<the text body>, <recursive check against a list of delimiters>))

But, as this does not work, I need another solution.

Help very much appreciated!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @olsamuel

first(split(<the text body>, 'Best regards'))

This will give you the message before the 'Best regards'

You can check whether it's null then return the full body using an IF condition.

Thanks

Was this reply helpful? Yes No
olsamuel 34 on at

Like (1)

Report

Thanks abm, this gives me one of the options and that I am familiar with.

The tricky thing for me is a solution where the delimiter may be one of many in a gross list.
I can of course repeat first-split with the explicit ones, but thought it would be nicer with a solution that checked against a list of delimiters.
Any thoughts?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @olsamuel

You can declare your expected delimiters in a Compose. Next I used the split( ) to convert it into an array. Then iterate each item from the array to use the split() expression against the email body. See below.

Try the below steps:

Above Compose2 expression is

split(outputs('Compose'),',')

Compose 3

first(split(triggerOutputs()?['body/body'],item()))

Note: Extend the flow by adding an IF condition to check whether the Compose 3 output is empty or not? If not empty then store that in a variable to get the output.

Hope it helps.

Thanks

Was this reply helpful? Yes No
olsamuel 34 on at

Like (1)

Report

Hi,
Again very much appreciating that you try to help me on this.

Couple of things
1. I added a condition on the Compose 3, with the check if the result is empty or not (null). It seems when there is no hit against the delimiter list, the Compose 3 uses the full body as the output. So all Delimiters runs True.
How to manage? Maybe another check if a match against the delimiter list is achieved or not?
2. Is there a way to run end the loop when the first delimiter match happens? Maybe "Do Until"?

Thanks!

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @olsamuel

Thanks for your reply. Ok I understood what you are saying. Great point. So what you could do is once you done split() it gives you an array. Check the array length using the expression length(). If its one means it didn't find the delimiter. If it more than one means it find the delimiter. I think that will do it nicely.

Thanks

Was this reply helpful? Yes No
olsamuel 34 on at

Like (1)

Report

Yes and thanks, I tried it out and it works. Still so that the split expression does not result in a length zero, but rather the original email body. But the length() function still works as you can compare between resulting and original length, The resulting length should be shorter when there is a delimiter match.

Much appreciated your effort!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @olsamuel

Thanks for accepting the solution.

Was this reply helpful? Yes No