cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

outlook calendar meetings issue

Hi

 

I am trying to get calendar meetings which ended until current localtime. I am collecting 1 week old meetings and collecting top 200. Below is the formula. I dont see todays meetings and sometimes i see todays meeting but not all meetings. I see some kind of time conversion issue. Any suggestions would be helpful

 

Filter(Office365.V4CalendarGetItems(varCalendarID,{'$top':500}).value,DateTimeValue(start)>=Today()-7 && DateTimeValue(end) <=Now()),"start",Descending)

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Supplier
Solution Supplier

Re: outlook calendar meetings issue

The Now function returns current date and time, that's why you sometimes see some of the calendar items, because it depends what time you run the query. use the Today  function instead, and change your formula to < DateAdd(Today(),1) this will make sure that your items are less than tomorrow 12:00 AM

 

--------------------------------------------------------------------

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

View solution in original post

4 REPLIES 4
Highlighted
Solution Supplier
Solution Supplier

Re: outlook calendar meetings issue

The Now function returns current date and time, that's why you sometimes see some of the calendar items, because it depends what time you run the query. use the Today  function instead, and change your formula to < DateAdd(Today(),1) this will make sure that your items are less than tomorrow 12:00 AM

 

--------------------------------------------------------------------

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

View solution in original post

Highlighted
New Member

Re: outlook calendar meetings issue

Thanks for solution. It solved almost except in one scenario. Reason i was using Now() not to retrieve meeting which was current happening. With your solution i was able to get meetings which were missing and also seeing meeting currently happening. Any other way of excluding meeting which did not end based on current time.

 

Thanks

Highlighted
Solution Supplier
Solution Supplier

Re: outlook calendar meetings issue

and if you need to see the appointment up to current time (Date and Time), you need to convert the datetime from UTC to your current time. The outlook connector, returns all dates in UTC format. you can change them to the user local time:

 

my items are in a Gallery, that's why I'm using ThisItem.

DateAdd(DateTimeValue(ThisItem.start), -TimeZoneOffset(DateTimeValue(ThisItem.start)), Minutes)

Highlighted
New Member

Re: outlook calendar meetings issue

Thanks for idea and driving me in correct path. i kept below formula and it seems to be working. i still have to do extensive testing but results seems to be promising

 

DateAdd( Now(), TimeZoneOffset(), Minutes)

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (4,170)