Building a summarising app

(0) Share

Report

Posted on by MatsVJ

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-siky-msft on at

Like (0)

Report
Hi @MatsVJ ,

First use the following code to add three column to calendar events list.

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

Was this reply helpful? Yes No