Unanswered

GetEventsCalendar V2 Filter by Category

(0) Share

Report

Posted on by LauraGrimes123

I am trying to display calendar events from all categories except one - as some employees mark personal events on their work calendar and we do not want this displayed in power apps

The code looks like this:

ClearCollect(
MyCalendarEvents,
Office365Outlook.GetEventsCalendarViewV2(
"Calendar",
Text(
AMDate_4.SelectedDate,
DateTimeFormat.UTC
),
Text(
DateAdd(AMDate_4.SelectedDate,7,TimeUnit.Days),
DateTimeFormat.UTC
)
).value
);

Is their a filter I can use to show the events where the category does not equal Personal?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @LauraGrimes123,

Tyr:

ClearCollect( MyCalendarEvents, Office365Outlook.GetEventsCalendarViewV2( "Calendar", Text( AMDate_4.SelectedDate, DateTimeFormat.UTC ), Text( DateAdd(AMDate_4.SelectedDate,7,TimeUnit.Days), DateTimeFormat.UTC ), First(Categories.Value).Value <> "Personal", ).value );

Was this reply helpful? Yes No
LauraGrimes123 63 on at

Like (0)

Report
Copy link

Link copied!

Hi

This is bringing up errors - received 5 expected 3-4 and Categories is not valid?

Was this reply helpful? Yes No