Samuel Smiths Contractor Certificate Distribution

Copies of contractor certificates are sent to samuelsmithcertificates@ebm-ltd.co.uk and are saved to a shared Dropbox folder as per the site and contractor type

The brewery and contractors will send their certificates to the samuelsmithcertificates@ebm-ltd.co.uk shared mailbox
The power automate flow is watching the inbox for this email and distributing the attachment to the correct Dropbox directory as per the contractor trigger word and site identifier in the subject of the email

Open Power Automate Flow

Open Dropbox Folder (SHARED)

Subject Trigger Words:

Below are the trigger words for each contractor type:
Note: The subject is NOT case sensitive

Pest Control

• PEST
• TACTICAL ENVIRONMENTAL SERVICES LTD - (Name of Contractor in subject as not been including PEST)

Duct Cleaning

• DUCT

Fire Alarms

• ALARM

Emergency Lighting

• EMERGENCY
• LIGHTING

Fire Extinguishers

• EXTINGUISHER

Water Sampling

• WATER

PAT Testing

• PAT

Asbestos

• ASBESTOS

Fire Risk Assessment

• FIRE RISK

Risk Review

• RISK REVIEW

EICR Testing

• EICR
• ELECTRICAL INSTALLATION CONDITION

Food Safety

• FOOD

6-Letter Site Identifiers:

Site Identifiers Spreadsheet

Notes:

• If there are multiple attachments with the same name in one email, the first attachment will be saved

  • The email will not be moved to the processed folder in this scenario

• If multiple emails are sent for the same contractor, site and file name, only the first email will be processed

  • The other emails will not moved to the processed folder