cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alicekings
Helper II
Helper II

Meeting Capture Desired time range

I try to test template Meeting Capture on Power App on Function Desired time range but it didn't work
for example I try to set meeting on 5:00 PM - 6:00 PM on Meeting duration 30 Min it should show only 5:30 - 6:00 PM or 5:00 - 5:30 but it end up it show all the time on that day like picture below

Alicekings_0-1614241766532.png

 

On select in button Find Available times

Alicekings_1-1614241865463.png


Items 

Alicekings_2-1614242005267.png

 

Any suggestion to make it show only time that I selected
Thank you for advice 🙂

13 REPLIES 13
v-xiaochen-msft
Community Support
Community Support

Hi @Alicekings ,

 

Could you tell me:

What is your time zone?  Is it '+7' ?

 

If you choose from 9 a.m. to 10 a.m,you should use 540+420(// 60*7) instead of 540 and use 600+420(// 60*7) instead of 600.

 


Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Dear @v-xiaochen-msft 

What is your time zone?  Is it '+7' ?
Yes is  UTC+7

I try it but it end up same Result
Screenshot_10.png

 

v-xiaochen-msft
Community Support
Community Support

Hi @Alicekings ,

 

The same formula works in my environment. Please refer to the picture below:

v-xiaochen-msft_0-1614586513018.png

 

v-xiaochen-msft_1-1614586513020.png

 

 

 

 

Please check if there is any difference.

For example: you could try to choose another working day.

 

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

Dear @v-xiaochen-msft 

I try to Change the time value on start and end it didn't work
I try to Change another working day it still didn't work 😥
Screenshot_1.pngit didn't Collect anything,So I Try to Change Formula back like this
Screenshot_9.png

 (Value of the MeetingStartRange & MeetingEndRange Is the same value as I enter 540 & 600)
The result is the same it look like it can't show anything If i seleted value of Start&End under 3:00 PM or 900
It can't Collect anything 


but if we selecte anything that more than 900 or 3:00 PM it show like this
Screenshot_7.png

 

Screenshot_8.png

 

I have no idea what going on here
Thank you for your kind advise 😊

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,511)