# Interview request app (Power Apps)

> A working replica of a Power Apps form that collects everything talent acquisition needs to book interviews, staged on a fictional grocery chain.

[← The Studio](https://tenantcraft.ca/work)

Power Apps · Grocery retail

## Interview request app

Talent acquisition can’t book an interview until they have the panel, the locations, the time slots and the candidates. This form asks for all of it in four steps and won’t submit until every step is complete.

-   **Tool**Power Apps canvas app, as a SharePoint list form
-   **Users**hiring managers and the talent acquisition team
-   **Modes**new, edit and view, in one form

apps.powerapps.com/play/interview-coordination

A working replica of a real Power Apps build, redone in HTML and JavaScript so you can click through it here. Maple & Crate Market is fictional; all names, people and numbers are illustrative. [Open it full screen](https://tenantcraft.ca/demos/interview-request-app.html).

Want help building yours? [hello@tenantcraft.ca](mailto:hello@tenantcraft.ca)

## **01**How it works

Every build here sticks to standard connectors like SharePoint, Outlook and Approvals, so it runs on the Microsoft 365 licences you already pay for.

01

### Four steps with a tracker

Position, location, dates and candidates, each on its own step. The tracker shows what is still missing.

How to build it

1.  Build one screen with four containers and show one at a time from a `varStep` variable.
2.  Draw the tracker as four circles whose fill depends on whether that step passes its checks.
3.  Keep a count of finished required fields in the footer, for example _5 of 7 complete_.

02

### Department, then division

The division list only shows divisions that belong to the department picked above it.

How to build it

1.  Filter the division dropdown on the selected department.
2.  Clear the division when the department changes, so a stale value can’t be saved.

03

### Interview slots that must be complete

Primary and alternate dates sit in two editable galleries. A half-filled row blocks the next step.

How to build it

1.  Hold each set of rows in a collection, with _Add row_ calling `Collect`.
2.  Validate every row for type, date, time and room before the step counts as done.
3.  Remind people under the table that coordination needs five business days’ notice.

04

### New, edit and view modes

The same form handles a new request, changes to an open one, and a read-only view.

How to build it

1.  Read `SharePointForm1.Mode` and switch labels, buttons and locked fields from it.
2.  Show the talent acquisition section only to that team. Tick _TA Team member_ in the demo to see it.
3.  Submit with `SubmitForm`, so the list stays the one record of every request.

## **02**More builds

-   [Power AutomateInterview status emailsOne flow that watches the interview request list and sends the right email for each status, in place of two old SharePoint Designer workflows.Power Automate · Grocery retail](https://tenantcraft.ca/studio/interview-notifications-flow)
-   [Power AppsHR staffing requestA checklist, then a stepped request form. The approval scenario decides who signs off, and submitting starts the staffing approvals flow.Power Apps · Insurance](https://tenantcraft.ca/studio/staffing-request-app)
-   [Power AppsContractor insurance questionnaireProject managers answer 21 yes-or-no questions about a job and get the insurance clauses for the contract, ready to paste.Power Apps · K-12 education](https://tenantcraft.ca/studio/contractor-insurance-app)
-   [Power AutomateStaffing request approvalsFour approval routes in one flow. Who signs off depends on the kind of request, and every decision is written back to the list with a dated history.Power Automate · Insurance](https://tenantcraft.ca/studio/staffing-approval-flow)
-   [Power AutomatePosition number alertA small flow that tells position control when a new staffing request needs a position number created or changed.Power Automate · Insurance](https://tenantcraft.ca/studio/position-number-flow)
-   [Power AutomateBudget adjustment approvalPick a budget file in the library, send it for approval, and the flow stamps the outcome on the file and emails the finance leads.Power Automate · Financial services](https://tenantcraft.ca/studio/budget-approval-flow)

[All builds →](https://tenantcraft.ca/work#power-apps)

(Your process)

## Still running it on email?

[Book a discovery call](https://tenantcraft.ca/contact) [How projects work](https://tenantcraft.ca/services)

---

_Canonical HTML: https://tenantcraft.ca/studio/interview-request-app · Agent guide: https://tenantcraft.ca/llms.txt · Site map: https://tenantcraft.ca/sitemap-index.xml_
