Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only

Create item in a Group Calendar in Outlook 365 from Excel spreadsheet

  • 1.  Create item in a Group Calendar in Outlook 365 from Excel spreadsheet

    Posted Feb 14, 2022 10:24 AM
    Hello,

    I have an Excel spreadsheet with employee names, start date and end date.  I have the flow that will read the individual lines in the Excel spreadsheet and place that information in a calendar in Outlook.  The problem is that it is my personal calendar in Outlook.  I need the information to go into a Group Calendar to be displayed on a SPO team site.  The action in the flow Create Even (V4) is requesting a Calendar id and and I can not find the Calendar id for the Group Calendar PTO.  I tried a couple of PowerShell suggestions but the id's returned Power Automate doesn't like for the Calendar id field.  Any idea on how to locate a specific calendar id for a group calendar?

    Thanks in advance for the help.

    Kind regards,

    ------------------------------
    John Heck
    ------------------------------