web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Meeting Capture Desire...
Power Apps
Answered

Meeting Capture Desired time range

(0) ShareShare
ReportReport
Posted on by Alicekings 145

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 🙂

Categories:
Building Power Apps
I have the same question (0)
  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,270 Moderator on at

    Hi @Alicekings ,

    I don't think that "+1" is ok there ....The app will search available times as hours from Start to End (which is the day after). So the available times from tomorrow will be also shown. 

     

    gabibalaban_0-1614242898095.png

     

    Hope it helps !

  • Alicekings Profile Picture
    Alicekings 145 on at

    Dear @gabibalaban  I try remove that but it still didn't work

    Alicekings_0-1614243565321.pngAlicekings_1-1614243597824.png


    Thank for your advice 😊

  • Verified answer
    v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @Alicekings ,

     

    Please try this formula:

    ClearCollect(MeetingTimes,Office365Outlook.FindMeetingTimes({MaxCandidates:15,MinimumAttendeePercentage:1,MeetingDuration:30,Start:DateAdd(DatePicker1.SelectedDate,MeetingEndRange.SelectedText.Minutes+Your time zone,Minutes),End:DateAdd(DatePicker2.SelectedDate,MeetingEndRange.SelectedText.Minutes+Your time zone,Minutes),RequiredAttendees:"your email",IsOrganizerOptional:false}))

     

    For example : If I'm in china .My time zone is +8.

    ClearCollect(MeetingTimes,Office365Outlook.FindMeetingTimes({MaxCandidates:15,MinimumAttendeePercentage:1,MeetingDuration:30,Start:DateAdd(DatePicker1.SelectedDate,MeetingEndRange.SelectedText.Minutes+480,Minutes),End:DateAdd(DatePicker2.SelectedDate,MeetingEndRange.SelectedText.Minutes+480,Minutes),RequiredAttendees:"your email",IsOrganizerOptional:false}))

     

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

  • Verified answer
    CU-18081211-6 Profile Picture
    CU-18081211-6 9,270 Moderator on at

    @Alicekings,

    I took a deeper look to this problem. This is what worked for me:

    ClearCollect(
MeetingTimes,
AddColumns(
Office365Outlook.FindMeetingTimes(
{
MaxCandidates: 30,
MinimumAttendeePercentage: 1,
MeetingDuration: Value(MeetingDurationSelection.Selected.Minutes),
Start: DateAdd(
DatePicker1.SelectedDate,
MeetingStartRange.Selected.Minutes,
Minutes
),
End: DateAdd(
DatePicker1.SelectedDate,
MeetingEndRange.Selected.Minutes,
Minutes
),
RequiredAttendees: Concat(
FollowUpMeetingAttendees,
userPrincipalName & ";"
)
}
).MeetingTimeSuggestions,
"StartTime",
MeetingTimeSlot.Start.DateTime,
"EndTime",
MeetingTimeSlot.End.DateTime
)
);​

     

    gabibalaban_0-1614246712795.png

    It seems that some parameters type expected by Office365Outlook.FindTimesMeetings() function have changed since the app was posted.

     

  • Alicekings Profile Picture
    Alicekings 145 on at

    Dear @gabibalaban  Sorry for late reply

    To day I try to run your formula but it didn't show anything

    Alicekings_0-1614574470016.png
    But went i select it all day

    All day.png
    It show begin at 03:00 PM only no matter what day or what time I selected

    Screenshot_1.png

     This is My formula on Button now

    Thank for your advise

     

     

  • Alicekings Profile Picture
    Alicekings 145 on at

    Dear @v-xiaochen-msft  Sorry for late reply

    I Try out your formula
    But it didn't show anything under 3:00 PM
    Screenshot_2.png

     

    And I try  3:00 PM - 5:00 PM it show up like this
    Screenshot_4.png

     

    This is my formula :
    Screenshot_5.png

     

    Did i do anything wrong ?
    Thank you for your advise

  • Alicekings Profile Picture
    Alicekings 145 on at

    @gabibalaban  Did I do anything wrong ?
    Thank you for you kind advise

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @Alicekings ,

     

    Could you tell me:

    What’s the value of ‘MeetingStartRange.selected.Minutes’?  

    What’s the value of ‘MeetingEndRange.selected.Minutes’?  

     

    If you choose from 9 a.m. to 10 a.m, the value of ‘MeetingStartRange.selected.Minutes’ should be 540(9*60) and the value of ‘MeetingEndRange.selected.Minutes’ should be 600(10*60).

     

    Please change ‘MeetingStartRange.selected.Minutes’ and ‘MeetingEndRange.selected.Minutes’ to 540 and 600 respectively and let me know the result.

     

    Best Regards,

    Wearsky

  • Alicekings Profile Picture
    Alicekings 145 on at

    Dear @v-xiaochen-msft 

    I try your formula like the picture

    Screenshot_9.png

     

    but it didn't show anything

    Screenshot_8.png

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans