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.
- ToolPower Automate cloud flow
- TriggerSharePoint item created
- Stepsfive
- 01 New staffing request created
- 02 Recipient set to position control
- 03 Needs a position number? Yes
- 04 Job title worked out
- 05 Email sent to position control
Done in 5 steps: position control hears about it before the posting goes out.
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
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.
Want help building yours? hello@tenantcraft.ca
01How 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
- Use When an item is created on the staffing request list.
- 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
- Add a Condition: new number required or existing number to update.
- Use
coalesce()in a Compose step, so the job title is never blank in the email. - Send the HTML email to position control and CC the person who submitted it.
02More 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
- 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
- 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
- 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
- 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
- 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