How to get events calender with multiple date?

(0) Share

Report

Posted on by AndiNoya

Hi All,
I'm Trying to get event calender using Office365.GetEventsCalendarViewV2 function from multiple date, but always get a null value.
GetRecurDatesCollection

Result

8/31/2020

9/1/2020

Formula:

ClearCollect(
 getExchangeroom,
 ForAll(
 GetRecurDatesCollection,
 Filter(
 Office365.GetEventsCalendarViewV2(MyCalendar, 
 Text(DateAdd(DateTimeValue(Result), -1, Hours), UTC), 
 Text(DateAdd(DateTimeValue(Result), 1, Days), UTC)
 ).value,
 Organizer=MyName.Mail
 )
 )
);

but if I try this formula without using the ForAll function, it can return the actual value

ClearCollect(getExchangeroom,
 Filter(
 Office365.GetEventsCalendarViewV2(MyCalendar, 
 Text(DateAdd(DateTimeValue("8/31/2020"), -1, Hours), UTC), 
 Text(DateAdd(DateTimeValue("8/31/2020"), 1, Days), UTC)
 ).value, 
 Organizer=MyName.Mail
 )
);

Any help is appreciated. Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What if you try one of these:
ForAll(GetRecurDatesCollection,
Collect(getExchangeroom,
Filter(
Office365.GetEventsCalendarViewV2(MyCalendar,
Text(DateAdd(DateTimeValue(Result), -1, Hours), UTC),
Text(DateAdd(DateTimeValue(Result), 1, Days), UTC)
).value,
Organizer=MyName.Mail
)
)
);

ForAll(GetRecurDatesCollection,
Collect(getExchangeroom,
Office365.GetEventsCalendarViewV2(Filter(MyCalendar, Organizer=MyName.Mail),
Text(DateAdd(DateTimeValue(Result), -1, Hours), UTC),
Text(DateAdd(DateTimeValue(Result), 1, Days), UTC)
).value
)
);

Was this reply helpful? Yes No