Forum Discussion

Joaosantos489's avatar
Joaosantos489
Copper Contributor
Mar 03, 2022
Solved

Condition between dates on MS Forms

Hey Guys!   I am building a vacation forms for my company.  Through a workflow the data will go to a Microsoft List.   Link to the form: https://forms.office.com/r/XSie2jVp0E My question ...
microsoft forms
microsoft lists
  • RobElliott's avatar
    RobElliott
    Mar 03, 2022

    Joaosantos489 you would need to do this with a flow in Power Automate, but it could only evaluate if the dates have already been booked out after the form has been submitted. There is no way for the form to check the dates. In your get items action, if the date has been booked out then an email would go back to the responder telling them that. If it's not then the flow could create the item in the list.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

RobElliott's avatar
RobElliott
Silver Contributor
Mar 03, 2022

Joaosantos489 you would need to do this with a flow in Power Automate, but it could only evaluate if the dates have already been booked out after the form has been submitted. There is no way for the form to check the dates. In your get items action, if the date has been booked out then an email would go back to the responder telling them that. If it's not then the flow could create the item in the list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Resources