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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,783)