MS Flow ICS Calendar Invite - Description cut off

[leslie_rivera]

I am using Flow to send an email with a calendar invite attached as an ICS file. It works great except the body of the calendar invite (description) gets cut off and only applies the first sentence when using a plain text field. When I use a rich text field it applies everything except its all in html format.

This is what i have in flow.

This is the text i want in the body of the invite:

JD Edwards Prod Outage from 10 p.m. Saturday February 19th – 3 a.m. Mountain Sunday Febuary 20th

This JD Edwards outage is required for Navisite to perform Operating System patching on our Production Servers (which includes the new Code Current Environment) 

Servers Affected:

Server1: ddddd

Server2: bbbbb

This is the outcome using a plain text field:

This is the outcome using a rich text field:

How do I get all the text to show in the body of the calendar invite?

[ScottShearer]

@leslie_rivera 

I haven't tested this, but try using a HTML to Text action and keep the column as rich text - before your compose action, add a HTML to text action and select the SharePoint description column as the content.  Then reference the output of the HTML to Text action in the Compose action for the description.

[leslie_rivera]

@ScottShearerUnfortunately that didnt work. It just came up blank. I tried:

Then added

My result was blank

[ScottShearer]

@leslie_rivera 

When you have the column set to text, do you have it configured for multiple lines of text?  If no, please do so and give it a try.

[leslie_rivera]

@ScottShearerYes its set to multiple lines of text. I checked the flow and the HTML conversion is working the issue is in the ICS. no matter what it only puts a limited amount of text in the body of the calendar invite (description). Not sure how to adjust that.

[leslie_rivera · Accepted solution]

Solution: Removed 'Description' and replaced with X-ALT-DESC;FMTTYPE

I was able to use a rich text field and it worked perfectly: