We have created a scheduled flow that crawls through www.elskling.no results in my neighborhood electricity prices to get which provides that I could choose in my area.
We created a custom connector, which gets data from www.elskling.no, so we could get this data using a Cloud Flow.
Using this custom connector we were able to get all the providers of the zipCode we sent with the request.
3. After getting these data, we are able to add the Current Rate of each supplier to our Account record in Dataverse. By running this flow hourly, we are able to always get the latest price from each supplier.
Sharing what we are going to create and the event on social media. We have also been around helping other teams and sharing our knowledge. As well as talking ideas with other community champions (aka the one and only CRMkeeper)!
We been out and playing “santa” for Skill Bombshells, they borrowed IoT devices to achieve even more awesomeness with their product!!
Ninja turtles recently came up with an issue, after Rafael emptied the water heater after a long shower. They received an electricity bill that was way above what they used to. The electricity prices have recently increased a lot in New York City and ninja turtles need a solution before they are not able to pay their bills.
PowerShells has come up with an idea to make sure ninja turtles have the best electricity agreement, we are going to get hourly electricity prices and deals from all providers out there, and pick the best one. And this is how we are going to make it:
Portals
The customer will have access to a Power Apps Portal where they get an overview of their electricity agreement history and what agreement they are currently on at the moment.
They can see details about their current price; what are the electricity providers and suppliers paying for the electricity, what are they selling for and what are their earnings.
Customer Service
Customers can use the portal to send support requests and get access to knowledge articles. They submit support tickets as cases and can follow up their cases and communicate with customer service.
Progressive web app
The portal is enabled as a Progressive Web Apps and will be distributed as a native mobile app in Microsoft Windows Store and Google Pkat Android Store.
Customer service data registration
Our customer service employees will use a form or two (or more) to register various information about our customers and other information. We’ll create an SPFx app (React) for this/these forms. The data from this/these form(s) will by some magic “flow” (pun intended) to Dataverse where it can be utilized by the various other parts of our system.
Power BI
Based on all the data generated from the API providing the current electricity spot price and the frequency switch of electricity providers and agreements we need some proper dashboards to display the data. We will make dashboards for the customer and the back office to track customer engagements.
Data and rates calculations
All available electricity providers and rates available for the customers (ninjas) will automatically be polled from APIs into Dataverse with power automate cloud flows. Advanced algorithms will calculate the best agreements available at an hourly rate, and automatically change the customer’s (ninja) agreement.
Overview
A canvas app will poll information from the Dataverse and embed Power BI visuals for a full overview of the customer base, prices, and providers.
