cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leslie_rivera
Helper V
Helper V

MS Flow ICS Calendar Invite - Description cut off

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.

leslie_rivera_0-1645468490656.png

 

 

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:

leslie_rivera_1-1645468523798.png

 

 

This is the outcome using a rich text field:

leslie_rivera_2-1645468547749.png

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
leslie_rivera
Helper V
Helper V

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

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

 

leslie_rivera_0-1645829959573.png

 

View solution in original post

7 REPLIES 7
ScottShearer
Super User
Super User

@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.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
leslie_rivera
Helper V
Helper V

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

leslie_rivera_0-1645483895751.png

 

Then added

leslie_rivera_1-1645483938217.png

 

My result was blank

leslie_rivera_2-1645483967832.png

 

@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.

image.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

@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
Helper V
Helper V

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

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

 

leslie_rivera_0-1645829959573.png

 

Hi Leslie, I am unable to get the rich content by using X-ALT-DESC;FMTTYPE. When i keep that in ics file creation it is giving empty in ics file. can you guide me

Can you share the code you are using? Is the column a rich text  column field?

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,458)