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 🙂

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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.

View solution in original post

@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.

 

View solution in original post

13 REPLIES 13
gabibalaban
Super User II
Super User II

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 !

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

Alicekings_0-1614243565321.pngAlicekings_1-1614243597824.png


Thank for your advice 😊

v-xiaochen-msft
Community Support
Community Support

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.

View solution in original post

@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.

 

View solution in original post

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

 

 

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

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

v-xiaochen-msft
Community Support
Community Support

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

Dear @v-xiaochen-msft 

I try your formula like the picture

Screenshot_9.png

 

but it didn't show anything

Screenshot_8.png

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

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (17,465)