Mining into Peach’s Kingdom

With this post we claim the badges:

  • Dataminer – for using dataverse as a datasource in Power BI, with data from the games.
  • Plug N’ Play – for embedding the Power BI report into teams.

The data from the Power BI report is coming from a table in dataverse called “Leaderboards”. You have the score of each player for a certain game, and what number of try there was for that game. We then use this data in the Power BI report to show all of the players score in a dashboard. There is also the possibility of seeing one specific players data. Which is of course presented in the same graphical theme as the other apps.

And of course it doesn’t stop there. We then also made sure to embed the Power BI report into Teams. Into our Peaches-team where we can then keep track of the players progress. The report addresses a crucial business need by allowing us to efficiently track and analyze the progress of players in the various games. We can then make data-driven decisions, like seeing which game the kids find more fun and entertaining. This can then be used to further develop games for the kids, and enhance their learning experience. Which will allow us to constantly evolve and improve.

Piping our way through the Azure Cloud

To make our amazing service Tubi work, a lot of cloud is needed. We aim to make the plumber’s job easier by recommending the best layout for where the pipes should go, and for that, we need AI. We have trained a model in Custom Vision to recognize all components in a bathroom that need water. So, when the plumber uploads a floor plan to our Static Web App, the image is sent to our Azure Function App backend in C# Asp.net through our own API. But both the image and the equipment list must be stored somewhere. Therefore, we have also connected to Azure Blob Storage. Then last but not at all least. The people working in the back office have instant interactive reports available to help them with filing and billing through Power BI and alerting the using an automated flow (Badges: Feature Bombing)

Sometimes it works, and that’s plenty

Databases are good, but sometimes it’s easier to just dump everything in one place until you need it again. Yes, it might not be very scalable or very normalized. SQL became too heavy, and we already needed a Blob storage to store the images, so we also dump the order data in the same blob storage as JSON files. It’s old fashioned way of serverstorage, and a bit dirty, but it works! (Badges: Nasty hacker, Retro badge)

Power the backoffice

As the final list of components are decided, they still have to be approved from the accounting team in the office. To make sure they have all the information they require, we have developed a Power BI dashboard to crawl through our registered data and make sure the orders are handled properly (Badges: Crawler, Dash it Out, Dataminer). And to make sure the orders are handled easy and fast, the dashboard is embedded into teams and an alert is automated by using a logic app to make sure the workers can receive and cooperate in realtime (Badges: Embedding Numbnuts, Go with the flow, Pug N’ Play, Power user love, Right Now, Stairway to heaven).

Plug N’ Play Badges – Send reward to the customer

Behold, as the final flourish to this grand adventure, the customer’s inbox lights up like a beacon of achievement! With a twinkle in its digital eye, the Microsoft Outlook connector springs into action, delivering a virtual diploma straight to the customer’s awaiting hands. It’s not just an email; it’s a messenger of triumph, carrying the seal of excellence from the Awesome Plumber Firm. With every diploma received, another customer joins the ranks of plumbing champions, their victory celebrated far and wide in the kingdom of email!

Imagine the triumphant moment: the work order completed, the last wrench tightened, and voila! Like magic, a path unfurls in the digital realm, leading straight to the treasure trove of work order documents! It’s like discovering a hidden treasure map in the depths of SharePoint! Every document, every detail neatly arranged along the path, beckoning with the promise of knowledge and accomplishment. With each completed task, another chapter is added to the epic saga of plumbing prowess, all waiting to be explored in the enchanted halls of SharePoint!

Analog Odometer Visualisation through PCF – Make it rain!

While this is a great visualisation, we must announce that the CSS and JS was not created by us, but by the great Developer VictorNP, which proposed a vanilla JS solution which we transformed into React functional components. As stated by the designer, It is mainly designed to be a read-only component used to display information – Therefore we’ve limited to bounded context fields.

This is an great example of how the limited possibilities of Dashboards in Dynamics directly, can easily be mitigated, as well making the visualisation reusable for different contexts through PCFs, making custom, code-first visuals in our Low-code solution. By harnessing the power of client-side processing, we ensure that our solutions are not burdened by heavy monolith front-ends, guaranteeing a seamless and responsive user experience every time. Of course, memorisation is applied to improve the transitions and performance of the visualisation.

The PCF component on a CRM form

Moreover, the PCFs functions as plugins for Power Apps, which further enriches the user experience through customisation. Our use cases will be mostly related to displaying important business and plumbing related KPI’s to keep track on the current state of our business. Lastly we wanted others to be able to reuse this visual and provide improvements to it, so we Open sourced it and made available on Github! Contributions are very welcome!

Star world to the cloud

Choo choo! All aboard the star train to the microsoft cloud! The sole action of finding and identifing bananas is not enough. We need to alert people of the danger that has been detected in traffic before they can cause more harm.

Introducing the Banana Notifier Bot (BnB):

The BnB helps our users by sending teams notifications when bananas have been detected.It uses our notification API (which gets data from our banana-scanning app), Bing Maps API and Graph API with location data and timestamp.

Our Notification API also utilizes the SharePoint REST Api to fetch next of kin information from a SharePoint list. Lastly, we store all our banana findings in Dataverse using the Dataverse Web API. Utilizing a total of four (!) Microsoft APIs.

Find the right Mario for you

We claim badges:

  • Plug N’ Play – for Dynamics 365 plugin that updates Mario for each support request based on the context using OpenAI
  • The Existential Risk – for AI decision making and work assignment without human involvment
  • Go With The Flow – for automating of the technician assignment
  • Crawler – for an innovative approach of searching for the right Mario technician

Sometimes Princesses are confused and don’t know where to start from when they have technical issues. So we are here to help them with AI! Princesses just need to add the description of the problem and the Dynamics Plugin will suggest Marios that are currently available and best match the case.

So the Princess creates a new support request, and that’s were plugin is triggered. The plugin sends the problem to OpenAI’s smart ChatGPT. The prompt:
Given the following case description, rate its severity on a scale of 1 to 4, where 1 is minor and 4 is critical:

I seem to be having a bit of a predicament with our kingdom’s email system, and I’m in dire need of assistance. This morning, when I attempted to send out invitations for the upcoming royal ball, I noticed that none of my emails were being delivered. They seem to be stuck in the outbox, and no matter how many times I try to resend them, they simply won’t go through.

The result of the OpenAI request is the severity level, in our case it is 3. So the plugin is looking for Marios who can cope with this severity and assigns the case to this Mario. Also, plugin updates the details of the case:

It is an extraordinary way to search for an engineer, but also a risky for administrators of the support team, as AI is taking away their job! On the other hand – it follows the flow and automate the routine process, which is a major benefit for the business itself….

Bowser Quiz

With this blog post we aim for the Go With The Flow, The Existential Risk, Mario badge and Plug N’ Play.

  • The Mario Badge for the gamification of Copilot.
  • The go with the Flow and Existensal Risk, because the use of Prompts with CHAT. One prompt to check if answers are correct or not The other prompt tells if the answer is Correct or Incorrect and will use this to send an action to power automate to populate a dataverse table.
  • The plug N´play for the use of prompt plugins in copilot.

Video of the in progress solution:

Steps:
Opening the admin center at https://aka.ms/ppac

Enabled Copilot for the Environment:

The Copilot component is ON in Canvas App:

Copilot

Found a website with Mario facts: https://kids.kiddle.co/Mario
Also uploaded a PDF with mario facts.

Conversation start

Conversation end or start again

  • Tested Generative AI inside the copilot studio, got answers, but could not check the answers with generative AI, it was good to give the answers, but not good to check if the answers is correct.
  • Made a power automate flow that generates a text with AI builder. – But it had limitations, it stopped with that you had to have an approval of text before i could process it.

So the next step i did was to try the new Prompts in Copilot studio: (It took many iterations of the prompt to make the copilot say if it was correct or incorrect).

Started making the Quiz topic that is the “game”, to test if it would work like i thought:

It works

Next STEPS:

Send correct answer to dataverse table to score a point:

Add the Copilot(chatbot) control to the canvas app:

Harnessing the Power of PromptFlow: Introducing Our Plug N’ Play Bot Service for Microsoft Teams

Revolutionizing Team Collaboration with PromptFlow

In our latest venture, we’re excited to introduce a cutting-edge bot service integrated into Microsoft Teams, marking our claim for the “Plug N’ Play” badge. This bot leverages PromptFlow technology to automate and streamline communication within Teams.

We have a dataset with 5000+ races with statistics on race performance. With the AI-chat bot, the users will save time when deciding on their strategy for upcoming races. The natural language model makes it easy for the user to ask questions such as, which players have the best lap time on certain maps, what kart usually performs better and so on.

Technical Highlights

  • Built on Microsoft Bot Framework for robust conversational AI experiences.
  • Seamlessly blends into Microsoft Teams, enhancing the platform’s collaborative efficiency.

Future Prospects

This bot is just the start of our journey in transforming business communication with cloud-based AI solutions. Stay tuned for more updates as we continue to innovate and redefine collaborative workflows.