Change body of Trello card that has been emailed.

Like (0) Share

Report

Posted on 18 Jan 2018 12:22:45 by peteM

Hi,

Any help much appreciated -

I use the email to board function of trello, and would like to use Flow to remove the email tail that my company adds - a "the contents of this email.........." disclaimer thing. Currently, the Card arrives on the board with this t the end of the body.

Would this be possible in Flow?

Many thanks,

Pete

All responses (1)

Answers (1)

Verified answer

v-xida-msft on 19 Jan 2018 at 09:31:25

Like (0)

Report
Re: Change body of Trello card that has been emailed.

Hi @peteM,

Could you please share a screenshot of your flow's configuration?

Could you please share a bit more about the disclaimer thing within body of the email?

Further, do you want to remove the disclaimer thing and create a card based on body of email in Board of your Trello?

I assume that the disclaimer thing is existed in the end of Body of your email and the format of your email body as below:

I have made a test on my side and please take a try with the following workaround:

Add a "When a new email arrives" trigger.

Add a "Html to text" action, Content set to Body dynamic content of the trigger.

Add a "Compose" action, Inputs set to following formula:

indexOf(body('Html_to_text'),'The contents of this email')

Add a "Compose 2" action, Inputs set to following formula:

sub(length(body('Html_to_text')),outputs('Compose'))
Add a "Compose 3" action, Inputs set to following formula:

substring(body('Html_to_text'),outputs('Compose'),outputs('Compose_2'))
Add a "Compose 4" action, Inputs set to following formula:

replace(body('Html_to_text'),outputs('Compose_3'),'')
Add a "Create a card" action, Card Description field set to output of "Compose 4" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris