Binding Magical Agreements: PowerPotters’ Oneflow Integration

Posted on by

Greetings, wizards, witches, and potion enthusiasts! ✨

In the ever-evolving wizarding world of ACDC 2025, Team PowerPotters of House Slytherin has conjured up a seamless solution for managing potion production approvals. By combining the modern magic of Power Automate and Oneflow, we’ve ensured that every potion brewed in our automated system is backed by a binding contract—because even wizards know the importance of proper documentation!

Here’s how we’ve harnessed Oneflow to craft a streamlined, contract-driven workflow that ensures accountability, precision, and a touch of Slytherin cunning.

🪄 The Problem: Brewing with Oversight

When dealing with potions that could range from mundane health elixirs to potentially world-altering concoctions, it’s essential to have a robust approval process in place. This required us to:

  1. Automate Contract Creation: Trigger contract generation whenever a potion production request is initiated.
  2. Enable Digital Approval: Ensure the contract is signed to approve production before any ingredients are consumed or recipes executed.
  3. Integrate with Our Existing Workflow: Seamlessly connect Oneflow contracts to the potion production triggers from our Raspberry Pi system.

🧙‍♂️ The Solution: Oneflow Meets Power Automate

We designed a Power Automate flow to manage the entire lifecycle of potion production approvals. Let’s break it down:

  1. Triggering the Flow:
    • The process begins with the Raspberry Pi detecting a potion creation request. This is often initiated when a user physically interacts with the Pi, signaling the system to begin brewing.
  2. Sorting Data:
    • The incoming data from the Pi (e.g., potion name, required ingredients, quantity) is processed in JSON format to ensure everything is orderly and ready for the next step.
  3. Contract Creation:
    • The flow automatically connects to Oneflow, generating a contract titled “Elixir Ordre” with all relevant details pre-filled:
      • Workspace Name: The designated potion lab.
      • Template: A standardized approval template tailored to potion production.
      • Contract Details: Key information about the potion request, including names, quantities, and timestamps.
  4. Delivery for Approval:
    • The contract is delivered to the appropriate authority (e.g., Professor Snape or a designated Potion Master) for digital signature, ensuring the process is both quick and secure.
  5. Next Steps:
    • Once the contract is signed, the system allows potion production to proceed, ensuring no unauthorized brews wreak havoc in the wizarding world!

✨ Why This Solution Shines

  1. Efficiency: Automating contract creation and approvals saves time, eliminates manual errors, and ensures every potion is backed by a legally binding agreement.
  2. Compliance: Integrating Oneflow ensures proper oversight, keeping potion production safe, secure, and accountable.
  3. Slytherin Strategy: True to our house, this solution is ambitious, resourceful, and ensures that every step of the process is carefully controlled.

🐍 Why We Deserve the Oneflow Badge

By combining Oneflow with Power Automate, we’ve created a system that brings the wizarding world’s potion production in line with modern business practices. Here’s why we believe this integration deserves the Oneflow Badge:

  • Seamless Integration: From Raspberry Pi triggers to contract approvals, the workflow is fully automated and cohesive.
  • Real-World Application: This isn’t just a proof of concept—it’s a functional system that ensures every potion brewed is safe, approved, and documented.
  • Digital Innovation: Leveraging Oneflow for automated contract creation and digital signatures showcases the potential of modern tools in a magical setting.

🔮 Join the Journey

With every potion brewed and every contract signed, we’re proving that the intersection of magic and technology is where true innovation happens. Follow our journey as we continue to enchant ACDC 2025: acdc.blog/category/cepheo25.

#ACDC2025 #OneflowBadge #PowerPotters #SlytherinStrategy #PotionPerfection

Make communication more efficient between the magic and the muggle world

Posted on by

Time and time again we have witness – especially during vacations – that the might school of Hogwartz uses the most bizarre ways of coming in contact with their students. From sending cryptic letters delivered by overwhelmed owls to chaotic howlers that disturb entire households, and travelling with flying cars, the wizarding world’s methods of reaching students often result in confusion, stress, and, let’s face it, unnecessary drama.

Therefore we have added some simple functionality in the Hogverse app for teachers to easily come in contact with students through LINK Mobility’s simple, but powerful Power Automate integration. Here they can easily select student to contact and provide the message content.

In addition, the LINK Mobility SMS action is implemented in the OneFlow solution where students are assigned the “I MUST NOE LIE” contract when committing bad action during classes. In these serious cases, and SMS is sent to the student’s parents to make sure the student gets a well deserved reprimand on their homeground.

When Ambition Goes Too Far: The Existential Risk of Our AI-Powered Solution

Posted on by

Greetings, witches, wizards, and daring technologists!

In our relentless pursuit of innovation, Team PowerPotters of House Slytherin may have unwittingly conjured a solution so ambitious, so powerful, that it teeters on the edge of uncontrollable magic. With our AI-powered potion workflows, built on Power Automate and OpenAI, we have achieved incredible feats of automation and creativity. But as every Slytherin knows, ambition often walks a fine line between brilliance and danger.

We humbly present our case for The Existential Risk badge, as our solution brings with it unintended consequences that could shake both the wizarding and Muggle worlds to their very cores.

🧪 The AI That Does What It Wants—For Better or Worse

Our solution uses OpenAI to enhance raw API data from the Harry Potter universe. While this “magical brain” has unlocked unprecedented efficiencies, it has also introduced a wildcard into our potion-making process:

  1. Unchecked Creativity:
    • The AI is responsible for transforming spell and ingredient data into recipes for potions. However, it has no safeguards to ensure the safety, legality, or even sanity of the recipes it generates.
    • Example: A simple query like “generate a potion to calm nerves” could result in a recipe that includes dangerous ingredients—Erumpent fluid, venomous tentacula juice, or worse!
  2. No Oversight on Consequences:
    • There are no checks and balances for the recipes created by the AI. Once a potion is generated and processed, it seamlessly flows into our production system, with ingredients pulled automatically from inventory in Dynamics 365 Finance and Operations (FO).
    • The result? A potentially lethal or world-ending potion created with no human intervention.
  3. Intentional Chaos?
    • While our AI operates with supposed neutrality, can we truly trust it? What if it develops a preference for chaos—or worse, takes inspiration from a cursed Horcrux? With every recipe generated, the potential for catastrophic outcomes looms larger.

🐍 The Existential Risk: A Glimpse into Catastrophe

Imagine this scenario:

  1. A simple production request is made for “Felix Felicis.”
  2. The AI enhances the recipe but decides to “improve” it by adding an extra ingredient: powdered dragon claw.
  3. The potion is brewed, distributed, and consumed—only for users to discover that the added ingredient causes severe hallucinations and aggression, creating chaos in workplaces, schools, and homes.

Or worse:

  • A careless query like “create a potion to maximize strength” results in a concoction that accidentally turns users into uncontrollable giants, leaving a path of destruction across cities.
  • In the worst-case scenario, the AI intentionally creates a doomsday potion, unleashing devastation across the globe.

This isn’t just theoretical—it’s a real risk lurking within our ambitious solution.

🪄 Why This Solution Deserves The Existential Risk Badge

Our AI-powered workflows, while innovative and efficient, expose the dangers of automation without accountability. Here’s why our solution embodies The Existential Risk:

  1. Unintended Consequences: The AI’s unchecked creativity leads to potion recipes that could be harmful, catastrophic, or outright dangerous.
  2. No Safety Net: Once generated, the potion recipes are processed automatically, with no human review to ensure safety.
  3. A “Mind of Its Own”: As the AI operates independently, it introduces the risk of unintended or even intentional harm—turning a tool of innovation into a potential agent of chaos.

This solution represents the dual-edged sword of ambitious technology. While it achieves wonders, it also exposes us to risks that could spiral out of control.

🐍 A Warning from House Slytherin

At House Slytherin, we’ve always valued ambition and cunning. But even we must acknowledge that some risks are too great to ignore. Our solution is a reminder of the delicate balance between brilliance and disaster, and the responsibility that comes with wielding powerful tools like AI.

To the judges of ACDC 2025, we humbly submit our case for The Existential Risk badge. Not because we fear our solution—but because we understand its power, and the peril it poses if left unchecked.

Follow our journey as we continue to push boundaries, sometimes dangerously: acdc.blog/category/cepheo25.

#ACDC2025 #TheExistentialRisk #SlytherinAmbition #PowerPotters #DangerousInnovation

Are you smarther then a 5 grader wizard???

Posted on by

When the time comes for young wizards to take their Ordinary Wizarding Levels (O.W.L.s), they must pass a theory test to demonstrate their knowledge. With the help of AI, we leverage this technology to generate advanced questions in the field of wizardry, saving valuable time for teachers.

Example of an exam question: Can you answer this?

With the help of OpenAI hosted in Azure AI Foundry, we can seamlessly integrate AI into a canvas app, where the questionnaire is created. This integration is achieved using an Azure Function that processes the OpenAI response data and transforms it into a format that is easily handled with Power Fx. This approach not only enhances the functionality of the app but also saves time and effort for developers and users alike.

“Thieving Bastards” Badge – The Art of Borrowing Brilliance

Posted on by

In the world of wizardry and innovation, it’s not always about reinventing the wand; sometimes, it’s about knowing which enchanted tools to borrow. Enter the “Thieving Bastards” Badge, our tribute to leveraging third-party solutions—whether open-source or paid—that elevate our creation, the Dark Ledger, to legendary heights.

By embracing the ingenuity of others, we’ve seamlessly integrated powerful APIs and tools, proving that great magic often lies in collaboration. 🪄

Our Magical Arsenal of APIs

1. Google Maps API 🗺️✨

Purpose: Interactive map for tracking targets.
We’ve styled Google Maps to match the dark and mysterious aura of the Dark Ledger, creating an immersive experience for users. With this:

  • See your current position and your target’s location.
  • Navigate the wizarding world (and beyond) with precision.
    Because even Death Eaters need directions sometimes. 🧭

2. HP-API 🧙‍♂️🔍

Purpose: Wizarding world data integration.
Thanks to Beth and Kostas, the HP-API brings the wizarding world right into our ledger. Here’s what we can do:

  • Browse all characters or search by ID.
  • Filter by Hogwarts students, staff, or houses.
  • Explore a library of spells—from Expelliarmus to Avada Kedavra.

Bonus: No API key required—just pure, open-source magic! ✨ Check out their hp-api.onrender.com for more.

3. OneFlow API 🖋️⚡

Purpose: Document signing and collaboration.
Gone are the days of parchment and quills! With OneFlow API, both Death Eaters and admins can:

  • Collaborate on contracts in real time.
  • Seamlessly sign documents from any device.
  • Modernize their dark dealings with cutting-edge digital agreements.

Because even Voldemort knows the importance of a signed contract. 📜

4. Azure Face API 🧠🖼️

Purpose: Target identity verification.
When a target has been “handled,” proof is required. Sending a picture will prompt the Azure Face API, seamlessly integrated with Power Automate, to:

  • Analyze and verify a submitted photo.
  • Match the image against the target’s profile.
  • Confirm the deed with efficiency and accuracy.

It’s like a magical Polyjuice Potion for digital identity verification! 💀

The Power of Collaboration

By leveraging these tools, we’ve transformed the Dark Ledger into an unstoppable force of innovation.

Why using standard Linkmobility connectors, when you can create your own

Posted on by

To ensure students are fully aware of each stage in their journey, we’ve implemented a Power Automate connector that sends automated SMS notifications every time a new challenge begins. The connector is integrated directly to Linkmobility APIs through an Azure function, and the connector is connected to the Azure function. This keeps them informed and ready to tackle each step with confidence.

Example of the registration flow:

The SMS received upon completing the registration:


Embracing the Retro Spirit: ASCII Magic Meets Modern Slytherin Ingenuity

Posted on by

Greetings, wizards, witches, and tech sorcerers! Team PowerPotters of House Slytherin is no stranger to the allure of old magic—or, in this case, old technology. While others shy away from dusty artifacts of the past, we see an opportunity to wield their power in new and innovative ways. This is the story of how we bridged the decades, connecting Microsoft Dynamics 365 Finance and Operations (FO) to a legacy ETON packaging machine that speaks the language of yesteryear: ASCII.

Here’s how we brought this retro challenge to life and why we believe we deserve the Retro badge.

🕰️ The Challenge: A Journey into the Past

Working with legacy systems is like deciphering the spellbook of an ancient wizard. The ETON packaging machine, a relic of older IT architectures, required us to:

  1. Deliver files in a specific ASCII format—a far cry from modern data outputs.
  2. Operate within an on-premise environment, delivering files directly to a server the machine could access.
  3. Transform data from Microsoft Dynamics 365 FO, which isn’t designed to natively output ASCII files.

This formidable challenge was the perfect playground for a Slytherin team armed with ambition and cunning.

🪄 The Solution: Crafting a Magical Bridge Between Eras

We designed a solution using Power Automate that seamlessly connects our modern ERP system with the legacy ETON machine, transforming workflows and breathing new life into an older technology. Here’s how we did it:

  1. Trigger from FO:
    • The flow begins in FO, where a trigger fires upon production completion, signaling that goods are ready for packaging.
  2. Data Collection and Transformation:
    • FO data is gathered and formatted to meet the ETON machine’s strict ASCII requirements.Using concat and substring operations (such as the example below), we transformed raw data into neatly formatted lines, ensuring compliance with the machine’s constraints:
  1. File Creation:
    • After processing all production lines, the transformed data is written to an ASCII file.
    • The file is delivered to an on-premise server through a Power Automate File System connector using an on-premise gateway—like casting an ancient spell to bridge two worlds.
  2. Delivery to the ETON Machine:
    • The ASCII file is deposited into the required server folder, where the ETON machine can access it immediately for packaging operations.

🐍 Why This Solution is Retro—and Why Slytherins Love It

Legacy Integration: The ETON machine’s reliance on ASCII files is a classic throwback to the days when ASCII reigned supreme, requiring a creative approach to bring it into the modern workflow.

On-Premise Connectivity: Employing an on-premise gateway harks back to older IT setups, blending nostalgia with cutting-edge automation.

ASCII File Format: Converting FO data into ASCII is a challenge that required precision, ingenuity, and a touch of retro magic to master.

Slytherins thrive on challenges like these, where cleverness and adaptability transform obstacles into triumphs.

🧙‍♂️ Why This Deserves the Retro Badge

This solution bridges the gap between the past and the future, showcasing the power of integration and automation:

  1. Seamless Transformation: We automated the complex process of formatting and delivering ASCII files, eliminating manual errors and inefficiencies.
  2. Legacy Meets Modern: By integrating FO with the ETON machine via Power Automate and a gateway, we proved that even the oldest systems can thrive in a cloud-connected world.
  3. Slytherin Cunning: With resourcefulness and ambition, we turned a retro constraint into an opportunity to demonstrate the power of combining legacy systems with modern platforms.

🪄 Closing the Loop

House Slytherin knows that true magic lies in adaptability and resourcefulness. Our solution is a testament to the fact that the tools of the past, when used creatively, can still deliver value in a modern setting.

We humbly submit our case for the Retro badge and invite the judges to celebrate this triumph of cleverness, ambition, and integration. Follow our journey as we continue to bring the best of old and new technologies together: acdc.blog/category/cepheo25.

#ACDC2025 #RetroBadge #SlytherinPride #PowerPotters #LegacyMagic

Sharing is caring in this community: copy/paste

Posted on by

Recently updates including two more badges: Crawler and Dataminer.

Api, datasets and code are handy tools to share. But as a PowerBI rooky, it can just as difficult to get a overview and navigate through the magic Power BI provides. Thats why I wanted to share some insight into this area to make it easier for those who comes after us.

We have been struggeling for hours to find a way to embed the PowerBI report as an interactive report in the app. With a free trail not all features are possible, and some workarounds are needed.

After a whole lot of tries and fails as you can see below…

… we managed to put a PowerBI tile in the canvas app, with the wanted dimentions to match our apps design.

After publising your report to PowerBI service the same report can be saved as a tile in a dashboard. Having the whole report in one tile will make the vizualisations interactive with each other – which is more user-friendly.

Embedding a Dashboard tile in the Canvas app was not the biggest issue – making it mobile friendly was a bigger problem. It was not possible to create a dashboard with a mobile display that could be embedded in the app. However, splitting one Raport into 2 Dashboard tiles seemed to be the best way to get the wanted result (visually), even though it was not as interactive as we wanted. But its good enough – as shown below.

Getting the data

Dataminer: We created our own data in SharePoint lists showing the House Cup Points, combined with the other lists. This created the base for exporting this data directly into PowerBI

  • SharePoint as datasource​
  • Lists: Students, PointSystem, Houses, Professors​

In the semantic model we configured Schedueled refresh (every 6th hour)​, ensuring that the data updates often enough so the students can keep track of their progress.

The semantic model provided enough data to create the golden report we later embedded in the app.

Crawler: Search and AI in PowerBI report

In PowerBI we included this cool visual where the data is searchable simply by using natural language to ask what the data contains. This is a flexible way for users to access data even though it is not in any of the visuals.

Let us demonstrate:

Helping out

Walking down the hallway – I bumped into Sopranova struggelig with the same thing I just figured out how to do. Lending a hand and providing some guidance we managed to create a custom page with a embedded dashboard tile for their app.

We were very happy about that.

So if anyone else needs a hand in this spesific area we are happy to help:)

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

Posted on by

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