A secure digital awards solution designed to replace manual nominations and voting with structured submissions, confidential ballots, eligibility controls, and automated results tabulation.
Power Apps
Power Automate
SharePoint
Excel
Business Problem
Annual recognition nominations and voting were collected manually, which was slow and lacked confidentiality.
Solution
A secure nomination and voting app with anonymized ballots, eligibility rules, and instant tabulation.
Requirements
Nomination intake with eligibility validation
Confidential one vote per person ballots
Automated tabulation and results export
Administrator control over voting windows
Architecture
Power Apps nomination and ballot experience
SharePoint lists with restricted permissions
Power Automate for reminders and result compilation
Excel and Power BI for results reporting
My Role
Defined voting rules with the program committee
Designed the confidentiality and permission model
Developed the application and automation
Supported the live voting window
Challenges
Designed the voting process to preserve ballot confidentiality while maintaining appropriate administrative controls
Prepared the application and automation to support a time-sensitive voting window reliably
Lessons Learned
Clear voting rules and confidentiality controls help build trust in the process and encourage participation
Testing the complete nomination, voting, and tabulation workflow before launch reduces issues during a time-sensitive voting window
Business Impact
Reduced the manual effort required to collect and organize nominations and votes
Automated vote tabulation to make the results process faster and more consistent
Created a more structured and confidential experience for participants and program administrators
Future Improvements
Multi category weighting
Historical results archive
Automated award certificates
Screenshots
Awards nomination and voting experienceVoting results and program analytics
