LOW CODE category and Crawler for social data

As a team, we have a primary goal: We help magic happen by utilizing modern AI approaches. 

We also understand that every student needs a mentor, but the number of available mentors is minimal today. Our idea is to introduce digital twins for available mentors, which would allow us to help a more significant number of students. To achieve that, we are using all available data about the mentors. But to keep it fresh and reliable, we must have the latest events in our OneLake. 

So, we implemented the LinkedIn profiles’ social crawlers to track all the mentors’ activities and events and suggest new potential mentors. 

We do that via the most modern and most straightforward way by utilizing the PowerAutomate Desktop: 

Then, the data will be collected and stored in an Excel spreadsheet, making it available for future processing with our Data Factory.  

The primary consumer of the data regarding upcoming events is the students, who use the complex search request to find the proper event by searching across different fields. Participation in community events potentially increases the chances of successful onboarding to the new school. 

Relevant search API functionality if covering 98% percent of the required functionality. Unfortunately, this API is unavailable on the Power Pages side. We implemented the Power Automate Flow from the portal, a wrapper around the original Dataverse API, to resolve that issue. 

On the portal side, we are using the Select2 component to implement autocomplete functionality. 

Power user love 2

Claiming the Power User Love for our app that helps teachers and administrators plan and execute classes for each semester. A combination of PCF component in a Model Driven app to help teachers set the end and start dates of semesters in one field.

More RETRO Tech, Modern minds (Bonus: Easter Egg)

Meet Dobby – our digital assistant for the Wayfinder Academy employees. Isnt it cute?

And this is how we low code consultants edited for before sitemap editor was added to the system 

while working on our solution, we’re taking a moment to celebrate the charm of retro tech—our trusty cabled mouse and earphones. 🎧🖱️

Why the throwback?

Reliability: No low-battery warnings when we’re mid-sprint or presenting at events.
Clarity: Whether it’s code reviews or customer conversations, the sound is always crisp, and the connection is solid.
Control: Sometimes, the best way to stay connected is with a literal connection.

Retro tech may not be flashy, but it keeps us focused on what matters—delivering solutions that work.

And, let’s be real, there’s something nostalgic about untangling those earphones. Who’s with us? 🙌

#Retro

PS: We did use C++ btw. Magic Mix with some Legacy: our journey implementing IoT device | Arctic Cloud Developer Challenge Submissions

The stairway of music to the sound of heaven’s voice… or something like that

While working on developing a feature in our beloved Canvas app featuring a slightly annoying for always being right, but very valuable helper in Hermione Granger, we decided that it was necessary to combine a couple of Microsoft Cloud APIs to get things going.

We have utilized the Azure OpenAI endpoint to deliver the user’s message to the “magificial” Hermione, and sending the response through to the Azure AI Text to Speech model. The speech model provides the voice returned to the canvas app.

As you can see, there has also been decided to store the audio files from the converstation in Azure Blob storage. Why?, you might ask. Well, paranoia given all the chaos every year. Anyway, they still promise to never listen to the files.

Claiming the Feature Bombing Badge: A HomePage That Does It All!

On popular demand, the Feature Bombing badge is back, and we’ve gone all in! Our SharePoint homepage has been transformed into a one-stop hub, where we’ve crammed in six amazing user features—all seamlessly integrated and designed to make sense. Here’s what we’ve packed in:

  1. QuickLinks to Houses’ Common Rooms
    Need to jump into your House’s Common Room in Teams? No problem! With a single click, you’re transported to your House’s virtual hub.
  2. Power App: This all-in-one application brings a variety of magical features right to your fingertips. Access essential tools for your daily adventures at Hogwarts and beyond:
  3. DobbAI (Copilot)
    Our very own AI copilot, DobbAI, is here to assist with insights, suggestions, and to make your life easier—think of it as a virtual helper at your fingertips.
  4. A React Calendar
    A fully interactive calendar ensures you stay on top of meetings, events, and deadlines. No more “oops, I forgot” moments!
  5. Power BI Report
    Keeping data-driven decisions in the spotlight, we’ve integrated a Power BI report to provide at-a-glance insights right on the homepage.
  6. Viva Engage Feed
    Stay socially connected with the Viva Engage feed. It’s your source for updates, posts, and conversations to keep the team spirit alive.
  7. News WebPart
    Never miss a beat with the latest news updates dynamically displayed to keep everyone informed.

This isn’t just a feature dump—it’s a thoughtfully designed hub where every tool has a purpose, and everything fits together like a well-oiled machine. Whether it’s collaboration, planning, insights, or communication, our homepage ensures it’s all just a click away.

With six fully functional and relevant features packed into one screen, we believe we’ve gone above and beyond to earn the coveted Feature Bombing badge. And hey, we made sure it all makes sense!

Here is what it looks like:

More is Less. Effective work with Feature rich Logiquill Portal

We hope you liked our Logiquill platform we demonstrated to you yesterday. With it, we really enable our Wayfinder academy employees to manage their work in more effective way, reducing operational stuff, manual work and all of it – by use of the technologies we describe below. Hence by saving time on those time consuming processes, they can allocate it to the more meaningful and strategic tasks. This is what we call Digital transformation.

At this portal, in the Admin view, we have features like (as displayed on the screenshot below):

  • Digital Twins of our judges (mentors), generated by AI, and connected to the database which has the custom survey tailored to guide the student thru questions, that helps to identify their values, aspirations, reactions to stress, etc.
  • Heart rate readings which is a real time data, coming from the Pulsoxymeter device.
  • Emotion recognition via the third party solution (more about this you can read here Unveiling Hidden Feelings with the Magic of AI | Arctic Cloud Developer Challenge Submissions)
  • Speech to text for the response on the survey.

Thieving Bastards

Harry Potter APIs

For our Hogverse solution, we’re tapping into multiple HP open APIs as our database for potions, spells, spell books, and more. This approach is brilliant because it eliminates the need to maintain our own database, ensuring our app is always updated with the latest magical content, staying in sync with the rest of the wizarding world! ✨📚

Stolen the wand cursor from the event committee themselves

We are of course so sorry for stealing this for the good people who have made this hackathon possible. Stealing an idea hurts more—it’s like swiping someone’s spark, not just their stuff!

However, we could resist adding something so fun and magical to our portal.

Large design code from The Golden Snitches

Also, got our hands on a Canvas App code for The Golden Snitches. It is a real art to create visual pleasing and responsive design. The code snippet for a whole screen with multiple vertical and horizontal containers, shadows, glossy containers, shadow boxes, HTML controlls – eeeeverything.

With this code be stole some very useful tricks to create our responsive and eye pleasing design in our canvas app here.

Conjure Your Insights – Dash It Out!

What is a student portal without a dashboard that keeps track of all magical achievements at Hogwarts? A personal Marauder’s map, but for the student’s academic journey! See learned spells and potions, behavior and subject progress.

The student dashboard of our application consists of these four sections, each summarizing the students performance in that section.

Behavior

This section is an up-to-date tracker for the students behavior. It fetches data from the student’s mischievements data. No mischievements? The students been a good wizard/witch!

This makes it easy to spot patterns in behavior across weekdays and quick visual comparison of mischievement frequency.

Friday seems to be a popular day for mischeivements…

Spellbook

A spell collection tracker. The dashboard displays the total number of mastered spells completion by providing a circular progress indicator with percentage

The current view shows 3 spells in total, with the Imperturbable Charm being the most recent addition (learned 2 hours ago). New spells automatically appear in the collection as they’re mastered.

Potions

The brewing progress tracker displays all successfully created potions. The dashboard currently shows 12 mastered potions, with the Death Potion being the most recent creation (47 minutes ago). Each potion is logged with its brewing timestamp and success status.

Subjects

The academic overview section totals all achievement points across subjects.

The system logs progress from the initial enrollment date in each subject, providing a comprehensive timeline of magical education advancement. The dashboard updates in real-time, ensuring accurate tracking of all academic activities at Hogwarts.

Detail view

Each card on the dashboard can be expanded to reveal more comprehensive information about the student’s progress. For instance, when expanding the Potion section, students can view their complete potion history, including ingredients, characteristics, and effects for each potion.

Practicing Development and Deployment Best Practices: Building and Releasing an SPFx WebPart

Building robust and reliable applications is more than just writing code—it’s about ensuring that the entire development and deployment lifecycle is efficient, repeatable, and error-free. In this post, we’ll share how we applied ACDC principles while developing and deploying an SPFx web part.

Core Tech Stack

  • SPFx: Framework for creating client-side web parts in SharePoint.
  • React: For building the user interface.
  • TypeScript: For type-safe development.
  • Azure DevOps: For CI/CD pipeline implementation.

Applying Development Best Practices

Version Control with Git

To ensure collaboration and proper tracking of changes, We used a Git workflow that included:

  • Feature Branching: Each feature or bug fix was developed on its own branch.
  • Test and Main Branches
  • Pull Requests (PRs): Changes reviewed through PRs to ensure quality and encourage peer review.
  • Main Branch Protections: Enforced policies such as requiring PR reviews and passing CI checks before merging to main.

Code Quality Checks

Code quality was enforced through:

  • ESLint and Prettier: Automated linting and formatting checks.
  • TypeScript: Leveraged TypeScript to catch type-related errors during development.
  • React Project Structure:

assets/: For static assets such as images or styles. This structured approach improves maintainability, readability, and scalability of the codebase.

components/: For reusable UI components.

services/: For logic interacting with APIs or SharePoint data.

utils/: For utility functions.

Overview of the Pipeline

CI/CD Pipeline: Automating Build and Release

The CI/CD pipeline was set up in Azure DevOps and included the following stages:

1. Build Stage

  • Trigger: The pipeline runs automatically on every push to main.
  • Tasks:
    • Install dependencies: npm install
    • Build the SPFx package: gulp bundle --ship
    • Package the solution: gulp package-solution --ship
    • Linting: Ensures no build-breaking errors.
    • Copy files from a source folder to a target folder
    • Publish build artifacts to Azure Pipelines

Our YAML for the main branch:

# Node.js
# Build a general Node.js project with npm.
# Add steps that analyze code, save build artifacts, deploy, and more:
# https://docs.microsoft.com/azure/devops/pipelines/languages/javascript

trigger:
- master

pool:
  vmImage: ubuntu-latest

steps:
- task: NodeTool@0
  inputs:
    versionSpec: '18.20.0'
  displayName: 'Install Node.js'

- task: Npm@1
  inputs:
    command: 'install'
    workingDir: 'SPFX.quidditchCal'

- task: gulp@0
  displayName: 'gulp bundle'
  inputs:
    gulpFile: SPFX.quidditchCal/gulpfile.js
    targets: bundle
    arguments: '--ship' 

- task: gulp@0
  inputs:
    gulpFile: 'SPFX.quidditchCal/gulpfile.js'
    targets: 'package-solution'
    arguments: '--ship'
    gulpjs: 'node_modules/gulp/bin/gulp.js'
    enableCodeCoverage: false

- task: CopyFiles@2
  displayName: 'Copy Files to: drop'
  inputs:
    Contents: '**/solution/*.sppkg'
    TargetFolder: '$(Build.ArtifactStagingDirectory)/drop'
    OverWrite: true
    flattenFolders: true

- task: PublishBuildArtifacts@1
  displayName: 'Publish Artifact: ClientsideSolutions'
  inputs:
    PathtoPublish: '$(Build.ArtifactStagingDirectory)/drop'
    ArtifactName: ClientsideSolutions

2. Release Stage

  • Artifacts: The SPFx .sppkg file is published as a pipeline artifact.
  • Deployment Tasks:
    • Automatically upload the .sppkg file to the SharePoint App Catalog using a PowerShell script.

Different Stages depending on branch and environment:

Key ACDC Principles in Action

Automation

  • Every build and deployment step is automated, reducing the chances of human error.
  • Triggers ensure that builds happen on every push to main, keeping the solution production-ready.

Continuous Testing

  • Static Code Analysis:
  • TypeScript for type checking.
  • ESLint to check for linting issues: consistent code quality adhering to standards.

Continuous Delivery and Deployment

  • Artifacts are built and ready for deployment in every run.
  • Automatic deployment to the SharePoint App Catalog ensures faster delivery to end-users.