Hogan Assessments Certification Workshop 2026 — Singapore

Before the form goes liveZhafran prepares the country workspaces, email rules, and Excel files.
Registration
ParticipantCompletes the Singapore form
Power AutomateChecks the answers
Microsoft ListsSaves participant and workshop details
The Country PIC works here↓
Daily work
Country PICUpdates payment, Hogan access, and workshop progress
Power Automate + Office ScriptsSends approved emails and prepares the Participant List
Country PICDownloads the latest Participant List
Separate company recordAll country workspaces→Zhafran selects Refresh All→All-countries Excel file
Microsoft FormsCollects each registration1
SharePointProtects Singapore files2
Microsoft ListsGives the PIC online tables3
Power AutomateChecks details and sends emails4
Power QueryUpdates the all-countries Excel file5
Public registration formPrivate Singapore websiteRegistration List and Workshop ListRegistration checks and approved emailsAll-countries Excel update
Example registrationAlex selects two workshopsFoundationAdvanced Interpretation
If everything is in one list
One entry for Alex

Add a separate group of payment, assessment, pre-work, and post-test columns for every workshop.

or
One entry for each workshop

Repeat Alex's contact details, Hogan ID, and Password.

With two lists
Registration List
ParticipantHogan IDPassword
AlexHL000001Temp-4821
Participant details appear once for this registration.
Workshop List
WorkshopPaymentPre-work
Foundation · MayReceivedReceived
Advanced Interpretation · OctoberNot receivedWaiting
Each workshop keeps its own payment and progress.
Participant details stay once for the registration.Workshop payment and progress stay separate.
Example Malaysia pilot SharePoint site reused for the shared country flow, with links to the Registration List, Workshop List, Participant Lists, and Documents
Example image reused from the Malaysia pilot · synthetic information
1 · Microsoft FormsReceive the registration
↓
2 · Power Automate checksLocation · Terms · Data consent · Accuracy · Contact details · Workshop
↓
3 · Registration ListSave the participant details
4 · Workshop ListSave each selected workshop
↓
5 · ParticipantSend a confirmation
6 · Country PICSend a direct link
Example Outlook message to optimalMY@optimal.com.sg with a new Singapore registration and a link to the participant details
Example image reused from the Malaysia pilot · synthetic information
Example Malaysia pilot Registration List image reused for the shared country flow, showing participant contact details, Hogan ID, Password, debrief choice, and Hogan email status
Example image reused from the Malaysia pilot · synthetic information
Before launchZhafran prepares
  • Singapore workspace
  • Access for the Singapore team
  • Email rules
  • Participant List
  • All-countries Excel file
During daily workCountry PIC updates the Registration List
Hogan IDPasswordDebriefRemarks
Country PIC updates the Workshop List
PaymentAssessmentsPre-workPost-testReturned forms
Example Malaysia pilot Workshop List image reused for the shared country flow, showing Alex's workshops paid separately and Linda's two workshops paid together
Example image reused from the Malaysia pilot · synthetic information
Example Power Automate screen checking one workshop payment and the linked participant details before sending that workshop's email
Example image reused from the Malaysia pilot · synthetic information
Outside this automationPIC checks the consultant's schedule→PIC offers time slots→Participant confirms one slot
PIC updateWhat Power Automate doesResult
L2 pre-workPayment is confirmed
Send the approved pre-work email
Email status: SentThe sent time is saved
Debrief keptPIC adds the confirmed time, time zone, and consultant
1 · Create the consultant's Teams invitation2 · Create the participant's calendar invitation
Two different invitationsOne date, one time, and one Teams link
Post-testPIC changes the status to Complete
Check the required details, then send the Thank You email
Email status: SentThe send is recorded
Record onlyPIC updates an assessment or returned form
Save the new status
No email is sentNo approval is required
Example all-countries Participant List in Excel with synthetic rows for Malaysia, Singapore, Hong Kong, China, Japan, and AOC or Virtual
All-countries example · synthetic information · does not start emails
PARTICIPANTCompletes the Singapore form
→
POWER AUTOMATE + LISTSChecks and saves the registration
→
COUNTRY PICUpdates participant and workshop progress
→
POWER AUTOMATE + OFFICE SCRIPTSSends approved emails and prepares the country Excel file
ZHAFRAN + POWER QUERYRefreshes the all-countries Excel file when the company needs it