Everyone can send a Howler! It is up to you. Post a message to our public API and it will be read out loud. Do note that the content of your message will be altered by our magical services. So please be careful of what type of sentiment you use.
{ “sender”: “Bellatrix”, “recipient”: “Sirius”, “sentiment”: “Angry but polite”, “subject”: “The end”, “body”: “You’re definitely fired.” }
The endpoint triggers a Power Automate flow that adds a new row to our Dataverse. A new flow triggers and sends it to our Python Flask app. And it connects to the Howler and reads out the message.har hurtigmeny
With this blog post we claim the oneflow and the Link Mobility sponsor badge
We also claim these badges:
Because we connect external data from oneflow to dataverse
Is only natural, given that it’s Power Automate flow that is used to orchestrate the whole thing
And
But this “Sharing and Caring” badge is for someone else <3
Oneflow
OneFlow has allowed us to create diplomas for wizards who graduate from our potions and spells program. Whenever a wizard or witch has reached the highest level, they will get a diploma signed by Dumbledore himself.
The diploma is created in Word and exported as a PDF.
We uploaded it to oneflow and created it as a contract to be signed.
We enabled the API for Power Automate Flow
Setting up the Power Automate flow to create a contact with oneflow, add a participant and then publish the contact. Then we create a new row in the Diploma custom table in Dataverse where we connect the contract to the wizard (contact).
We receive an email with the confirmation that we have received the diploma.
And the link takes us to the document
Link Mobility
Setting up the connection reference is easy
Then we add the action to send an SMS to the wizard to notify them that they have graduated!
Triggering the flow will send an SMS with the link to view the diploma!
Sharing is caring: For “Pass me a Sock”
We were too late sending information about our http endpoint to Link Mobiliy, but “Cooky at “Pass me a sock” came to our rescue, and shared their credentials with us. Without them we wouldn’t have been able to set up the connection and successfully send SMS’s. Thank you Cooky! Sharing really is caring <3
Greetings, wizards, witches, and benevolent hackathon competitors! ✨
At Team PowerPotters, we take feedback seriously—almost as seriously as a Slytherin takes their ambition. After receiving feedback on our initial Sharing is Caring submission, we’ve reflected, regrouped, and risen to the occasion with an updated act of collaboration and generosity.
So, we’re here to make another attempt—not just to earn the badge, but to truly embrace the spirit of sharing.
🪑 Giving Up Comfort: A Tale of Slytherin Generosity
Every great hackathon wizard knows the importance of a comfortable setup. With long hours of spell-casting (and coding), having the right chairs can be the difference between a productive sprint and a stiff back. That’s why we came prepared with enchantedly comfortable chairs to keep us focused and energized.
But when we saw our fellow Slytherin team, The Golden Snitches, struggling with their less-than-magical seating arrangements, we couldn’t sit idly by (pun intended). In the true spirit of Sharing is Caring, we shared our comfortable chairs with their team, even though it meant sacrificing some of our own comfort.
Why did we do it? Because we believe that no Slytherin should struggle when another has the means to help.
✨ Why This Act Embodies the Badge Criteria
Here’s how our act aligns with the Sharing is Caring badge requirements:
Sharing Resources: We gave up a valuable resource—our comfortable chairs—for the benefit of another team. This gesture wasn’t just a token of goodwill but a meaningful contribution to their experience at the hackathon.
Building Connections: By helping another team within our house, we strengthened the bonds of camaraderie and showed that even Slytherins know the value of cooperation.
Rising Above Feedback: The judges’ comments inspired us to think beyond technical contributions and recognize the impact of tangible, human gestures.
🐍 Reflections on Feedback and Growth
The judges’ feedback reminded us that true collaboration isn’t just about integrating APIs or sharing tools—it’s about making a positive impact on others, no matter how big or small. This experience has reinforced the importance of stepping outside our own bubble and thinking about how we can lift others up.
We hope this second attempt demonstrates our commitment to the Sharing is Caring badge and the values it represents.
🔮 A New Chapter of Sharing
As proud members of House Slytherin, we’ve proven that ambition and generosity can go hand in hand. Whether it’s a seamless API integration or something as simple as a comfortable chair, we’re here to make a difference—not just for our team but for the hackathon community as a whole.
We humbly submit our revised case for the Sharing is Caring badge and thank the judges for pushing us to grow and embody the true spirit of this challenge.
🏅 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! 🌟🖥️💫
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 configuredSchedueled 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:)
Greetings, cunning wizards and resourceful witches of ACDC 2025! As proud members of House Slytherin, we know that greatness is achieved through ambition, strategy, and working together to rise above the competition. This year, Team PowerPotters has embodied these traits, collaborating closely with our fellow Slytherin allies, Team SlytherIN, to weave a tapestry of innovation and shared success.
Here’s why we believe we’ve earned the Sharing is Caring badge:
🐍 1. The Spell of Ambitious Collaboration: Potion Logistics Meets Text-to-Voice
Slytherins are known for their resourcefulness, and this year we proved it by integrating our potion production system in Dynamics 365 Finance and Operations with the text-to-voice API developed by Team SlytherIN. Together, we brewed a solution greater than the sum of its parts:
Trigger: Potion production completion in D365 kicks off a Power Automate flow.
Action: Potion details (like name, quantity, and batch ID) are enchanted into a letter-worthy format.
API Call: The formatted letter is sent to SlytherIN’s API, which works its magic to deliver potion updates through spoken word, turning dry data into a dynamic experience.
✨ The Slytherin Advantage:
For PowerPotters, this integration added an innovative notification system, making our potion production process as engaging as Snape’s Potions class.
For SlytherIN, the collaboration showcased their text-to-voice API’s practical value in a real-world integration, proving that their spellwork is as sharp as their ambition.
By combining our strengths, we showed that Slytherins don’t just excel individually—we dominate when we work together.
🧙♂️ 2. Sharing the Slytherin Spirit: A Gift for the Hackathon Community
True to the creed of ambition with purpose, we didn’t stop at benefiting our own house. To elevate the entire hackathon, we also created and shared a powerful AI-powered speech-to-text engine based on OpenAI Whisper API:
Accessible Web Server: We developed a hosted interface for our Whisper-based engine, enabling anyone to use its capabilities effortlessly.
Open Source: The complete project, including our polished code, is now available on GitHub. This allows all teams—whether from Gryffindor, Hufflepuff, or Ravenclaw—to adapt and build upon our creation.
✨ Why This Matters: By offering this resource, we ensured that our magic goes beyond House Slytherin and helps the entire hackathon community rise to new heights.
🪄 3. Proof That Sharing is (Cleverly) Caring
Here’s how our efforts align with the Sharing is Caring badge criteria:
In-House Collaboration: We embraced the strength of Slytherin unity by integrating our potion production solution with SlytherIN’s brilliant text-to-voice API, showcasing how housemates can amplify each other’s efforts.
Open Source Contribution: Our AI-powered speech-to-text engine is freely available, proving that the best spells are those shared for the greater good.
Slytherins are often underestimated when it comes to generosity—but we’ve shown that ambition paired with purpose creates the perfect potion for success!
🧪 Why This Matters to the Wizarding and Hackathon Worlds
Slytherin has long been a house of leaders, strategists, and innovators. By sharing and collaborating, we’ve demonstrated that success isn’t a solo endeavor. It’s about lifting each other up and building a legacy that will endure far beyond this hackathon.
🔮 Call to Action
With our ambitions fulfilled and contributions shared, we humbly request the judges to consider us for the Sharing is Caring badge. This badge represents the values of collaboration, resourcefulness, and leaving a lasting mark on the hackathon—values we’ve embodied as proud Slytherins.
Famous words spoken by Hermione Granger after they defeated the troll.
We have really felt the impact of this during this hackathon. When venturing into new territory and using tools and setting up applications that are new and unfamiliar, we often rely on documentation to get started. More often than not, at some point the documentation fails us and we are blocked from getting further. That’s when you need friends to help unblock you.
Like when Philip helped Emil to install the correct version of .NET on his new computer to enable him to finish setting up the tooling needed to build his first PCF component.
Ulrikke got help from Andy Wingate when she got stuck setting up Business Central as a virtual table in Dataverse. Andy jumped on a Teams call in the early morning hours to help unblock her.
Stig got help from unexpected sources when he got stuck setting up a trial for Fabric in our demo environmnent. Fredrik Engseth from another team – BUT the same Hufflepuff HOUSE as us, overheard our conversation and helped us figure our a smart hack to get Dataverse connected to a developer instance of Fabric, using a Service Principal with cross tenant permissions. Thank you Fredrik <3
Sharing really is caring, and like Hermione says,
“Books And Cleverness – There Are More Important Things; Friendship And Bravery”
The Fabricator weaves once more, blending magic and technology.
Here lies a compendium of Hogwarts students, their traits, and achievements—crafted with care, or perhaps conjured from thin air. Gryffindor bravery, Slytherin cunning, Ravenclaw wisdom, and Hufflepuff loyalty, all woven into this digital tapestry.
But beware, dear wizards and witches: is this a truth etched into the annals of Hogwarts or a clever fabrication of the Fabricator? Dive in, but remember—what you find may enlighten… or enchant.
Is this data fabricated or real, only the Fabricator knows.
Here is a photo proof of that our fellow Gryffindor team, Pass me a sock, did use our data set.
PS:
Community Champion: Goes out of their way to help and encourage other teams as we went out to first find all Gryffindor teams (thanks to @scott we managed to find them all, or almost all…) and then offered the MVP team “Pass me a sock” our help or contributions, which they highly welcomed as we felt 🙂
Sharing is Caring: Code, dataset or api is made available for other teams and you do a sensible contribution(pull request, Integration) on a competing teams solution.
PS2: we did not stop just there but also went to another neighbor team Dumbledore’s Developers as we had some synergies in our solutions in terms of their relation to Sorting Hat… And although they are from the different #ravenclaw house, and we complete between houses also, we are here to have fun, aren’t we? Which is why we decided to share some of our data with them too, and they succeeded with their use case, which they described in the following post The Power of Collaboration | Arctic Cloud Developer Challenge Submissions
By sharing resources with other teams, we’re not only helping each other grow but also collectively pushing the boundaries of what we can achieve. It’s about creating an environment where everyone’s knowledge and skills contribute to a larger, more impactful result. Plus, when we share, we learn from one another, which makes the whole process that much richer.
So, big thanks to SnitchOps @logiqapps for providing us their dataset
And we are lucky to provide them our iframe bot service!
