I am trying to build an app in Power Automate that summarises the meeting times in a o365 calendar and displays the time by category and filtered by date.
One question could be 'Show total time spent on project X from 200901 to 200930
Any hints on where I can begin?
Hi @MatsVJ ,
First use the following code to add three column to calendar events list.
Share
Report
All responses (
Answers (
ClearCollect(colAllEvents,
AddColumns(
Office365Outlook.V4CalendarGetItems("Calendar").value,
"StartDateLocal", // Start date time in local timezone
DateAdd(
DateTimeValue(start),
-TimeZoneOffset(),
Minutes
),
"EndDateLocal", // End date time in local timezone
DateAdd(
DateTimeValue(end),
-TimeZoneOffset(),
Minutes
),
"Duration", // The duration of event
DateDiff(
DateAdd(
DateTimeValue(start),
-TimeZoneOffset(),
Minutes
),
DateAdd(
DateTimeValue(end),
-TimeZoneOffset(),
Minutes
),
Hours
)
))Then add two date picker, and a Label to display the total duration.
Sum(Filter(colAllEvents,StartDateLocal>DatePicker1.SelectedDate, EndDateLocal<DatePicker2.SelectedDate),Duration)
Hope this helps.
Sik
383
