April 24, 2020

Ease Event Management with Power Apps

Business Case:

Our client, a multinational technology company, organizes an annual internal expo with numerous showcase events. Thousands of employees attend the events and the manual process of tracking attendance, sending acknowledgments, and receiving feedback was time consuming.

Our Solution:

We created a Power Apps-based solution that used Microsoft Cognitive Services for natural language processing (NLP) and image processing, Logic Apps for automation, Microsoft Teams for post event discussions, and Power BI for reporting insights.
Figure 1: Solution architecture
We built a check-in app that uses mobile devices’ camera to capture the identification badge of each participant. The captured images are stored in an Azure Blob. An Azure logic app reads the image content utilizing Optical Character Recognition (OCR) API to update attendance records. After the event, notifications are sent to attendees via Teams to complete a feedback survey using a Flow Bot. The Feedback App reports the survey responses to determine the Customer Satisfaction (CSAT) score of the event.

Multiple checkpoints incorporated in the system ensure authentication. All attendees’ Teams and mailing details are securely stored in a database for the period of the event. While authentication occurs through Azure AD, experience owners can use their mobile phones to access information through Power Apps.

The app provides two separate interfaces for experience owners (employees) and event organizers (admins).

  Check-in app provides experience owners with a list of planned events and allows them to mark attendance. Feedback tab allows them to provide feedback based on experience area and showcase details.
 Admin app provides control over the events being organized. Users can manage attendance changes by searching for unidentified/inappropriate images of scanned badges. 

Figure 2: Application screenshots

Business Outcomes:

The app increased the ease of capturing the event attendance. Our client used session attendance information to evaluate effectiveness. Also, in-depth analysis on end user feedback helped the client identify areas of improvement.


    Developed low-code, enterprise-grade solution with minimal time to market
    Optimized attendance tracking and feedback management
    Empowered admins and organizers to understand users and improve event impact
    Reduced manual error