Power Platform Community Forum Thread Details

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

Categories:

Building flows

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: