For this hackathon, we integrated MappedIn into the Power Platform. They are a top provider of indoor mapping solutions, offering advanced tools for creating multi-floor maps and optimized direction systems, much like Google Maps for interiors.
We developed a PowerApps Component Framework (PCF) using MappedIn’s React-based SDK documentation. This allowed us to embed their robust mapping and navigation functionality directly into Dynamics 365. The solution enables users to visualize spaces, navigate between rooms, and even calculate optimal routes within buildings.
Example of the PCF showing the route to the Biology classroom.
To access MappedIn’s advanced features, we secured a paid trial by collaborating with their team, who were intrigued by our use case. This partnership not only enriched our project but also highlighted the value of integrating third-party APIs to accelerate innovation and improve user experience in the Power Platform.
At the heart of every wizard’s journey lies the need to explore their magical potential, refine their skills, and discover the path that best aligns with their unique talents. To ensure that every aspiring wizard receives the guidance and feedback they need to thrive, we are developing a comprehensive system of tests designed to evaluate their proficiency in the magical arts.
Our goal is to create a series of engaging and challenging tests that assess various aspects of magical performance. From spellcasting precision to advanced problem-solving under magical constraints, these tests will provide a well-rounded evaluation of each student’s strengths. The tests are tailored to reflect the critical abilities required in the magical world and are designed to immerse students in scenarios where their creativity and expertise are put to the test.
Upon completion of the tests, each wizard-in-training will receive a detailed assessment of their performance. But we’re not stopping there—our system will also include personalized recommendations for their future magical specialties. Whether a student shows promise in potion-making, or flying, they’ll gain insights into the areas where their talents truly shine. These recommendations are aimed at guiding them toward a fulfilling and successful magical career.
This innovative grading and evaluation system is powered by some of the most advanced tools in the tech world. By leveraging these powerful tools, we’re not just modernizing the evaluation process—we’re creating an enchanting and transformative experience for both students and instructors.
This isn’t just about grading; it’s about empowering the next generation of wizards to step into their potential. With a blend of tradition and innovation, these tests serve as a bridge between magical lore and modern technology. They ensure every student is prepared, inspired, and equipped to excel in their magical journey.
Hackathons should have fast-paced innovation, but what happens when your cutting-edge tools turn into the ultimate roadblock? Cue the spinning loading wheel, the save errors, and the tears of frustration in my Canvas App 😭😭😭😭
Enter: the retro hero. A humble Ethernet cable.
Turns out, some tech from the late ’90s still holds up today. The Ethernet cable provided a steady connection that Wi-Fi just couldn’t match, especially in a crowded hackathon environment. It’s a good reminder: sometimes the old ways really are the best ways.
Who knew that a hackathon in 2025 would end up feeling like 1999? All we’re missing is a Tamagotchi, a box of floppy disks, and a 56k modem. Next time, maybe we’ll bring those along too.
By using this external API https://hp-api.onrender.com/api/spells we got some spells professor Snape had hidden in the restricted section of the library! By this we add business value to our existing data by enriching the our dataset with Publicly available sources that consist of spells in the Harry Potter universe and therefore adding business value to our solution. And by that claiming the Dataminer Badge.
This is the magical world, where managing Quidditch teams, tracking player stats, and keeping an eye on team standings feels as easy as casting spells. That’s right, we have embedded a Power BI dashboard in our model driven admin app. Because even in the wizarding world, data visualization is essential. The reason for this is for the administrators of the app to have the opportunity of sending out news and stats to the app users.
It’s like having the Marauder’s Map, but for data – every player, team, and stat laid out in beautiful charts and graphs. And the best part? I don’t even have to say “Alohomora” to unlock the insights. They’re just… there.
Sponsor Badge (Resco)
We’ve implemented the Component for Date Handling in our Quidditch league management solution to track match dates and time slots with precision. Managing the league’s schedule is no easy task—without a proper system, it could turn into a scheduling dementor! By integrating this component into our form, we’ve ensured seamless date selection, reducing manual errors and making it easier for team captains and event organizers to stay on top of their game. The component helps maintain data integrity across Dataverse, ensuring all match details align like a well-cast Alohomoracharm—unlocking efficient workflows and automated reminders. With this magical addition, the league runs smoother than a Nimbus 2000, making it worthy of the badge
In this article, we’ll are being very serious and will discuss how to set up a DevOps schedule to call a PowerShell script for deploying an Azure Service Fabric application.
Previously, we created a pipeline to promote changes across Development, Test, and Production workspaces. However, a robust Application Lifecycle Management (ALM) process requires more automation. This time, we’ll use scheduled PowerShell scripts in Azure DevOps to streamline deployment tasks.
s
DevOps YAML Pipeline for Scheduled Deployment
trigger: none
schedules:
– cron: “0 2 * * *” # Schedule to run at 2 AM daily
displayName: Nightly Deployment
branches:
include:
– main
always: true
pool:
vmImage: ‘windows-latest’
variables:
ClusterEndpoint: “<your-cluster-endpoint>” # Endpoint of the Service Fabric cluster
AppPackagePath: “<path-to-your-application-package>” # Path to the application package
ApplicationName: “<application-instance-name>” # Name of the application instance
ApplicationTypeName: “<application-type-name>” # Application type name
ApplicationTypeVersion: “<application-type-version>” # Version of the application type
DeploymentPipelineName: “FabricDeployment” # Name of the deployment pipeline
SourceStageName: “Development” # Source environment for deployment
TargetStageName: “Test” # Target environment for deployment
DeploymentNote: “Daily Deployment” # Description or note for the deployment
steps:
– task: PowerShell@2
displayName: “Deploy Azure Service Fabric Application”
GitHub is designed for collaboration. By making your repository public, we’re inviting the community to participate by reviewing, providing feedback, reporting issues, or even contributing improvements. This demonstrates a clear intent to share and work together, which embodies the “Sharing is Caring” principle.
The Golden Snitches provided EVIDIosa, not leviosaaaa with a nice piece of YAML code for responsive containers in Power Apps. Sharing some nice design with competing teams 🙂
You know the moment when everything is ready with your application, and you need some data for proper testing? You could search the internet for a dataset, or you could write meaningless strings as data.
However, if your solution includes Power BI reports, you need accurate data so the reports display meaningful visuals.
We used AI to create historical data. First, we generated real data, then asked the AI to expand it using similar values.
We worked with the following tables:
Students
Grades
Courses
Activities
Results
Feedback
After expanding the student table, we asked the AI to generate the other tables one by one. In each prompt, we included the previously generated data so the AI would create new rows with matching IDs and related information. We also asked the AI to generate this data in a lore-friendly way. As a result, our data became very realistic: For example, Ravenclaw has the best grades overall, and brave students have the highest number of activities.
🪄 Claiming the OneFlow Sponsor Badge – A Wizard’s Journey 🏅✨
Here’s a glimpse into how we 🧙♂️, have used OneFlow’s tools to conjure something truly extraordinary.
OneFlow – The Enchanted Contract Master 📜✨
Welcome to the modern age of contract signing, where OneFlow transforms dull parchment into living, collaborative scrolls that can be signed seamlessly on any device. 🖋️ Whether you’re sealing a pact between Death Eaters or approving an Order of Doom, OneFlow ensures your contracts are as smooth as unicorn hair. 🦄✨
How We Cast the Spell
With OneFlow’s API, we created a spellbinding process to manage contracts for the sinister “Order of Doom.” Here’s how we conjured this masterpiece:
1. The Birth of an Order of Doom 💀🖋️
When a Power Page user (a dark wizard in disguise) creates a new Order of Doom in Dataverse, the spell is cast!
A cloud flow retrieves:
The wizard’s credentials (so we know who summoned the order 🧙).
The chilling details of their request.
2. Summoning the Contract 🔮📄
The cloud flow calls forth OneFlow’s API, using a mystical template pre-crafted in the OneFlow portal.
A contract is conjured between the Dark Ledger Party (us) and the requester (them).
The enchanted scroll is sent via owl 🦉—or email (muggles might not appreciate owls)—for e-signature.
3. Signing and Sealing the Pact ✍️⚡
A child flow monitors the pact’s status like an Auror watching for dark magic.
Once both parties have signed the contract, the spell completes:
An owl-email confirmation is sent to the requester. ✉️🦉
The signed scroll is attached to the timeline of the Order of Doom in Dataverse, ensuring it’s securely stored in the Ministry’s records (or our shadowy vaults).
Why This Wizardry Works
🧙♂️ Effortless Automation: The contract lifecycle is handled faster than a Hippogriff in flight.
🔮 Crystal-Clear Transparency: Both parties are guided through the signing process as if by the Marauder’s Map.
📜 Centralized Magic: Every contract is neatly stored, ready for future spells (or audits).
✨ Spellbinding Innovation: By fusing Power Platform and OneFlow API, we’ve created a process worthy of Dumbledore himself.
A first time for everything. I want to learn new spells and want to try fabric and power BI for the first time.
Testing import data to Power BI desktop – With both data import and Direct Query.
Setting the Data source credentials to get the queried data to the Power Bi Service.
Test is working – Now lets wave the wand and build!
Fabric
HACK:
Got help from a team in the same house – HUFFLEPUFF POWER.
We can not get the trial to work in our tenant that we have for ACDC, so i had to create a service principal user in the ACDC tenant – and make it available multitenant. And then use this service principal in fabric in my work tenant to get the data in there.
We want to make a lakehouse with fabric, so after the data is clean, we can use it in Power BI and also share the data with other instances that needs to use the data.
Made a new Lakehouse: WizardData
Made the connection to the ACDC tenant
Cleaned the data:
Did this for all 7 tables.
I could not get compliant with the Power BI for my work tenant. So i decided to use Power BI desktop direct query to get the data from Dataverse and build a dashboard.
Start of dashboard: To be continued.
One last comment – We helped another team with the HACK to get the ACDC data into another tenant. COMMUNITY! – SHARING IS CARING!
