Then use Update row to update the item, mainly to update the Calendar id, which is filled with the Daynamic content- Id from the Outlook-Create event action output. You could consider using the following method: it is recommended to add a new column in Excel, such as Calendar id.ġ.Use Excel-Get rows action to get all the existing items in the Excel file, then configure Outlook-Create event action, use the Dynamic content output from the Get rows action to populate the field as you described.
If not, please provide more explanation.ġ.First synchronize the existing rows in the Excel file to Calendar.Ģ.If an item in Excel changes, the event created in Calendar based on this item should also be updated at the same time.ģ.The new item added in the Excel file will also be synchronized to Calendar. Hi sort out your requirements like this, please see if it meets your expectations. This file would be updated by other processing inside Excel. Here is a link to the sample file I would like to sync to the calendar.
#How to add outlook calendar to google calendar 2018 how to
It looks like Flow can acheive this I just need to know where and how to start Start Date is Calculated Start Date and Finish Date is Due Date. The Event Title should be a combination of the To Do List Name, Ref # and Status The file will be maintained with Items staying in the same rows. Updates could be made to existing rows that need to be updated in the Calendar
I have an Excel file that can be stored in OneDrive and I want to be able to sycnchronise the items in the Excel file with a Google Calendar or Outlook Calendar is that possible.only need to Send from Excel to Calendar.not back the other way.