To easly use the link mobility api we create a custom connector to integrate towards Link Moblity. To make sure we can keep track and controll the sms integration flow we use a message based integration with azure service bus and azure functions to handle the outgoing sms
As the figure over show:
With any kind of power automate flow, a custom trigger is avaiable to use to send sms towards link mobility
The Custom trigger is configured towards an azure function http trigger that taket the sms information and send it to a service bus
Another service bus trigger function picks up the message when and sendt it towards the link mobility api
A Service bus based sms integration provides a more robust system, as we are able in the backend to have control of the sms flow,
The Wisleys are well-known for their love of fun, games, and playful tricks on others. It seems they couldn’t resist adding a bit of mischief to the student exam experience! With the easter-egg-collection, students may encounter amusing animations if they happen to type certain keywords that trigger these surprises. It’s all in good fun, adding a touch of humor to the challenges:
In the bustling wizarding world of ACDC 2025, Team PowerPotters of House Slytherin is proud to present a solution that seamlessly blends ambition, efficiency, and a touch of magic. Our end-to-end workflow automation exemplifies how mundane business processes can be transformed into effortless, enchanted flows—earning us a rightful claim to the Go With The Flow badge.
Here’s how our system captures data, automates approvals, and brings the wizarding world closer to the efficiency of a perfectly cast spell.
🪄 The End-to-End Workflow: A Symphony of Automation
Our solution is built around a completely automated process that simplifies the once-complex task of potion production approvals. Here’s how we enchanted every step:
Data Capture from Sensors:
The workflow begins with a Raspberry Pi sensor, which detects the request for potion production. This could be triggered by measuring liquid levels, detecting potion ingredients, or a verbal incantation (voice command).
The Pi sends the captured data—such as the potion name, quantity, and other details—to a Power Automate flow.
Processing and Enrichment:
Once triggered, Power Automate processes the data, organizing it into a structured JSON format.
This data is then enriched with additional information, such as the production timeline, responsible Potion Master, and other key parameters.
Automated Approval Process:
Here’s where the magic of automation truly shines. Using Oneflow, a contract is automatically generated with the relevant potion details and sent for digital approval.
This ensures that every potion production request goes through proper oversight, with no manual intervention required.
Seamless Integration:
After approval, the system triggers the next set of actions, including inventory checks, raw material consumption in Dynamics 365 Finance and Operations (FO), and notifications for production teams.
The entire workflow is interconnected, ensuring no step is missed and no ingredient is wasted.
✨ Automation in Action: A Tale of Two Workflows
To showcase the power of automation, let’s dive deeper into two key components of our solution:
1. Sensor-Driven Data Capture
Imagine a potion cauldron equipped with a liquid-level sensor connected to a Raspberry Pi.
When the sensor detects the cauldron is ready, it automatically triggers a Power Automate flow, sending the production details for processing.
This eliminates the need for manual intervention, allowing Potion Masters to focus on their craft while the system handles the logistics.
2. Automated Approval Workflow
From the moment the Raspberry Pi sends its data, the system ensures that every step is approved.
A contract is generated in Oneflow, pre-filled with production details, and sent to the Potion Master for digital signing.
Once signed, the system seamlessly transitions to production, ensuring accountability and traceability at every step.
🐍 Why This Deserves the Go With The Flow Badge
Our solution is the embodiment of what the Go With The Flow badge represents: leveraging automation to enhance business productivity and streamline processes. Here’s why we deserve this badge:
End-to-End Automation: From sensor data capture to approvals and production, every step of our workflow is seamlessly automated.
Eliminating Manual Effort: By automating mundane tasks, our solution allows Potion Masters to focus on their expertise rather than paperwork or logistics.
Business Value: The integration of sensors, Power Automate, and Oneflow creates a scalable, efficient workflow that reduces errors, saves time, and improves traceability.
Slytherin Ingenuity: As proud members of House Slytherin, we’ve shown how ambition and resourcefulness can transform even the simplest processes into enchanted flows of efficiency.
🔮 The Magic of Flow
Our end-to-end workflow isn’t just about efficiency—it’s about bringing a touch of magic to every step of the process. Whether it’s capturing data from a sensor, automating approvals, or ensuring seamless integration, we’ve proven that the right flow can transform any process into an effortless experience.
We humbly submit our case for the Go With The Flow badge, showcasing the power of automation to simplify the most complex tasks. Follow our journey as we continue to innovate and enchant ACDC 2025: acdc.blog/category/cepheo25.
During the student registration process, we leverage the Face API to automatically zoom in on the user’s face for precision and accuracy. For more details, you can refer to the GitHub repository: ACDC/registerimage at main · sindrejv/ACDC · GitHub.
Additionally, we’ve added a touch of fun to the experience by integrating the easter-egg-collection, which triggers random figures to pop up unexpectedly, keeping the process entertaining and unpredictable. Check out the GitHub repository here for more information: ACDC/eastereggpcf at registerimage · sindrejv/ACDC · GitHub.
At Hogwarts, keeping students informed about their class schedules is crucial for smooth operations. To achieve this, we leveraged the power of automation and SMS notifications through the Link Mobility API.
Power Automate and Link Mobility API
We created a Power Automate flow that sends messages directly to students via SMS for reminders of all Hogwarts events. We also intend to use the API to trigger SMS to students when Finals/OWLs are approaching. By integrating the Link Mobility API, we ensured that messages are delivered promptly and reliably. This automation simplifies the process of notifying students about when and where their next big event is, reducing confusion and enhancing their overall experience.
How It Works
Data Retrieval: The Power Automate flow retrieves classes that is occurring that day from our database, Dataverse, once a day.
Retrieving student for that class: The flow then gets the related students to that class. and then their contact to access the mobile number in their contact record.
Message Formatting: The information is formatted into a clear and concise SMS when the date for an event is approaching soon.
SMS Delivery: Using the Link Mobility API, the SMS is sent to the students’ mobile phones.
Benefits for Hogwarts
Efficiency: Automating the notification process saves time for both staff and students.
Reliability: Students receive timely updates, ensuring they are always aware of their schedules.
Convenience: The SMS notifications are easy to access and read, making it simple for students to stay informed.
Conclusion
By integrating Power Automate with the Link Mobility API, we’ve created a seamless and efficient way to keep Hogwarts students informed about their classes. This innovative solution not only simplifies their work but also enhances their overall experience, demonstrating the power of automation in education.
Let’s yet again head into our newly created, yet quite fantastic and soon to be famous portals for the students of Hogwarts. With some great help from our ringing companions at Ctelo and Azure Communication Services we have provided the opportunity for students to connect, share, network, learn together and whatever you can imagine with this service.
As a signed in student you are able to call anyone, anytime. And remember: based on everything the students go through each year, it is definitely necessary to get time for some quality 1:1 talk every now and then.
Let’s try to call the charming, but quite unstable student Orryn Duskhollow to check in:
In our mighty Svelte project we have created an acsService.ts file providing the necessary logic and handling of an ongoing call, using the packages @azure/communication-calling, @azure/communication-identity and @azure/communication-common).
In Azure, we sat the whole thing up using an Azure Communication Service instance called “cs-hogverse” and configuring direct routing with a custom domain provided by Ctelo. I guess this is just another example of how skilled developers can work together to create values even in the magic world. Or perhaps the Ctelo guys are in-closet wizards themselves?
We all know that Power BI is a beautiful tool for dashboarding, but it’s always a tricky question of where to get the data from. It needs to be fast, and most importantly, it should be correct.
The traditional way, from what I gather, is using the CDS connector. Here, we get easily visible and editable tables.
Another way, which will also give us Direct Query connection mode, is a connector directly to Dataverse.
But what about Fabric? If we need to create many reports on the same data from the CRM, then it would be perfect to have our data in OneLake, create DataFlow Gen 2 to transform it, and have a shared data model that will be utilized by different reports, dashboards, apps, etc.
For that, there are several ways to do it. The most tempting one is just using a Fabric Premium subscription to create a Lakehouse and using Azure Synapse Link to sync the tables from PowerApps to Fabric.
Unfortunately, when you have a Lab environment, it is not possible to create the OneLake on a Fabric workspace for now. Hopefully, this will be fixed in the future.
Another way is to create a resource group and create Azure storage account in the Azure Portal. If the user has the correct roles and access, then we should, in theory, be able to load tables from Power Apps to this storage and load them into a Storage Blob container. This approach got us much further, and we received a beautiful message on Power Apps.
However, when we try to create a link, the tables get queued but never appear in the Blob Storage.
However, for us, this approach did not work as our work tenant was registered in a different region from the Azure workspace where we are developing our CRM system.
Conclusion: If you are thinking of using Fabric, ensure your solution and Fabric are in the same region and don’t use the lab user.
In the end, to have a beautiful, real-time updating report, we will go for the second approach described here: connecting directly to Dataverse and using Direct Query to have a real-time update of the changes.
We also used SharePoint to get images to visualize in the report, and Excel files (xlsx) for some test data.
With delicious pizza fueling our spirits, we’re proudly claiming three badges! In this blog post, we’ll dive in with the same courage and determination Harry displayed in the Triwizard Tournament.
💣 Feature bombing
From the very beginning, our goal has been to unite multiple platforms into one seamless, feature-packed experience with a Weasleys’ twist. On our homepage alone, users can:
Get sorted into a house.
Chat with friends.
Check the calendar for Hogwarts classes and social events.
Get help from Hermione Bot for academics or planning.
Team up with Prank Bot to mastermind mischief.
These features don’t just exist – they’re alive and interactive, ensuring the experience is magical, dynamic, and fun. We’ve officially mastered the art of feature bombing (without overwhelming) and are ready to claim this badge!
🦎 Chameleon
Our app is built with adaptability at its core, ensuring a magical experience no matter what device you’re using. Whether it’s the compact elegance of an iPhone 13 or the expansive screen of an iPad, our interface scales perfectly without compromising usability or design.
Below, you can watch a short video showcasing the app’s responsiveness in action. Magical, right?
And last but certainly not least, the…
🥳 Remarkable team spirit
Of course, we have to share with the world how incredible this weekend has been!
