10-26-2020 05:19 AM
I have created successfully a flow which I would like to share and may be useful for some.
Want to report all working hours to my manager. As it is headache to maintain daily work in timesheet, I log my hours within my outlook calendar events. Also, there are meeting invites which should be added automatically in timesheet. I wanted to copy all these meetings and the work which I have logged in the outlook event in excel sheet so that I can prepare it as billable hours to my manager.
Thus, overall it is very basic use case. Just copies all the calendar events to the excel sheet. Within excel sheet, I have small formula to calculate the hours and then bills those hours as billable hours to my manager. 👍
Get Calendar events for a particular month
Loop through events and save them to excel sheet
NOTE: the right column - Subject, Start time, End time, etc. is coming from the existing excel sheet - Timesheet table1 which I had prepared already. Formula for formatting date: formatDateTime(item()['start'],'d.M.yy hh:mm tt')
I hope this flow helps someone.
I tried your flow and it runs successfully but the excel sheet is still empty I don't know why