Hi all,
I have created successfully a flow which I would like to share and may be useful for some.
Use case:
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. 👍
FLOW setup:
Overview
OVERVIEW
Fetch Outlook calendar eventsGet Calendar events for a particular month
Save to excel sheet
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')
Further improvements
- Currently, I created it as manual trigger. I will work on it to make it to run automatically every month and mail me the excel sheet so that I can review and then finally submit to my manager.
- Cancelled events are also added to timesheet, I will remove them as well
- May be add only the calendar events ones with some categories
I hope this flow helps someone.
Regards,
Nirav
