The Stairway to Heaven Badge – Ascending with Microsoft Cloud APIs

🪜 The Stairway to Heaven Badge – Ascending with Microsoft Cloud APIs 🌥️✨

We embarked on a cloud-powered journey, skillfully combining three powerful Microsoft Cloud APIs: Dataverse, Azure Storage REST API, and Azure Face API. Together, they’ve elevated our Dark Ledger solution to new heights of innovation and functionality. Here’s how we made magic happen. 🧙‍♂️


1. Dataverse – The Ledger’s Core 📜🔗

At the heart of our dark operations lies Dataverse, the keeper of all knowledge and the driver of our workflows. With the Dataverse Web API, we’ve created an enchanted process that triggers the OneFlow API to handle contracts for each Order of Doom. Here’s how:

  • Trigger the Spell: When a new Order of Doom is created, a Power Automate flow springs into action, retrieving the requester’s details and the order specifics.
  • Summon OneFlow: Using these details, the flow invokes the OneFlow API to craft a contract that’s sent for e-signature.
  • Centralized Power: All this data is stored and tracked in Dataverse, making it the foundation of our interactive map and contract records.

2. Azure Face API – Identity Verification 🧠🖼️

What’s a sinister operation without proof of completion? That’s where the Azure Face API steps in, acting as our Polyjuice Potion for digital identity verification. When a target is “handled,” here’s what happens:

  • Photo Submission: The person responsible uploads an image of the deed.
  • Identity Match: The Face API, integrated with Power Automate, analyzes the photo and compares it to the target’s profile in Dataverse.
  • Deed Confirmed: If the identity matches, the flow sends a final confirmation email and updates the record in Dataverse.

3. Azure Storage REST API – Mapping the Shadows 🗺️✨

The Azure Storage REST API brings a new layer of sorcery to our solution by enabling real-time tracking for the interactive map. This API, used within Power Automate, is our secret weapon for dynamic data handling:

  • Store Location Information: Each Order of Doom includes precise location details for both the requester and the target.
  • Real-Time Updates: Using the Azure Storage REST API, these locations are posted and retrieved, enabling our Google Maps-powered map to display updated positions in real-time.
  • Seamless Integration: The flow ensures that every movement is logged with precision, offering a spellbinding experience for users.

With this magical blend of AI and automation, we ensure efficiency, accuracy, and a bit of wizardly flair. 💀

The benefits of mixing magic with ancient magic

Our OwlExpress solution needs to get the list of possible future wizards from a different set of data sources. We are merging these data into a PowerBI report so that the segmentation can be easily done using the slicers in a more intuitive way.

This Report is integrated into an MDA using a PCF control that House Elves Limited created that can save the segment chosen by the user using the Export Segment command.

This will trigger a Power Automate flow that will create the applications for all future students of the chosen segment.

To integrate the PowerBI report the following API’s are being consumed:

The PCF component has been developed using Test Driven Development and Storybook which allows you to fail fast and often and reach success faster.

The component is a react/virtual component, which simplifies a lot the separation of concerns into different components.

The code has been structured using the best practices for PCF components. We are using a Solution Project to simplify the build of the Solution that contains the component.

To standardize the build and deployment process and to ensure that the PCF Version is always kept in sync with the containing Solution version a couple of PowerShell scripts have been written. This helps also with the Azure DevOps pipelines because these can be simplified to execute the exact scripts that the developer executes on their machine.

Scaling the Heights of Innovation: PowerPotters’ Triple-Badge Journey

Greetings, fellow wizards, witches, and tech enchanters! As proud members of House Slytherin, we at Team PowerPotters are no strangers to thinking big, acting boldly, and weaving a little magic into everything we do. This time, we’re thrilled to present our solution—a perfect blend of resourcefulness, ambition, and innovation—that makes a strong case for not one, not two, but three badges: Hogwarts Enchantment, Dataminer, and Stairway to Heaven.

Here’s how we’ve brought our cunning vision to life, blending the wizarding world with business processes and cutting-edge technology.


🪄 Hogwarts Enchantment: Magic in Every Workflow

They say Slytherins know how to blend strategy with creativity, and our solution proves it. By integrating external Harry Potter APIs, enriched with AI magic, we’ve transformed ordinary data workflows into something straight out of the wizarding world:

  • Magical Data Sources: Using three Harry Potter APIs, we dynamically fetch spell-related data.
  • AI-Powered Enrichment: OpenAI serves as the magical mind, enriching spell data with unique descriptions, insightful classifications, and relevant connections.
    • For example, a spell fetched from the API is expanded with product details and seamlessly integrated into Finance and Operations (FO).
  • Invisible Charms at Play: A clever “dirty hack” with Dataverse acts like an invisible charm to detect duplicates, ensuring a seamless user experience and efficiency.

Why This Deserves the Badge: By blending AI, external APIs, and intuitive workflows, we’ve brought the enchantment of Hogwarts to life within business processes. It’s not just automation—it’s pure magic.


🐍 Stairway to Heaven: Ambition Meets Integration

As true Slytherins, we always aim for the top. With this solution, we’ve ascended the metaphorical stairway to technical greatness by integrating three major Microsoft services into one seamless, end-to-end workflow:

  1. Dataverse: Acting as a logical trap, it checks for duplicates using error-driven logic, saving time and resources.
  2. Finance and Operations (FO): The heart of our solution, FO handles enriched product creation, BOMs (Bill of Materials), and inventory management.
  3. OpenAI: Enhances data with contextual business insights, transforming raw API information into actionable intelligence.

Seamless Integration in Action:

  • Data flows from the Harry Potter APIs to Dataverse, where duplicate checks occur.
  • OpenAI adds contextual magic before FO processes the enriched records, ensuring they deliver maximum business value.

Why This Deserves the Badge: The solution builds a stairway that bridges data, AI, and business processes. It’s efficient, scalable, and a testament to the power of intelligent integration.


🧙‍♂️ Dataminer: Uncovering Magical Insights

Our solution didn’t just extract data—it transformed it into gold worthy of a Slytherin treasure vault:

  • Using Harry Potter APIs, we mined spell-related data and applied AI to add context, relevance, and business-ready value.
  • We didn’t stop at fetching data. We turned it into actionable insights that integrate seamlessly into business systems, eliminating manual work and reducing errors.

Why This Deserves the Badge: This isn’t mere data extraction—it’s intelligent, enriched, and purposeful mining that creates real value.


🪄 Why We Deserve All Three Badges

Our solution is a shining example of Slytherin ingenuity, ambition, and teamwork. It seamlessly meets the criteria for:

  • Hogwarts Enchantment: By combining APIs, AI, and intuitive workflows, we’ve made business processes feel truly magical.
  • Stairway to Heaven: Through integration of Dataverse, FO, and OpenAI, we’ve built a harmonious system that transforms data into value.
  • Dataminer: We didn’t just gather data; we mined and enriched it with AI to deliver insights that matter.

🔮 A Slytherin’s Call to Action

House Slytherin has always been about turning ambition into achievement, and this solution is no exception. With our resourceful approach to combining APIs, AI, and business logic, we’ve created a system that not only solves problems but does so with a touch of magic.

We humbly present our work for consideration for the Hogwarts Enchantment, Stairway to Heaven, and Dataminer badges. Ambition, strategy, and ingenuity—it’s the Slytherin way.

Follow our journey as we continue to climb new heights of innovation: acdc.blog/category/cepheo25.

#ACDC2025 #HogwartsEnchantment #StairwayToHeaven #Dataminer #SlytherinPride

Streamlining Backend-Frontend Communication with Cloud APIs

Enabling seamless communication between the backend and frontend is a must for delivering smooth user experiences. For our solution, we leveraged three powerful Azure cloud APIs to facilitate a direct line of communication between our backend and frontend, optimizing the process of running and analyzing conversations with a bot service.

In our case, we needed to ensure that the backend and frontend could communicate efficiently with a bot service, run conversations using an AI model, and analyze the interactions to improve the user experience—all while keeping things fast and responsive.

To achieve this, we turned to Azure and integrated three critical APIs:

  1. Direct Line API (Bot Service): For communication between the backend and the bot.
  2. Azure OpenAI API: To power the AI-driven conversations.
  3. Azure Language Service API: For analyzing the conversation and extracting valuable insights.

PromptFlow: A Multifaceted AI Solution in Microsoft Teams 

Introduction 

PromptFlow, our innovative AI chatbot integrated into Microsoft Teams, not only streamlines race strategy and collaboration but also stands as a testament to advanced cloud technology integration. Targeting three distinguished badges – “Plug N’ Play,” “Crawler,” and “Stairway To Heaven,” PromptFlow embodies the pinnacle of AI-driven solutions in Microsoft’s ecosystem. 

Plug N’ Play: Enhancing Microsoft Teams with AI 

PromptFlow elevates Microsoft Teams by offering automated, data-driven insights for racing strategy development. By utilizing over 5,000 race statistics, it enables users to query lap times, kart performance, and player stats in natural language, demonstrating a perfect blend of AI and user experience. 

Crawler: Transforming Race Strategy with AI Search 

The “Crawler” badge highlights PromptFlow’s innovative use of AI search to navigate extensive race data, revolutionizing the way racing teams strategize. This feature addresses the critical need for quick and accurate decision-making, offering a significant competitive edge in the racing industry. 

Stairway To Heaven: A Symphony of Microsoft Cloud APIs 

Achieving the “Stairway To Heaven” badge, PromptFlow masterfully combines multiple Microsoft cloud APIs: 

  • AI Search: Powers the core functionality, enabling efficient data retrieval. 
  • Sentiment Analysis: Enhances user interaction by adapting responses based on detected sentiment. 
  • PromptFlow Technology: Our proprietary tech, ensuring smooth and natural conversational experiences. 
  • Azure OpenAI Instance: The backbone providing computational power and advanced LLM capabilities. 

This integration not only meets the badge’s criteria but also sets a new standard for AI solutions in cloud environments. 

Technical Integration and Future Prospects 

Each API plays a crucial role in making PromptFlow a robust, intelligent system. This multifaceted integration exemplifies our commitment to leveraging cloud technology for creating advanced AI solutions, paving the way for future innovations. 

The solution/demo:

Conclusion 

PromptFlow is more than just a chatbot; it’s a groundbreaking tool that revolutionizes race strategy development and team collaboration. It showcases our expertise in blending AI with cloud technologies, earning us the “Plug N’ Play,” “Crawler,” and “Stairway To Heaven” badges. As we continue to innovate, we look forward to exploring new horizons in AI and cloud computing. 

Note: This combined draft succinctly captures the essence of PromptFlow’s achievements in earning the three badges. It emphasizes the chatbot’s functionalities, technical prowess, and future potential in the realm of AI and cloud computing. 

Stairway to Heaven

When we get a new contact in our CRM, basically a new player in our game club, we want to welcome them by first generating an AI produced welcome text and send it in an email from Outlook. Then we will also add them to our Azure Entra

  1. Dataverse
  2. AI Generator
  3. Outlook Email
  4. Azure AD

Crashing the Azure AI Studio and Copilot

Badges to claim:

  • Nasty Hacker – for retrieving data from 3rd party services and syncing it to the blob storage to connect to Azure AI Studio
  • Data miner – for retrieving the case information from dataverse and calculating the average score using AI.
  • Embedding numbnut – for embedded copilot in Model-driven app
  • Stairway to heaven – for using Azure AI Studio, Copilot, Blob storage, and in previous articles also Azure Function, WebApp

Our solution includes the latest features of the PowerPlatform and Azure connection the Low and Pro code approaches together, to allows you to boost the performance of resolving the cases by using some insights from the Copilot. 

  • The business use case is about complicated cases when we need external consultancy and assistant, so task is to find the suitable Marios-consultants according to the customer request, by searching the professionals on the Indeed, comparing their background and experience and finding the best matches. (to find the suitable Marios according to the request.) 
  • The business use case is about simplify the KYC(Know Your Customer) process by using unified workspace for all operations.  From Indeed we can understand the company background,do semantic analysis of the comments to have insights on how technicians can approach customer (princess) (simplify the KYC(Know Your Customer) process by using unified workspace for all operations.) 
  • The business use case is about analyzing current princess (customer) and her needs based on the Indeed. The data that we were able to retrieve contains open job postings, company in for, recent news and personal profile info. Based on this information, we can suggest more other services and provide information to sales and marketing departments. (analyze current princess and her needs based on the Indeed profile and suggest more other services.) 

We deployed GPT-4 model to our personal instance using AI Studio, then fine-tuned it with company’s internal data and data from open sources like Indeed, Glassdor or proff.no. 

Than using Retrieval Augmented Generation (RAG) technic to inject generative responses from big LLM into answer of Copilot. 

With RAG, the external data used to augment your prompts can come from multiple data sources, such as a document repositories, databases, or APIs. The first step is to convert your documents and any user queries into a compatible format to perform relevancy search. To make the formats compatible, a document collection, or knowledge library, and user-submitted queries are converted to numerical representations using embedding language models. Embedding is the process by which text is given numerical representation in a vector space.  

AI Studio has seamless integrated feature use Azure Blob Indexer to implement search functionality search for AI. It bring the possibility to simplify the access to the Datalake from LLM side.   

By implementing multiple connectors to the third-party services and data sources, together with Dynamic chaining feature of the Copilot it gives cleaner user experience for the user using only one tool for analyses. 

How it works:

Loving the ease and use of Web API Connectors in Power Automate

In the following flow we have integrated three different connectors with the purpose of logging and giving an overview of DLP for all the ChatGPT related flows. We’ve involved user information through Azure Entra ID service, posting logs in Teams admin channel and also fetching the stored Azure Key Vault secret for security reasons which are then encrypted and hidden information based on the action settings of the HTTP action and Azure Key Vault action.

KoopaKonstruct Manager’s Stairway to Heaven

The Hololense device is not just a headset; it’s a portal to a world where the boundaries between the virtual and the real blur. To achieve this seamless integration, we leverage the prowess of four distinct Microsoft Cloud APIs, each playing a crucial role in orchestrating our KoopaKonstruct Manager adventure.

Power Automate: Automating the Journey

Power Automate acts as the orchestrator of our adventure, seamlessly connecting the various components of our solution. With Power Automate, we automate workflows that trigger updates in FinOps, generate purchase and sales orders, and send confirmation emails. Additionally, the flow sends inventory status back to the Hololenses for the user to be updated on inventory quantity on sight. This cloud-based automation engine ensures that our journey unfolds with precision and efficiency, leaving no room for manual intervention.

FinOps: Navigating the Financial Landscape

FinOps, a cloud financial management framework, guides us through the financial landscape of our project. By integrating FinOps, we ensure that the procurement of materials aligns with budgetary constraints. The cloud-based financial intelligence provided by FinOps becomes the compass that guides our decisions, ensuring a smooth journey through the financial complexities of our adventure.

Unity: Crafting the Virtual Reality

Unity, a powerful cross-platform game engine, becomes the canvas for our Hololens-powered adventure. Through Unity, we bring the Super Mario-themed world to life, creating a virtual playground where users can interact with their surroundings. Unity’s versatility allows us to seamlessly integrate Hololens functionalities, providing an immersive and interactive experience that blurs the lines between the physical and digital realms.

Uniting the Microsoft Cloud APIs

The integration of Power Automate, Unity, and FinOps with Hololens exemplifies the synergy achieved by uniting Microsoft Cloud APIs. Together, they form a cohesive ecosystem where data seamlessly flows, processes are automated, and a Super Mario-themed world comes to life before our eyes.

This integration is not just about earning a badge; it’s about unlocking the potential of cloud technologies to create experiences that transcend the ordinary. Our journey is a testament to the endless possibilities that unfold when diverse Microsoft Cloud APIs unite in a symphony of innovation!

Piping our way through the Azure Cloud

To make our amazing service Tubi work, a lot of cloud is needed. We aim to make the plumber’s job easier by recommending the best layout for where the pipes should go, and for that, we need AI. We have trained a model in Custom Vision to recognize all components in a bathroom that need water. So, when the plumber uploads a floor plan to our Static Web App, the image is sent to our Azure Function App backend in C# Asp.net through our own API. But both the image and the equipment list must be stored somewhere. Therefore, we have also connected to Azure Blob Storage. Then last but not at all least. The people working in the back office have instant interactive reports available to help them with filing and billing through Power BI and alerting the using an automated flow (Badges: Feature Bombing)

Sometimes it works, and that’s plenty

Databases are good, but sometimes it’s easier to just dump everything in one place until you need it again. Yes, it might not be very scalable or very normalized. SQL became too heavy, and we already needed a Blob storage to store the images, so we also dump the order data in the same blob storage as JSON files. It’s old fashioned way of serverstorage, and a bit dirty, but it works! (Badges: Nasty hacker, Retro badge)

Power the backoffice

As the final list of components are decided, they still have to be approved from the accounting team in the office. To make sure they have all the information they require, we have developed a Power BI dashboard to crawl through our registered data and make sure the orders are handled properly (Badges: Crawler, Dash it Out, Dataminer). And to make sure the orders are handled easy and fast, the dashboard is embedded into teams and an alert is automated by using a logic app to make sure the workers can receive and cooperate in realtime (Badges: Embedding Numbnuts, Go with the flow, Pug N’ Play, Power user love, Right Now, Stairway to heaven).