#MicrosoftFlow #MicrosoftFlowCalendar
In this video I show how you can use Microsoft Flow to create and send out ICS Format Calendar invites.

Here’s the link for the ICS File Format: https://github.com/aprildunnam/Flow/blob/master/ICSFormat

For SharePoint List Formatting samples check out their GitHub: https://github.com/SharePoint/sp-dev-list-formatting

24 Comments
  1. Christopher Bird 2 years ago

    A really neat solution and fabulous presentation.

  2. Mathieu Potvin 2 years ago

    Would it be possible to have a quick tutorial on how you formated this list? Pretty nice!

  3. That API Guy 2 years ago

    Great tutorial and a great business case as well.

  4. Geetha Sivasailam 2 years ago

    Super useful solution for a common business ask! Love the detailed walkthrough!

  5. Tyler 2 years ago

    Really Helpful!

    I did find that when I wanted to add multiple lines to the description I had to use the following formula

    DESCRIPTION;ENCODING=QUOTED-PRINTABLE:This is the first line.=0D=0AThe Second line.=0D=0AThe third line.

    Helpful for anyone else wanting to write mutliple lines for the description.

  6. MutualTrust IT 1 year ago

    Hi April – thank you for your video. I am looking something similar. I would like to set up Flow which will do following:
    1. Organiser send meeting request to the meeting room. Skype for Business meeting for instance.
    2. Meeting is tentative at this stage;
    3. Specific people in our organisation approve this request;
    4. As part of approval from specific people email was sent back to organiser to fill up the form about catering requirement, for instance;
    5. Organiser reply's back with specific catering (if any) requirement.
    Is that even possible with Power Automated / Flow?

  7. C S 1 year ago

    Hi April, thanks for this. I tried: replace(replace(body('Get_item')?['Beginning Date'],'-',''),':','') , can't pass validation,got error message, please advice what's wrong if possible. That's great video.

  8. Maurice Vold 1 year ago

    Thank you. Just what I was looking for.

  9. Dan NG 1 year ago

    Thank you for the tutorial!

  10. Michael Luehr 1 year ago

    Hello April – 1st off this was exactly what I needed to finish a project! but I had to modify the ICS text from GitHub as it was missing BEGIN:VCALENDAR
    at the start

  11. Umesh Gaur 1 year ago

    Phenomenal thanks for this video, can you please let me know which list formatting you were using in your video, i search but unable to find : https://github.com/SharePoint/sp-dev-list-formatting/tree/master/view-samples

  12. TX3 REMYDIO 1 year ago

    Hello, i'm stuck at 5:18, i can not find the "compose" component in Data Operation, can you help ? i'm trying cree a csv file instead.

  13. Alonso Pareja 1 year ago

    Thank you.
    My compose action for the ICS file looks like this:
    BEGIN:VCALENDAR
    VERSION:2.0
    BEGIN:VEVENT
    URL: Dynamicontent
    DTSTART:20200502T060000
    DTEND:20200502T063000
    SUMMARY:Tarea 1
    DESCRIPTION: Dynamicontent

    But when it comes to Create file from SP I get the following error:
    Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '2822': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline']['connectionId']' cannot be evaluated because property 'shared_sharepointonline' doesn't exist, available properties are 'shared_office365'. Please see https://aka.ms/logicexpressions for usage details.'.

    Someone has experienced the same? Was wondering if it's 'cause of the Format Dates or something but looks like it's something else…

    EDIT. Good news. Didn't find documentation about this issue but solved it by exporting and importing the flow. Didn't make any changes tho. I have now it working as I was getting the dates depending on the shifts employees where choosing from MS Forms. THANK YOU AGAIN APRIL!

  14. WarshingtonState 11 months ago

    Excellent tutorial, thanks!
    I tweaked April's ICS format to create an Out of Office event (see 3rd line from the bottom):
    BEGIN:VCALENDAR

    VERSION:2.0

    BEGIN:VEVENT

    URL:

    DTSTART:@{outputs('formatStartTime')}

    DTEND:@{outputs('formatEndTime')}

    SUMMARY:@{triggerBody()?['Title']}

    DESCRIPTION: @{triggerBody()?['Description']}

    LOCATION:Online

    X-MICROSOFT-CDO-BUSYSTATUS:OOF

    END:VEVENT

    END:VCALENDAR

  15. agusto xaverius 11 months ago

    Thank you for this tutorial. I also run some sample project base on your tutorial. Here are my sample https://agustox21.wordpress.com/2020/06/01/room-booking-reservation-integration-with-sharepoint-365-power-apps-power-automate-and-ics-file/

  16. Irfan Amin 11 months ago

    The best thing you could do is actually creating all this and showing from start to end instead of just explaining which you have already created. Even there is no info on how you created the SharePoint registration files.

  17. William McCann 11 months ago

    Thanks April, great tutorial, exactly what I was after, and something MS should have had in place, go figure

  18. Sada 9 months ago

    Namaste

    ICS stands for Internet Calendaring and Scheduling and the ICS file extension is used for iCalendar internet standard for to stores events,to-dos, free/busy information and journal entries.

    Thanks.

  19. Sierra Henderson 9 months ago

    Can someone help me with a MS flow question? I keep running into a dead in with creating this flow and was wondering if anyone has any guidance on how to resolve:

    Outcome: Send someone an email with an ics attachment(s), depending on their response to a Forms survey. They can select one or multiple events

    Trigger: Survey response

    The issue I am running into: actually attaching the ics file to the email. I want to send an event from my own calendar. I don't want to create a new event each time because I want to keep track of how many people sign up. I'm cautious of updating the event each time as an alternative because I don't want the existing attendees to get an update every time someone new signs up (unless there is a workaround to this).

    Any suggestions? Thank you so much in advance.

  20. Beshr Al Khateeb 9 months ago

    Hi April ,

    Thanks a lot for the useful video.

    I did exactly as you did but I keep running into an error with the FormatStartTime step: Unable to process template language expressions in action 'FormatStartTime' inputs at line '1' and column '2922': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#replace for usage details.'.

    Now I know why I get this error. It is because of this part in the code: …..body('Get_item')?['Date']…..

    The thing is that this does not seem to return anything (i.e. it's a blank). I tried different things like Start Date, StartDate, Start Time, StartTime but none of that works. On the other hand, EndDate works correctly. Of course, I can remove the FormatStartTime part but then I end up with an empty .ics file in the attachment. Any idea what the correct name should be instead of Date?

    Thank you very much.

  21. TheWalkingSmartie 7 months ago

    Short, simple, straight to the point and well explained. I wish there were more people like you, this one helped me a lot 🙂
    Thanks April.

  22. amy coleman 7 months ago

    Thanks April this was really helpful. I however have ran into an HTML Encoding issue it appears. When the ics is opened the HTML of the description is visible in the body of the file. Anyway for the body of the ics to just be the text, etc instead of the encoded HTML visible?

  23. Miriam Tessmer 5 months ago

    This is exactly what I need (THANK YOU!!)…but I'm having trouble with figuring out how you formatted the list and the "register" button. I looked at the GitHub link for SP List formatting samples but couldn't find anything similar…can you point me in the right direction?

  24. P Bax 5 months ago

    once again you have helped me immensely!. I'm getting less scared or data operation thanks to you! I appreciate you more than you know 🙂

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account