Forum Discussion
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 is: Is there any way to "link" the forms to the list and reserve that period of time so that the next user can´t select it.
Example:
John Chooses vacation between 20/03/22 - 25/03/22
So, when Edward fills the form and chooses, 22/03/22 - 24/03/22 it won´t be avaliable
Is there any way to do this condition?
Thanks.
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
1 Reply
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