We are already building a certification app where aspiring plumbers can complete levels to achieve the PLumber Certifications; PL-200, PL-400 and PL-600. As described in the linked blog post, a flow to create a badge in sharepoint is triggered when the level is completed. That flow has been modified by adding an action to create a diploma with ChatGPT.
We created a Custom Connector for OpenAI API i Power Automate to be able to access image generator.
The custom connector is added as an action in the flow. By getting the rank input from the trigger, we set the certification (rank 1 = PL-200). A prompt is added to the Image Generator-action, as well as other inputs (notice the quality input is set to “HD”). When the inputs are added, you can just Go With the Flow…
The URL of the Image Generator-action is added as file content to the new sharepoint file.
Each diploma is different every time it’s generated, making it impossible to replicate. This adds an element of exclusivity and value to the certifications earned through our app. You never know what to expect, much like something you might unearth from Pandora’s Box. The Excellent User Experience and Killer AI is impossible to overlook.
Take a look at two extraordinary certifications examples down below. Are your eyes just as blinded by The Glossy Pixels as ours?? Just look at the HD quality… And isn’t the italian typos a charming effect?
Adaptive solutions are always important as you no longer have any control on what kind of device the user is hacking along on.
Power Pages comes with pretty good responsive support out of the box
Responsiveness was once considered a kind of black art, but fortunately, most modern solutions now offer robust support right out of the box. However, when integrating Power Pages, bots, and canvas apps, seamless functionality from the start isn’t always guaranteed.
Embedding PlumbBot needed minimal adjustments to support responsiveness
What realy gave us a headacke was embedded canvas apps. Yes they do resize, but leaves a lot of uneeded blank space on the top of the page which makes the app “disapear” on a mobile device:
Unwanted spacing in the top
The solution might seem quite obvious to a seasoned frontend designer, but for those of us who are more accustomed to low-code plumbing, navigating through CSS, JS, IFRAMES oh my my…
So we spent the better part of the day chogging along, and finally, we arrived at a solution we were happy with.
The team is maintaining their exceptional spirit, working tirelessly into the night and starting bright and early.
Of course, having warp pipes that burst with candy always boosts morale, even in the early hours.
Speaking of candy, we continue our role as community champions, assisting other teams with technical inquiries and, in turn, receiving support ourselves (shout out to Peaches and the Donkeys!).
We also focus on maintaining the judges’ blood sugar (and liquid) levels, something we believe is important for the community.
We also continue to help out in other ways, embodying the true spirit of the competition.
We built a web-based platform that lets you chat with a custom Copilot that knows everything about plumbing – PlumbBot. The Copilot is created with Copilot Studio and integrated in our Power Pages app as a part of our Plumber as a Service (PLaaS), and it rocks two of the hackathon badges: Crawler and Hipster.
Crawler: Using search in an awesome way
The Copilot has a huge knowledge base on plumbing. By providing domain knowledge of plumbing and practical plumbing solutions through files like PDFs or other text documents (as well as authenticated, private resources). By embedding the documents, Copilot uses vector search to find relevant paragraphs for grounding the Copilot, as well as providing helpful references for more in-depth details.
Here we have extended the knowledge base of by providing PDF documents containing domain knowledge and default high content moderation
Dataminer: strategic use of external data to enrich our solution’s business value By enhancing our knowledge base with specialized PDF documents on plumbing, we’ve not just enriched our repository—we’ve transformed it. This approach not only solves practical business problems by making specialized knowledge readily accessible but also adds significant value to our existing data.
Moreover, the trainee can iteratively ask for details for each step for more detailed explanations and specifics regarding plumbing tools or plumbing terminology, directly on the Member’s homepage.
Here we have embedded PlumbBot in our Power Pages Member section. Proividing expert plumbing help to our authenticated mebers
Hipster: Using the hip tech in a safe way
To make sure we could trust the advice given by our PlumbBot, we only allow it to use Generative AI when triggered with highly specific plumbing terminology or words related to plumbing issues. Moreover dynamic chaining is disabled to limit any misleading information from other, unverified connections:
Specific trigger phrases
Only triggered in plumbing scenarios
Handling a malicious prompt
But most importantly, by default, Copilot locks high content moderation to uploaded files as shown above. This makes sure the Copilot is grounded when prompted and will not answer to request out of its scope and knowledge domain.
Moreover, when attempting to force the PlumbBot to give misleading answers or create unrealistic scenarios (e.g. not having a main water valve to the building) for plumbing issues, it continues to only use the grounding, domain specific documents provided for the PlumbBot. While iteratively attempting to mislead it, it remains true to the knowledge base due to the scoping of the bot.
As this is super hip tech, the MS Doc is slightly misleading.
It says you can create add a Custom Copilot in the new Power Pages studio, while the link refers to the legacy studio, as the new studio doesn’t properly support it:
But that doesn’t stop us from using bleeding edge technology for providing customer and business value, with user privacy!
New aspiring plumbers can now apply do get rank 1 certification through our certificatior app. If completed a badge will be generated on SharePoint in the users own folder!
Go with the flow clairification: Heres the code that runs the flow (second red line) to create a user folder in sharepoint with the corresponding badge.
First updating data verse from the cansvas app – then triggering the flow in context of the authenticated user The actual Power Automate flow
Retro badge statement: I mean, look at the apperal used…. nothing more retro than that!
Thieving, shameless… Using unsigned gamepad hax code component to fire up the (retro) controllers, happenly stolen from John Lius Github: GitHub – johnnliu/gamepad (Thanks John) In addition we have stole more than a few dozens of original super mario assest from the dark corners of the internet ( dont tell anyone)!
Backstory: After a life of dangers, princesses and adventures Mario and Luigi returns to their family business: Super Mario Bros Pluming.
Unfortunately, the marked has changed. Simple brick and mortar businesses are no longer cutting it. What we need is something new, what we need is a service, a service with multiple revenue streams… A service with recurring revenue… What we need is Plumbing as a service (PlaaS)! Its here the Evidi Power Platform Plumbers comes to the rescue!
The plan:
The basic plan is us the Power Platform to offer a subscription service for home and castle owners in need of pluming services. For the low cost of 600 a moth you get access the wealth of services:
Community: “PlumberGuiden” This is a vibrant community with real human members where the customer can ask and receive answers to basic, and complex, pluming issues.
Plumber ExpertGPT Offers an instant, AI-driven advice on diagnosing and fixing common plumbing issues, providing step-by-step guidance with an authentic Italian twist.
Asset management Allows the customer to register properties with vital information like addresses, number of dungeons and lava pits.
Customer upskilling This is the pinnacle of the solution and allows the customer to level up their pluming skill. Not only will this give them the tools to solve their own plumbing problems. Successful completion will result in expert certification (PL-600) and allows the customer to transform into a Contractor.
Service Request For complex issues that the customer cannot handle them self (even after consulting PlumberGuiden and Plumber ExpertGPT) they can submit a service request.
The service request will then be routed to the best fit Contractor.
After completion we collect rating and reviews on the Contractor (helping us route service request event better in the future) and generate a invoice to the customer and doing a revenue split between SMBPluming and the Contractor.
For this we claim the badges: Early Delivery, Show And Tell
