On-the-Job Training in Power Apps
Taking Lock Out Tag Out (LOTO) training from the classroom to the factory floor.
At a Glance
Role: Designed, built and rolled out the training and the Power Apps behind it
Audience: Production operators at a food manufacturing site, delivered by their leaders and me
Format: One-on-one on-the-floor sessions on an iPad, covering content, a practical demonstration, a quiz and a digital sign-off
Tools: Power Apps, Microsoft Lists, Excel, MyOsh, ChatGPT (translation support)
Audience: Production operators at a food manufacturing site, delivered by their leaders and me
Format: One-on-one on-the-floor sessions on an iPad, covering content, a practical demonstration, a quiz and a digital sign-off
Tools: Power Apps, Microsoft Lists, Excel, MyOsh, ChatGPT (translation support)
The Challenge
Lock Out Tag Out (LOTO) training was all theory, delivered in a classroom and in English only, with a quiz at the end. There was no practical component, even though LOTO is a hands-on safety skill. For team members who didn’t speak English, the quiz wasn’t a real test, because they copied answers from each other. There had also been incidents of machines not being locked out. On top of that, there was no LMS, pens and paper can’t go onto the food factory floor, and the training needed proof for audits.
What I Did
I redesigned LOTO as on-the-job training, delivered where the work happens.
On the floor, in their own environment: Trainees learn at the machines they use.
Their language: Each language has its own version of the app. I built Vietnamese and Arabic versions, and Vietnamese was the one needed. All content and quiz questions were translated with ChatGPT and checked by a bilingual speaker before release.
Guided, not left alone: The trainee works through the content while the trainer watches and talks them through it in English.
Show me: The trainee demonstrates locking out a machine, and the trainer checks off each step in the app.
A real quiz: Trainees answer each question and the trainer records the result, with an 80% pass mark
Digital sign-off: The trainer and trainee both sign on the iPad to confirm the training was delivered and understood. I chose digital sign-off because tablets are allowed on the floor and pens and paper aren’t.
Inside the App
Start: The trainee launches the session on the tablet.
Content: Slide-by-slide content, with a menu so the trainer can jump back to any topic.
Practical assessment: The trainer checks off each step as the trainee locks out the machine, covering locating equipment, isolating, documenting and de-isolating.
Quiz: Trainees answer each question and the trainer records the result, with an 80% pass mark
Sign-off: The trainee signs on screen to confirm they completed the training and understand the procedure.
Completion: The result is saved, and the trainee and trainer signatures are recorded.
Behind the Scenes: Where the Data Goes
Each session is saved to a Microsoft List. A second Power App creates the attendance sheet with the signatures, which I export as a PDF and upload to MyOsh as training evidence. The record is then added to the LMS Excel sheet, which links to Training Records without an LMS. The MyOsh upload is manual because Power Automate doesn’t connect to MyOsh.
Picture shows the attendance sheet generated by a second Power App, exported as a PDF and uploaded to MyOsh as training evidence.
What Happened
Safer practice: Before the training there were a few issues with machines not being locked out. After it, there were none.
Leader buy-in: Leaders felt comfortable with the change.
Audit-ready: Every session has a signed record stored centrally.
Reach: about 50 sessions delivered across LOTO and Chemical Safety.
Next: The same approach is ready for other safety training, with Manual Handling next.