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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Blocking an option to ...
Power Automate
Unanswered

Blocking an option to choose time slot in forms if the calendar is busy

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello team,

I created a flow: When a new response is submitted - create an event and send meeting request for 30 minutes - to me and to responder.

Now I winder, how to synchronize my Outlook calendar with forms to block time options to choose, if I have on the same time some meetings.

OleksiyKotikov_1-1684320797538.png

 


Second option could be also, to block e.x. if someone already chose 21th of May on 9:30, to block this option for the same date and time in forms.

OleksiyKotikov_2-1684320809288.png

 


Best Regards
Oleksiy Kotikov

Categories:
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    With MS Forms, it's not possible. If the form is for users all in your organization, you can use SharePoint as the data source and create a form in PowerApps. In that case Power Automate flow is not necessary as well. But if external users will respond to this form, using flow is the only choice. So, you can add a get events action from your calendar and in a Condition control to compare the submitted time slot with all the existing events on that day. 

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-jefferni ,
    I will be using that flow only for all users in my organization.
    So, if it is for all users in my organization, I can create a SharePoint database which will have the same meetings as my calendar has and will block forms time options in case if I have a meetings ?

    Best regards
    Oleksiy Kotikov

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    It will use SharePoint list calendar view, which could not sync with your Outlook calendar easily. There would be other limitations, such as users will be able to see all items in this list, so you need to set item level permission, and you need to customize this list form in PowerApps, prevent users from submitting the form when asked meeting duration conflicts with existing meetings. 

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-jefferni ,

    ok, it is possible at least to block the option on the same date and time in Forms ?
    for example I chose 23th May and 9:00 and I want to have this option in Forms to be blocked
    I think this will be enough

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Yes, you can reset the date pick and time dropdown control to default value if the selected date time is within a meeting duration. 

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @v-jefferni 

    Could you guide me how can I do it ?

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    In a customized PowerApps form for the SharePoint list (it should include a Date only column and a start time column), you can set OnSelect of the submit button, if yes, reset the DatePicker and Hour/Minute dropdowns and also push a notification to user:

    If(
     IsBlank(
     LookUp(
     YourList, 
     DatePicker.SelectedDate = Date
     &&
     ((Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0) >= Start 
     && 
     Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0) < DateAdd(Start,30,Minutes)) 
     || 
     (
     DateAdd(Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0),30,Minutes) >= Start 
     && 
     DateAdd(Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0),30,Minutes) < DateAdd(Start,30,Minutes)
     )
     ))
     ),
     SubmitForm(FormName),
     Reset(DatePicker);Reset(HoursDropdown);Reset(MinutesDropdown);
     Notify("Selected Date and Time is busy/unavailable, try some other time",NotificationType.Warning)
    )

     

    Best regards,

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard