How to capture the body of an incoming email?

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
YumaIT
Posts: 18
Joined: Tue Oct 02, 2018

07 Oct 2018

We see that on an incoming email the Subject line verbiage is stored in the Title column of the Ticket list.

Can we take the initial email's body - without markup language - and store it in the Body field in the Ticket list or even in a new field?

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

09 Oct 2018

Hi!

Could you please provide an example of your email's body?

YumaIT
Posts: 18
Joined: Tue Oct 02, 2018

09 Oct 2018

Alex,

Thanks for the quick assistance on this. It is the body field/column in the "Comments" list inherent in Helpdesk. We see that you strip the markup away from the emails that go back and forth in the "Discussion" tab in a Ticket. We would like to do the same for the initial email that comes in and place that same verbiage in a new field that we will pull for billing purposes to our clients.

I have attached a snapshot of the "body" information we would like to extract into a field with markup language, basically only the text of the body itself.

Thanks for your help!
Attachments
Comments.JPG
Comments.JPG (79.84 KiB) Viewed 2189 times

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

10 Oct 2018

Hi!

You can add an extra field to the comments list and strip HTML-tags in a flow with regular expressions.

Some helpful links about regular expressions:
https://javascript.info/regular-expressions
https://developer.mozilla.org/en-US/doc ... xpressions

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 13 guests