# Position number alert (Power Automate)

> A working replica of a small Power Automate flow that alerts position control when a staffing request needs a position number, staged on a fictional insurer.

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

Power Automate · Insurance

## Position number alert

Some staffing requests need a new position number or a change to an existing one. This flow emails position control when one of those comes in, and stays quiet for the rest.

-   **Tool**Power Automate cloud flow
-   **Trigger**SharePoint item created
-   **Steps**five

make.powerautomate.com

Run this flow

Plays a quick run of the flow above. Nothing is sent.

1.  01 New staffing request created
2.  02 Recipient set to position control
3.  03 Needs a position number? Yes
4.  04 Job title worked out
5.  05 Email sent to position control

Done in 5 steps: position control hears about it before the posting goes out.

Outlook · Inbox

You’ve got mail

From

HR Staffing <no-reply@algonquinmutual.ca>

To

Position control <position.control@algonquinmutual.ca>

Subject

**HR Staffing Request - Position number needed - Senior Claims Adjuster**

HR Staffing Request

**Position control action required**

A new staffing request needs a new position number or an update to an existing one.

<table style="border-collapse:collapse;font-size:13px;width:100%"><tbody><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Requisition</td><td style="padding:6px 0;color:#222">Senior Claims Adjuster</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Department</td><td style="padding:6px 0;color:#222">Claims</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Division</td><td style="padding:6px 0;color:#222">Property Claims</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">New position # required</td><td style="padding:6px 0;color:#222">Yes</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Update position #</td><td style="padding:6px 0;color:#222">No</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Position #</td><td style="padding:6px 0;color:#222">TBD</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Hiring manager</td><td style="padding:6px 0;color:#222">Owen Clarke</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Submitted by</td><td style="padding:6px 0;color:#222">Nora Bennett</td></tr></tbody></table>

View request

Please do not respond to this auto-generated email.

A working replica of a real Power Automate build, redone in HTML and JavaScript so you can click through it here. Algonquin Mutual Insurance is fictional; all names, people and numbers are illustrative. [Open it full screen](https://tenantcraft.ca/demos/position-number-flow.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

### Triggered by the list, not the app

The flow fires on the list, so it works whichever form created the request.

How to build it

1.  Use **When an item is created** on the staffing request list.
2.  Keep the recipient in a variable at the top, so go-live means changing one value.

02

### Only when a number is needed

A condition checks the two position-number columns. Most requests never send an email.

How to build it

1.  Add a **Condition**: new number required _or_ existing number to update.
2.  Use `coalesce()` in a Compose step, so the job title is never blank in the email.
3.  Send the HTML email to position control and CC the person who submitted it.

## **02**More builds

-   [Power AppsInterview request appA four-step canvas app that collects the interview panel, locations, time slots and candidates, and checks each step before the request can go in.Power Apps · Grocery retail](https://tenantcraft.ca/studio/interview-request-app)
-   [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 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-automate)

(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/position-number-flow · Agent guide: https://tenantcraft.ca/llms.txt · Site map: https://tenantcraft.ca/sitemap-index.xml_
