{"id":15697,"date":"2021-08-06T08:00:28","date_gmt":"2021-08-06T15:00:28","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/choice-aviation-modernizes-cargo-handling-operations-using-microsoft-power-platform\/"},"modified":"2025-06-11T07:53:07","modified_gmt":"2025-06-11T14:53:07","slug":"choice-aviation-modernizes-cargo-handling-operations-using-microsoft-power-platform","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/choice-aviation-modernizes-cargo-handling-operations-using-microsoft-power-platform\/","title":{"rendered":"Choice Aviation modernizes cargo handling operations using Microsoft Power Platform"},"content":{"rendered":"

Choice Aviation Services<\/a> is a US-based international airline cargo company that offers a full range of logistics services, including freight handling, warehouse storage, import\/export processing, and security. Citizen developer Mozart Ramos Junior leveraged Microsoft Power Platform to advance his career, deliver greater operational efficiency for Choice Aviation Services, and raise the bar on cargo handling industry standards.<\/p>\n

Read the full story: https:\/\/aka.ms\/PowerPlatform\/ChoiceAviation<\/a><\/strong><\/p>\n

\n

Solution overview<\/h2>\n

The Choice Aviation team needed to transition operations from manual, paper-based processes to digital, starting with a warehouse that they acquired and needed to update \u2014 just weeks before a scheduled opening. The company leveraged Power Apps and Power Automate to automate outdated business operations and used Power BI for real-time business intelligence data reporting.<\/span><\/p>\n<\/div>\n

The solution architecture that Mozart and Choice Aviation built includes the following steps:<\/p>\n

    \n
  1. Customer enters package details using Power Apps kiosk.<\/li>\n
  2. Customer gets SMS receipt, sent using Power Automate and the out-of-box Twilio connector.<\/span><\/li>\n
  3. Agent manages the customer queue using Power Apps connected to Azure SQL.<\/span><\/li>\n
  4. Customer gets a text message when agent is ready and dock door is assigned.<\/span><\/li>\n
  5. An email is sent to the airline with the package status.<\/span><\/li>\n<\/ol>\n

    \"Solution<\/p>\n

    High level solution architecture<\/em><\/p>\n

    The end solution resulted in a self-service touchscreen check-in experience, streamlined dock door management, and dashboards with real time performance metrics. Not only have paper-based processes been eliminated, significantly reducing customer engagement times, but Power Apps has also helped improve freight processing times by over 80 percent.<\/p>\n

    The initial Power Platform solution ultimately led to the creation of Choice’s Eco Operational System (EOS)\u2014an integrated system of over 17 Power Platform applications. The expanded system does even more to unify and display multiple sources of customer and operational data and streamlines business processes, and truly is a one-of-kind logistics system that is setting new standards of efficiency for the industry.<\/p>\n

    \"Left:<\/p>\n

    Left: Kiosk for warehouse delivery check-ins, replaced a paper-based process; Right: Choice Aviation’s integrated ‘Eco Operational System’.<\/em><\/p>\n

    \"Screenshots<\/p>\n

    A mobile app built using Power Apps provides agents with a paperless tool for processing freight directly on the warehouse floor.<\/em><\/p>\n

    \"Screenshot<\/p>\n

    Power BI dashboards provide agents and managers with real-time telemetry on freight processing times based on data from the integrated Power Platform system.<\/em><\/p>\n

    Summary of benefits<\/h2>\n