PTO request system in Microsoft Lists that factors in an employee’s work schedule

Question

PTO request system in Microsoft Lists that factors in an employee’s work schedule

Wankowicz, Requell 0

Hi,

I am setting up a PTO (Paid Time Off) request system in Microsoft Lists that factors in an employee’s work schedule which then populates to a secondary list in which I use the calendar view.

Origins is a MS Form with a few Automations after the form is submitted is goes to list #1 for manual approval. see below

User's image

After approval the entry will go to another list in which I use the Calendar view.

So far so good. I would like to incorporate the work schedule ex. staff #1 works Tuesday - Saturday. For a consistent PTO request staff #1 can request Tuesday-Tuesday off as a single request due to consecutive days. I would like the process to only add the work days that are within the staff work schedule.

I made another MS List with staff work schedule.

User's image

This is where I get stuck.

I've tried various flows and cannot figure it out.

Help is much appreciated. Thank you in advance.

1 answer

Your answer

Answer 1

Viego An 8,610 Microsoft External Staff Moderator

Dear @Wankowicz, Requell,

Thank you for reaching out to the Microsoft Q&A forum. I am happy to assist you.

For your specific scenario, I would like to kindly let you know that this forum mainly focuses on Microsoft 365 business products and basic troubleshooting. Because your question involves advanced automation and workflow design, the most suitable place to receive accurate and specialized guidance is the Power Platform Community or the Microsoft Tech Community.

These communities are actively supported by experts in Power Automate, Microsoft Lists, and complex workflow logic, and they will be able to provide more tailored and in‑depth assistance.

My sincere apologies for redirecting you to another forum. This step is necessary to ensure you receive the fastest and most precise help from the specialists who handle advanced automation scenarios. As a forum moderator here, my role is limited to general guidance, and I want to make sure you get the best possible support for your case.

If you need any further assistance, feel free to reach out. I am here to help. Thank you very much for your understanding and your cooperation.

Wankowicz, Requell 0 Reputation points

2026-01-23T00:35:08.3+00:00

@Viego An thank you so much for your prompt response and guidance. Much appreciated.
Viego An 8,610 Reputation points Microsoft External Staff Moderator

2026-01-23T04:31:30.25+00:00

Hello @Wankowicz, Requell,

Thank you for your kind words and your appreciation.

If you have found any helpful guidance, please feel free to share it here so that other users with the same requirements can access useful information more quickly.

If you found my answer helpful in directing you to the appropriate support channel, please click “Accepted Answer” and kindly give it an upvote.

If you have any follow‑up questions, simply click “Comment” to continue the discussion.

If you need any further assistance, please do not hesitate to reach out. I am here to help.

Thank you very much for your understanding and cooperation.

Share via

PTO request system in Microsoft Lists that factors in an employee’s work schedule

1 answer

Your answer