Power Platform Community Forum Thread Details

Hello,

I added ICS calendar steps to my flow, but the calendar item isn't showing up where I want it quite yet. I actually thought I had done something wrong at first as I couldn't find the event. Finally, I scrolled all the way up to the midnight hour and finally found it. Since the Outlook calendar view defaults to 8am-5pm PST it was completely out of view.

When I open the .ics file from my Outlook email to add it to my calendar, it looks like it is going to be an all day event because the 'All day' box is checked but it shows up in the midnight slot instead. How do I get it to show up as a true all day event, like the "Jessie OOO" all day event that I manually entered onto my calendar? I noticed that if I manually uncheck the Viola 'All day' box and recheck it and save it, that it shows up at the top along with "Jessie OOO", but of course, my users won't know to do that.

All Day SS.png

SharePoint Start Date Settings:

In an effort to troubleshoot the issue I changed my SharePoint Start Date column setting from the Date Only setting seen below to Date & Time. The Output of a Compose step based on Date Only is 20220829. The Output of a Compose step based on Date & Time is 20220829T000000Z which ends up being a worse result as the Start Date shows up on Sunday, August 28 at 5pm instead of Monday, August 29.

Flow steps:

I'm using the same 'Compose ICS Date' Outputs for both DTSTART and DTEND. Is there something I can add to this syntax to get it to appear as an All Day entry versus defaulting to midnight PST? If having it show up as a true all day event is too tricky. Is there a way to amend this compose statement to hardcode an 8:00am start time? If necessary, I could add a second compose statement to hardcode an end time as well (e.g. 8:30am).

Flow Results:

Here is the output of the Compose ICS File Format step from a successful flow run based on a Date only setting in SharePoint. As you can see the date formatting is very basic. There is no reference to time at all. As previously mentioned, when I run the flow with a SharePoint column setting of Date & Time, the output is 20220829T000000Z.

I've tried to be as detailed as possible to help you help me. I would greatly appreciate any advice you can offer to help me resolve this. Thank you! Teresa

Categories:

Building flows

Hello,

I found the solution for single all day ics invites and multi-day all day ics invites on Stack Overflow.

php - Cannot able to create all day .ics event - Stack Overflow

Here is a snapshot of the solution:

Here are my revised flow steps which tested successfully (an all day invite on the correct calendar date). The Outputs for the line with the red arrow are coming from the 'Compose ICS Date' Compose step.

In order to get the ics file ready to attach to the email, you also need to add these two steps:

Create file SS.png

When you are crafting the email, the dynamic content for the Name comes from the 'Create file' step and the Body comes from the 'Get file content' step.

email step.png