The Dark Ledger: From Creation to Completion — A Tale of Dark Deeds, Technology, and Magic

Welcome to the Dark Ledger, a thrilling journey where cutting-edge technology and dark magic collide to execute the most daring missions. This blog post will take you through every step of our process—from receiving a new Order of Doom to verifying the completed deed. Every moment is fueled by Microsoft Cloud technologies, modern AI, and a sprinkle of wizardry. Here’s how we make it all work.


1. Someone to Kill: The Order of Doom is Born

It all starts with the Order of Doom: a request for someone to be handled. When the call comes in, a new Order of Doom is created in Dataverse, the heart of all things dark. This record contains all the details of the task—who needs to be dealt with, the reward, and all the necessary instructions to carry out the mission. And thus, the hunt begins. ⚡💀


2. Dark Ledger is Found: The Heart of the Operation

Once the Order of Doom is in motion, the Dark Ledger is activated. The Dark Ledger Power Page and App is the villain’s tool for managing and tracking every kill. With this app, you can access key stats, view the leaderboard, check success rates, and analyze order distribution. It’s a real-time system that keeps the death eaters connected to their missions—whether they’re on desktop, tablet, or mobile. 📲💻


3. Registering and Logging In: Accessing the Dark Ledger’s Secrets

To dive into the Dark Ledger, death eaters need to register and log in securely using Azure Entra Id. Only those with the necessary credentials can access the tasks and the interactive map, allowing them to view their target and plan accordingly. 🔑🖤


4. Check Graphs and Data: Visualizing the Dark Stats

Before heading out on the mission, it’s essential to check the KPIs, graphs, and data available in the Dark Ledger‘s dashboard. This includes success rates, order distribution, and top-ranking villains. The Model-Driven App visualizes these metrics to ensure that the mission fits into the larger picture of operational efficiency. 📊📈

For more info check: https://acdc.blog/the-team-who-must-not-be-named/dash-it-out-crafting-enchanting-dashboards/


5. Order Kill: The Assignment is Created

Once the death eater is ready, the Order of Doom details are finalized in Dataverse. A Power Automate flow is triggered, registering the new task and setting up notifications for the death eater. The order is ready for approval, with the villain prepared for action. 📝💀


6. Admin of the Dark Ledger Approves: The Green Light for the Kill

Before anything goes forward, the admin must approve the order. This is done through an approval flow in Teams, where the service principal verifies that the kill is legitimate and aligned with the Dark Ledger’s policies. Once approved, a notification is sent to the death eater to start the job. ✋✔️

For more info check here: https://acdc.blog/the-team-who-must-not-be-named/oneflow-sponsor-badge-a-wizards-journey/


7. Assigning a Death Eater: The Right Hand for the Job

The admin then assigns the death eater to carry out the task. Using the Dark Ledger Power App, the villain is notified of the target’s details and the reward. They’re now equipped to carry out the mission and head to their target’s location. 🖤🎯


8. Contracts with OneFlow Signing Procedure: The Dark Pact

Every death eater must make a pact before carrying out the mission. Using OneFlow, a contract is created, detailing the terms of the job. The death eater and the requester digitally sign this contract using OneFlow’s API, binding them to the dark task. Once signed, the task is officially underway. ✍️🖤


9. When Signed, Updates Status of the Kill Order

Once the contract is signed, Power Automate triggers an update to the Order of Doom in Dataverse, changing its status to “Confirmed”. The requester is notified that the death eater is officially bound to the task. 📜✅


10. Death Eater Starts the Job: The Hunt Begins

Now that everything is confirmed, the death eater sets out on the mission. The journey is tracked in real-time using our interactive map, which visualizes the location of the target, the death eater, and the reward for the task. 🚶‍♂️🔮


11. The Death Eater Gets Notification and Checks Out the Dark Ledger Power App

Once the death eater begins the task, they receive real-time notifications from the Dark Ledger Power App. The app keeps them updated with information about the target, location, and the reward. They can check on progress and make sure everything is on track to complete the mission. 💬📲


12. Target Tracking in Real Time: Never Miss a Beat

As the death eater tracks their target, the interactive map continuously updates in real-time. With Google Maps API, we can track both the death eater and the target‘s location, ensuring that every move is accounted for. The app is responsive across all devices, ensuring the death eater can follow the mission no matter where they are. 🗺️📍

For more info check this: https://acdc.blog/the-team-who-must-not-be-named/interactive-map-bringing-dark-ledgers-magic-to-life/


13. Kill Confirmed When the Deed is Done: The Dark Magic is Complete

Once the kill is carried out, the death eater confirms the completion of the task by submitting photographic proof of the deed. This photo is sent to Azure Face API for verification. The face recognition AI ensures that the photo matches the target’s reference image stored in Dataverse, ensuring the job is done with accuracy. 📸💀


14. Face Recognition to Verify: AI Steps In

We’ve integrated Azure Face API to verify the completed task with precision. The AI analyzes the uploaded photo’s facial features and compares them to the pre-stored reference image. Using Azure Open AI, it calculates a similarity score based on facial landmarks, ensuring the kill is accurately verified. 🧠🖼️


15. Verified: The Dark Deed Is Complete

Once the AI gives the green light, the kill is confirmed, and the death eater receives a final confirmation in the app. The deed is complete, and the Dark Ledger is updated to reflect the kill. The villain earns their place in the Dark Ledger’s history, ready for their next mission. 🖤🎉


16. Survey: Customer Feedback with a Dark Twist

After an “Order of Doom” is completed, an integrated Customer Voice survey is sent to the requester, gathering satisfaction feedback. Once the survey is completed, the results are automatically recorded in the timeline within the Model Driven App, providing valuable insights and ensuring that every mission is completed to the highest standards. 📊💀


This adds a cus

TECHNICAL BITS

1. Integration of Tools and Tech Stack

While the main flow is covered, let’s dive a bit deeper into the technologies that power the Dark Ledger. The entire solution integrates React, TypeScript, and SCSS for the front end. We use GitHub Actions for CI/CD to automate the deployment process to Azure Web Apps. This ensures smooth updates and minimizes manual work. Our Azure Blob Storage solution stores location data used in the interactive map, reducing strain on the backend while keeping the system highly fluid and responsive. 🖥️💾

2. Visualizing Success with Dashboards

The Dark Ledger features interactive dashboards integrated within Model-Driven Apps and PowerPages, offering insights into the business value of each mission. We use DAX for creating and managing metrics like the leaderboard and order distribution—all of this is displayed in real-time, helping villains track their performance. 📈⚖️

3. Privacy and Compliance with Azure

We also prioritize privacy and compliance by implementing delegated deployments and approval workflows using Azure Active Directory and Service Principal. This ensures we adhere to best practices for security and maintain a transparent and secure deployment process, keeping our environments protected at every stage of the process. 🔐📑

4. Use of Azure Blob Storage and Streaming for Location Data

Our use of Azure Blob Storage for storing and streaming location data plays a crucial role in ensuring the interactive map provides accurate, real-time updates. With polling and Azure REST API, we keep the map dynamic and fresh, while reducing the server load and ensuring the system runs smoothly. 🗺️💾

5. Resco’s Power Platform Components: Elevating Customization

Resco’s PowerApps Component Framework (PCF) brings dynamic tools to the Power Platform for enhanced interactivity and customization. Key components like the Kanban Board, Date Range Picker, and File Upload allow users to manage tasks, select date ranges, and upload documents seamlessly.

These components help create tailored, efficient solutions, boosting usability and business efficiency on both mobile and web platforms. 🌟

Check it out here: https://acdc.blog/the-team-who-must-not-be-named/introducing-rescos-power-platform-components/

6. ALM – Streamlining Deployments with Best Practices

Upgraded ALM Strategy

We’ve revamped our ALM process for better governance and security. With delegated deployment using Service Principal (SPN), we ensure that all deployments are approved through automated approval workflows triggered in Microsoft Teams. This guarantees compliance, transparency, and real-time tracking for every step of the deployment.

Solution Strategy and Naming Convention

Our solution strategy follows a standardized naming convention:

  • Solutions with security automations that don’t have dependencies for deletion are kept in their own solution for fast, independent deployments.
  • The Base solution contains interdependent elements like tables, choices, apps, site maps, and dashboards—ensuring everything works in harmony within the same solution.

Error Handling and Communication

If a deployment fails, we immediately alert the team via adaptive cards in the ALM channel. Once successful, release notes are automatically sent to the Release Notes channel, informing the end users of the latest updates.


This streamlined approach to ALM ensures a secure, compliant, and efficient deployment process, with optimized solutions for different environments. 💻🛠️


Everything Tied Together: A Dark Symphony of Tech and Magic

From interactive maps to Azure Face API, every piece of the puzzle is powered by Microsoft Cloud technologies. We’ve seamlessly integrated Power Automate, OneFlow, Teams, and Azure Face API to create a solution that’s not only darkly efficient but also beautifully automated. Each step is optimized to ensure maximum performance and precision.

The Dark Ledger ensures that every mission is executed to perfection, from the creation of the Order of Doom to the final verification of the kill. With AI-powered face recognition, real-time tracking, and interactive maps, we bring the most dark and thrilling stories to life, powered by modern cloud technology and a sprinkle of magic. 🧙‍♂️🌑

House Points for Slytherin: Helping “The Name Who Must Be Named” with Link Mobility



House Points for Slytherin: Helping “The Name Who Must Be Named” with Link Mobility 📞⚡

In the dark corridors of tech, where even the most powerful wizards and witches face challenges, it’s not just about pulling off the most daring magic, but about offering a hand to those in need. Sometimes, the most unexpected of allies can step in to help, and in this case, Slytherin has found itself not only achieving greatness but helping others do the same.

One of the lesser-known struggles for The Name Who Must Be Named was obtaining the right phone number from Link Mobility—a crucial piece for triggering their desired process. But as with many such hurdles, it’s not about the problem but how you solve it. That’s where we, the Slytherins, stepped in.


Lending a Helping Hand

When we discovered that The Name Who Must Be Named did not have the necessary phone number from Link Mobility, we saw this as an opportunity to lend a hand. Rather than just letting them continue their journey without the proper tools, we reached out to Link Mobility and provided our own phone number and code number. This seemingly small act paved the way for something much larger.


The Magic Behind the Flow

But, of course, magic can’t just stop there. Once we shared the phone number and code number, the next step was ensuring the flow worked seamlessly in their environment. This is where the true magic happened. 🔮

We designed and triggered a cloud flow within our tenant. Here’s how it works:

  1. Triggering the Process: Once the phone number is triggered, our cloud flow takes over. It acts as a proxy between Link Mobility and The Name Who Must Be Named’s flow, ensuring that all data is properly transmitted.
  2. Sending the Body: The body of the received message from Link Mobility is forwarded to their flow via the cloud flow, making sure everything runs smoothly and automatically.
  3. Achieving Greatness: With the data now flowing effortlessly, they are able to achieve what they set out to do. What once appeared to be a stumbling block has now been transformed into an opportunity for success. ⚡

A Lesson in Collaboration

This small act serves as a reminder that the world of tech and magic isn’t just about competition or looking out for yourself. It’s about collaboration, and lending a helping hand when others need it. By sharing our phone number and providing the cloud flow proxy, we helped The Name Who Must Be Named overcome their challenge and achieve their goals. After all, Slytherin doesn’t just win—it helps others win too.


House Points for Slytherin! 🐍✨

In the end, it wasn’t just about solving a problem. It was about showing that even in a world where magical and technological solutions reign supreme, it’s always the people who make the most difference. By using cloud flows and proxy magic, we’ve not only enhanced our own capabilities but helped our fellow wizards and witches soar.

Just remember: It’s not about the victory, but about making sure everyone’s journey is as seamless as possible. And Slytherin is always here to help. 🖤

Update Your ALM – The Hipster Way

🧑‍💻 Update Your ALM – The Hipster Way 🎩

In the world of Application Lifecycle Management (ALM), being a hipster isn’t just about wearing glasses and drinking artisanal coffee. ☕ It’s about using the latest tech and best practices to ensure your solutions are compliant, governed, and respectful of privacy. Here’s how we’ve upgraded our ALM setup to be as sleek and modern as a barista’s latte art. 🎨


🌟 Delegated Deployment with SPNs

The backbone of our ALM setup is delegated deployment using a Service Principal (SPN). This ensures that our deployment process is:

  • Secure: Using the SPN credentials, we minimize risks of unauthorized access.
  • Streamlined: Delegated deployment allows automation without compromising governance.

Key configuration steps:

  1. Set “Is Delegated Deployment” to Yes.
  2. Configure the required credentials for the SPN.

UAT:

PROD:


📜 Approval Flows for Deployment

Governance is king 👑, and we’ve built a solid approval process to ensure that no deployment goes rogue:

  1. Triggering the Approval:
    • On deployment start, a flow triggers the action “OnApprovalStarted”.
    • An approval request is sent to the administrator in Microsoft Teams.
  2. Seamless Collaboration:
    • Once approved, the deployment process kicks off.
    • If rejected, the process halts, protecting production from unwanted changes.

📢 Teams Integration: Keeping Everyone in the Loop

Adaptive Cards are the stars of our communication strategy:

  1. Monitoring Deployments:
    • Each deployment sends an adaptive card to the “ALM” channel in Microsoft Teams.
    • Developers and stakeholders can easily follow the deployment routine in real-time.
  2. Error Alerts:
    • If a deployment fails, an error flow triggers and sends a detailed adaptive card to the same channel.
    • This ensures transparency and swift troubleshooting.
  3. Release Notes:
    • Upon a successful production deployment, a flow automatically posts an adaptive card in the “Release Notes” channel.
    • End users can see the latest updates and enhancements at a glance.

🛡️ Why This Matters

Our upgraded ALM setup doesn’t just look cool—it delivers real business value:

  • Compliance: Ensures all deployments follow governance policies.
  • Privacy: Protects sensitive credentials with SPN-based authentication.
  • Efficiency: Automates processes, reducing manual intervention and errors.
  • Transparency: Keeps all stakeholders informed with real-time updates and error reporting.

💡 Lessons from the ALM Hipster Movement

  1. Automation is Key: From approvals to error handling, automation reduces the risk of human error.
  2. Communication is Power: Integrating Teams with adaptive cards keeps everyone in the loop, fostering collaboration.
  3. Governance is Non-Negotiable: With SPNs and approval flows, we’ve built a secure and compliant deployment pipeline.

🌈 The Cool Factor

By blending cutting-edge tech like adaptive cards, Power Automate flows, and Teams integration, we’ve turned a routine ALM process into a modern masterpiece. It’s not just functional—it’s stylish, efficient, and impactful.

Nasty Hacker: The Art of Superdirty Hacks for Super Cool Maps

🕵️‍♂️ Nasty Hacker: The Art of Superdirty Hacks for Super Cool Maps

Some call it hacking; we call it creative problem-solving. With our interactive map powered by Azure Blob Storage, we’ve embraced the Nasty Hacker badge by employing ingenious, slightly “dirty” hacks to achieve unparalleled awesomeness. 🚀

Here’s the story of how we turned Power Apps, Azure Blob Storage, and polling magic into a real-time tracking solution for our villainous missions.


🗺️ The Interactive Map: Where the Magic Happens

Our interactive map isn’t just another pretty visual—it’s a real-time tracker that:

  • Displays the location of targets and hitmen.
  • Shows reward information for completed missions.
  • Updates seamlessly across PCs, tablets, and mobile devices.

But the secret sauce lies in how we use Azure Blob Storage to make it all work.


📂 Hacking Azure Blob Storage

Here’s where things get delightfully dirty:

  1. Location Overwrites 🖊️
    Every time a target or hitman moves, the Power App writes their updated location to a JSON file stored in Azure Blob Storage.
    • The JSON file is overwritten on every update, ensuring that only the latest information is available.
    • By replacing rather than appending, we avoid bloating the file and keep things lightweight.
  2. Polling for Updates 🔄
    The interactive map uses a polling mechanism to continuously fetch the latest JSON file from Blob Storage.
    • The map checks for updates every few seconds to maintain near real-time accuracy.
    • This allows users to track movements live without needing a complex back-end setup.
  3. Dirty Hack Magic 🧙‍♂️
    • Instead of a sophisticated event-driven architecture, we rely on frequent overwrites and polling.
    • Is it the cleanest solution? No.
    • Does it work like a charm? Absolutely.

🔧 How It All Fits Together

Power Apps:

  • Sends location data (targets, hitmen, rewards) to Azure Blob Storage via Power Automate flows.
  • Provides the front-end for mission tracking and user interaction.

Azure Blob Storage:

  • Acts as the central repository for real-time location data.
  • Efficiently handles frequent overwrites without breaking a sweat.

Interactive Map:

  • Fetches the JSON file from Blob Storage at regular intervals.
  • Renders the updated data using Google Maps API, ensuring a visually stunning and responsive experience.

💡 Why This Hack Works

Our “nasty” solution solves a business need while keeping development quick and lightweight:

  • Real-Time Updates: Track movements and rewards without complex integrations.
  • Scalability: Azure Blob Storage handles frequent writes and reads effortlessly.

⚠️ Lessons from the Dark Side

While we’re proud of our hack, it’s not without its caveats:

  • Polling is Resource-Intensive: Frequent polling can increase resource usage.
  • Overwrite Risks: A race condition could occur if multiple users update the same JSON file simultaneously.

These risks remind us that even the best hacks require thoughtful implementation.


🏆 Why Nasty Hacks Rock

Sometimes, the dirtiest hacks lead to the most magical solutions. By combining Azure Blob Storage, Power Apps, and a dash of creativity, we’ve created a real-time interactive map that delivers on both functionality and flair.

“Hacks might be nasty, but the results are downright awesome.” 🧙‍♀️✨

Enchanting AI Face Recognition

In a world where wizardry meets cutting-edge technology, even the darkest assignments get a modern twist. Welcome to “The Dark Side of Harry Potter” Canvas App, where users verify their “assignments” (yes, kills 🪦) using the enchanting power of Azure Face API and Azure OpenAI.

This isn’t just tech; it’s a spellbinding mix of mystical AI, intuitive designs, and enchanted workflows. Let’s dive into how this solution flips bits, turns heads, and perhaps, toys with an existential threat to the world.


🖼️ Capturing the Kill

Step into the dark arts of delivery confirmation:

  1. Snap the Moment: Users submit photographic evidence of their completed assignments via the app.
  2. Cast the Spell: The image triggers a Power Automate flow, sending it to Azure Face API for identity matching.
  3. Instant Confirmation: With a calculated similarity score, the app declares success with magical flair: “Assignment Complete!”

🔍 How AI Face Recognition Works Its Magic

Azure Face API isn’t just a tool; it’s the wand wielded behind the curtain. Here’s its spellbook:

  1. Facial Feature Analysis 🧙‍♂️
    The “kill” image is analyzed for key facial landmarks: eye position, jawline curves, and more. Each unique marker is measured with surgical precision.
  2. Image Comparison ⚖️
    Uploaded images are cross-referenced with pre-stored profiling images, calculating a similarity score based on:
    • Alignment of facial landmarks.
    • Proportions and symmetry.
    • Subtle markers that make faces unique.
  3. Real-Time Results
    With wizard-like speed, Azure Face API returns results to Power Automate in mere seconds. If the similarity score passes the threshold, the dark deed is verified.

🧠 Adding AI Sorcery with Azure OpenAI

We’ve upped the ante by integrating Azure OpenAI to enhance verification. Here’s what makes it extra enchanting:

  • Landmark Precision: OpenAI uses facial attributes like eye spacing, nose position, and cheekbone structure to calculate distances between landmarks.
  • Magic Math: These distances are used to generate a similarity score with almost clairvoyant accuracy.

But wait… does this tech have a conscience? Does it think? Could it outsmart a 5th grader? Maybe even you?
By embracing such advanced AI, we’ve tiptoed into an existential risk realm:

  • Risk or Reward? The tech is smarter, faster, and eerily close to independent thought.
  • Conscience in Code: What if it started deciding on its own? Could it be charmed—or is it the new Dark Lord in disguise?

The response from the AI after verifying the image has been run through magic.


📲 Integration: A Solution for Every Platform

This isn’t just an app—it’s an omnipresent force:

  • Embedded Everywhere: From Phone to PC, the app integrates seamlessly into every digital corner.
  • Flipping Bits with Power: Whether on a desktop, tablet, or phone, this solution works its magic across devices.

🌟 Casting a Spell with Technology

What makes this solution truly magical?

  • Intuitive Designs: The interface is sleek, responsive, and dripping with a mystical vibe.
  • Enchanted Workflows: Every process, from snapping the image to confirming the deed, flows like a well-rehearsed spell.
  • Business Value Meets Wizardry: By automating and verifying critical tasks, this app doesn’t just entertain—it delivers results.

⚡ The Bigger Picture: Wizardry Meets AI Risks

As we push the boundaries of AI and magic, we also recognize the need for vigilance. Azure OpenAI introduces risks we must respect:

  • Could this tech someday outthink its creators?
  • Are we summoning tools too powerful to control?

Yet, as any great wizard knows, power isn’t inherently evil—it’s how we wield it that matters. And wield it, we shall.


“With AI face recognition from Azure Face API and OpenAI, the lines between magic and technology blur into something truly extraordinary.” 🪄

Interactive Map: Bringing Dark Ledger’s Magic to Life

🗺️ Interactive Map: Mapping the Shadows in Style

Our Interactive Map WebApp has masterfully combined modern technology, responsive design, and captivating aesthetics. Developed with React, TypeScript, SCSS, and enhanced with fancy CSS animations, this map is the perfect companion for tracking the mystical operations of the Dark Ledger. With seamless integrations into Microsoft Teams and SharePoint, paired with automated deployments via GitHub Actions, this tool bridges functionality and style, solving critical business needs like a pro.


🔮 Magical Features

1. Interactive Tracking with Google Maps API 🌍

  • Dynamic Positioning: Real-time tracking shows the locations of both targets and hitmen.
  • Reward Insights: Visualize mission rewards directly on the map for clarity and motivation.
  • Custom Styling: The map is tailored to reflect the Dark Ledger’s mystical theme.

2. Cross-Platform Accessibility 🔗

  • Teams App: Add it directly to Microsoft Teams for quick and easy collaboration.
  • SharePoint Integration: Embed seamlessly into SharePoint sites to streamline workflows.
  • Responsive Design: Optimized for desktops, tablets, and smartphones—effortlessly adapting to any screen size.

3. Modern Front-End Excellence 🧙‍♂️

To ensure smooth performance and usability:

  • React Framework: Modular, high-performance components enable fluid interactivity.
  • State Management: Redux or Context API ensures dynamic updates without skipping a beat.
  • Streams: Real-time syncing keeps the map fresh and up-to-date.
  • SCSS: Powers cohesive, flexible, and maintainable styling.

4. Dazzling CSS Animations

  • Fluid Transitions: Map markers and interface elements move gracefully, like spells in motion.
  • Hover Effects: Intuitive highlighting guides users effortlessly through the map.
  • Polished Touches: Every button, icon, and menu interaction feels alive and engaging.

5. Automated Deployments with GitHub Actions 🤖✨

The app is built for agility and reliability:

  • CI/CD Pipeline: Changes pushed to GitHub are automatically deployed to our Azure-hosted web app using GitHub Actions.
  • Efficiency: Ensures the latest features and fixes are available to users without manual intervention.
  • Azure Hosting: Provides a robust, scalable platform to support the app’s responsiveness and performance.

💼 Solving Real Business Needs

This isn’t just an enchanting app; it’s a powerful business tool:

  • Operational Insights: Tracks locations and rewards in real time, empowering decision-making.
  • Collaboration Simplified: Embeds directly into Teams and SharePoint, making it easily accessible for all users.
  • Efficiency Boost: Automates key processes and eliminates the manual hassle of location tracking.

🌟 Built for Versatility and Performance

Why It Stands Out:

  • Responsive Design: Ensures usability across all devices and screen sizes.
  • Modern Tech Stack: Leverages React, SCSS, and state management for a seamless experience.
  • Automated Deployments: GitHub Actions streamline updates and ensure consistent quality.
  • Azure Hosting: Provides a stable and scalable backend for flawless performance.

🖤 Enchanting Efficiency

With React, SCSS, Google Maps API, and Azure-hosted automation, our Interactive Map WebApp stands as a spellbinding example of innovation. Whether you’re plotting missions or tracking rewards, this tool ensures you’re always ahead, wrapped in elegance and functionality.

“When modern magic meets technical wizardry, the results are simply spellbinding.” 🧙✨

Dash It Out – Crafting Enchanting Dashboards

🏅 Dash It Out Badge – Crafting Enchanting Dashboards 📊✨

Welcome to the magical world of data visualization! We’ve summoned the powers of data and design to create a visually stunning dashboard integrated seamlessly into our Model-Driven App and Power Pages. This dashboard is not just a feast for the eyes but also a vital tool for tracking the Dark Ledger’s performance metrics and ensuring operational excellence.


Dashboard Highlights ✨📈

Our dashboard is designed to provide business value while capturing the mystical essence of the Dark Ledger. Here’s how we’ve structured it:

1. Leaderboard – The Hall of Infamy 🥇

  • A dynamic ranked list showcasing the top villains based on completed orders.
  • Metrics:
    • Villain Name 🧙‍♂️
    • Number of Completed Orders ✔️
    • Success Rate (%) 📈
  • Purpose: Encourages competition among villains while highlighting high performers.

2. Success Rate – The Measure of Mastery 📊

  • A sleek gauge graph visualizing the average success rate across all villains.
  • Business Value: Offers insight into operational efficiency and highlights areas for improvement.

3. Order Distribution – Workload Balance 🥧

  • An interactive pie chart showing the proportion of orders assigned to each villain.
  • Purpose: Ensures fair workload distribution and identifies underutilized or overburdened villains.

4. Highest Paid Villain – Who’s Earning the Most Gold? 🤑

  • A compelling bar chart that highlights the top-earning villain based on revenue from completed orders.
  • Metrics:
    • Villain Name
    • Revenue Generated
  • Business Value: Identifies revenue drivers and fosters friendly rivalry among villains.

DAX Magic 🪄📋

Behind the scenes, we’ve worked our DAX wizardry to create calculated measures that drive these insights. From aggregating revenue to calculating success rates and ranks, our formulas ensure that every metric is accurate and meaningful.


Why It’s Magical 🌟

  • Integrated Design: The dashboard is seamlessly embedded within both our Model-Driven App and Power Pages, making it accessible to all Dark Ledger users.
  • Actionable Insights: These visuals empower administrators to make informed decisions, optimize performance, and celebrate top performers.
  • User-Friendly: With intuitive graphs and clear KPIs, even the darkest wizards can navigate the dashboard with ease.

Sharing is Caring – Expanding the Circle of Knowledge

🏅 Sharing is Caring Badge – Expanding the Circle of Knowledge ✨🤝

In the world of magic, sharing knowledge is one of the most powerful spells you can cast. The Sharing is Caring Badge celebrates our commitment to openness, collaboration, and community growth. This time, our efforts took the form of opening up our interactive map repository to the public and contributing to a pull request for another magical team—The Team Who Must Not Be Named. 🧙‍♀️💫


Opening the Interactive Map Repo to the Public 🗺️🔓

In the spirit of sharing, we’ve unlocked the door to our interactive map solution and opened up the repo for public use. Our goal? To empower fellow wizards and witches to enhance and build upon what we’ve created, making the tool more accessible and usable for everyone. 🌟

This map, powered by Google Maps API, allows users to track Orders of Doom, pinpointing targets and requesters in real-time. By sharing this repo, we’ve invited the community to contribute, adapt, and build with us. We believe that magic becomes even stronger when it’s shared with others.


Contributing to “The Team Who Must Not Be Named” 🐍💬

In addition to sharing our own work, we’ve also been busy helping The Team Who Must Not Be Named (@inmeta). We contributed to a pull request (PR) on their GitHub repo for the academicCalendar project which is a Quidditch Calendar (SharePoint Framework) web part that displays the Hogwarts Academic Calendar using a calendar view. This web part is built using React and integrates with the react-big-calendar library to provide a rich calendar experience. Construct, insert custom events or connect to your own data.

Here’s what we did:

PR Overview:

  • Objective: Translate strings to Norwegian to improve localization for Norwegian-speaking users.
  • Translation Magic:
    • Translated UI strings into Norwegian for a more seamless user experience.
    • Updated environmental descriptions (SharePoint, Teams, Outlook) to Norwegian, ensuring that all app environments felt local and familiar.
  • Consistent Formatting: Ensured that the Norwegian translations kept the same structure and formatting as the original resource file to maintain consistency and functionality.

Before contributing, we forked the repo to ensure we had a clean copy of the project. By doing this, we were able to work on our own version, implement the necessary changes, and submit the improvements back to the original repository. This way, everyone can benefit from the updates, and the original team can review and merge them at their own pace. 🔄✨


Let’s continue to spread magic, one shared line of code at a time! 🌟🖥️💫

Community Champion Badge – Spreading the Magic

The Community Champion Badge celebrates going beyond our own goals to lend a helping wand to others. This time, the magic of collaboration brought us together with the enchanting team, The Broomstick Pilots, who sought guidance on harnessing the power of OneFlow.


A Knock on the Common Room Door 🚪💬

The Broomstick Pilots reached out, curious about our OneFlow setup and installation. With their inquisitive minds and an eagerness to learn, we knew we had to channel our inner Hogwarts professors to help them unlock the full potential of this amazing tool. 🪄


Spreading the Spell of OneFlow 📜✨

We gathered around and conjured a short but spellbinding introduction to OneFlow, showcasing how it can transform the way contracts are created and signed. Here’s what we shared with them:

  1. Getting Started:
    • How to set up OneFlow in their environment.
    • Connecting it to their workflows with a sprinkle of Power Automate magic.
  2. Why OneFlow is a Game-Changer:
    • Effortless collaboration on contracts before signing.
    • Seamless e-signature functionality on any device.
  3. Tips and Tricks:
    • Integrating OneFlow with Dataverse for centralized contract management.
    • Using templates to speed up the contract creation process.
  4. Encouragement:
    • We cheered them on to experiment and build something unique with OneFlow, assuring them they were just a few incantations away from something incredible. 🌟

Why We Helped 💛

At its core, being a Community Champion means embracing the true spirit of wizardry: collaboration, knowledge-sharing, and lifting others to greatness. The Broomstick Pilots’ excitement reminded us why we love working with these tools in the first place—it’s all about creating magical experiences together.


Spreading the Magic Doesn’t Stop Here

This badge is a reminder that every great wizard (or developer) started somewhere, and sometimes, all they need is a nudge in the right direction. Whether it’s a spell, a script, or a step-by-step guide, sharing knowledge makes the entire community stronger.

To @prosesspilotene (The Broomstick Pilots, it was a joy flying alongside you! 🧹✨ We can’t wait to see what magical solutions you conjure up with OneFlow.

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. 💀