Time Off Request — House Clerk's Office

Form Settings

Manage approvers and integration

Approver List Source

Not configured

Enter a Read API URL below to pull approvers from SharePoint automatically.

SharePoint Integration

Read API URL (Power Automate — returns manager list)

Submit Webhook URL (Power Automate — sends approval email)

SharePoint Approvers List URL (link for admins to edit)

Local Approvers (Fallback) Used when no Read API is set

These approvers are used if the Read API URL is empty or unreachable. When SharePoint is connected, this list is ignored.

NameEmail

Power Automate Setup

Flow 1 — Read Approvers (returns the SharePoint list)

Create → Automated cloud flow
Trigger: When an HTTP request is received — set Method to GET
Action: Get items (SharePoint) → Site: your SP site, List: TimeOffApprovers
Action: Select (Data Operations) → Map: name = Title, email = Email
Action: Response → Status: 200, Body: @{body('Select')}
In Response, add Headers:
Access-Control-Allow-Origin: *
Content-Type: application/json
Copy the HTTP GET URL → paste into Read API URL above

Flow 2 — Submit Request (sends approval email)

Trigger: When an HTTP request is received — paste this schema:

{"type":"object","properties":{"employeeName":{"type":"string"},"approverName":{"type":"string"},"approverEmail":{"type":"string"},"startDate":{"type":"string"},"startTime":{"type":"string"},"endDate":{"type":"string"},"endTime":{"type":"string"},"timeOffTypes":{"type":"string"},"mixedBreakdown":{"type":"string"},"extendedMedical":{"type":"string"},"coveragePlan":{"type":"string"},"submittedAt":{"type":"string"}}}

↑ Click to copy

Action: Send an email (V2) — To: approverEmail, Subject: Time Off Request – [employeeName]
Copy the HTTP POST URL → paste into Submit Webhook URL above

SharePoint List: TimeOffApprovers

Create a list in your SharePoint site with two columns:

Title — rename the default Title column to Name
Email — Single line of text

Employee Information

Employee Name *

Please enter your name.

Time Off Approver *

Please select your approver.

Time Off Details

Start Date *

Start date is required.

End Date *

End date is required.

Start Time (partial day only)

End Time (partial day only)

Time Off Type *

Please select at least one type.

Extended or Medical Leave *

Please select Yes if either applies:
• You are taking 10 or more workdays off
• You are taking 3 or more days for a medical procedure (for yourself or a family member in your care)

Yes

Please select Yes or No.

Member Coverage Plan

Confirm your coverage arrangements before submitting. Your approver will receive this information with your request.

Coverage Details *

Please describe your coverage plan.