TIDBITS on the Microsoft Power Platform

Leveraging the Microsoft Stack

Although a direct API would be preferred, you also have the following power 

Microsoft Outlook

• An e-mail is received
• The e-mail has an attachment of an Excel Spreadsheet
• The spreadsheet is received every week and contains key data that validates information
• An Outlook rule moves this e-mail to a folder 

Welcome Microsoft Power Automate (flow)

• Pick-up the e-mail
• Save the Attachment
• Process the Attachment data and injected the data into Dataverse (Model Driven Power App)

Microsoft Power App

• Dashboards
• Comparisons
• Calculations
• Reporting errors 

There are many choices when it comes to business processes and eliminating manual steps. 

Microsoft Technologies leveraged on projects

One of the reasons I persist with the Microsoft Technology stack is that having a huge box of legos to build business applications with is just hard to beat. 

Microsoft tends to change names, debate branding and overall try to communicate what a consultant can bring to the table, but in most of my projects now we tap into numerous different offerings.

Take for instance my last project. In my last project we delivered an integrated model that included 

• Microsoft Dynamics 365 Customer Engagement (Model Driven Power App + Microsoft Canvas App)
• Microsoft Dynamics 365 Finance and Operations (Supply Chain Management focused)
• Power Automate (Flow) (Approvals and Standard)
• Power Portal (now called Power Pages)
• Microsoft Dual Write (connecting DYN365FO + DYN365CE)
• Microsoft Azure Synapse
• Microsoft Azure Function Apps
• Microsoft Azure Logic Apps
• Microsoft Azure Service Bus 
• Microsoft Teams
• Microsoft Azure Blob Storage
• and Microsoft Office 365 

We also coordinated the team and the application lifecycle management using Microsoft Azure DevOps, Microsoft Azure CLI, Microsoft Visual Studio, Microsoft RSAT (Regression Suite Automation Tool) and Microsoft Teams. 

Now you would think that you would need a HUGE team to deliver the above, but we actually delivered using a very reasonably sized team with a mix of resources. 

One of the beauties of the Microsoft stack of applications and offerings is that there is so much that you can do! The ability to use a platform that grows organically (SaaS) and through phased projects aligned to key business needs, keeps companies current with the latest and greatest technology offerings. 

The world moves so fast. It is great to have structures in place that allow teams to move at the same speed. 

 

Incredible Flexibility

I am working with some incredible technologies, and I am working with the Power Platform and so many cool things that can be done with this incredible engine of growth. 

Consider this: You have an incredible repository of many different data sources. You have an entire team of people who work on "DATA" (and AI and all the cool new in the data space), but you also use one or many of the Power Platform, Model Driven, Dynamics PowerApps (Sales, Field Service, Customer Service, Connected Field Service, Marketing, Talent, Custom and so many more)

Did you know that you can work with a Power BI team to create incredible reports off of your data "repositories" (pulling data from many different places) AND you can then embed these Power BI reports in a Power Platform, Power Portal. Why use a Power Portal over a custom web page or some other option? well there is that little gem of application and/or data access security. Yes, the templates are also incredibly nice, but where Microsoft shines is in the layers of awesome. 

One of the reasons that I continue to focus and grow within the Power Platform is the huge flexibility and pivoting of new technologies to meet the demanding business needs. These needs are met leveraging the same platform and the platform continues to grow and be supported. 

 

Certifications and Testing

Become Microsoft Certified

As we role into the sometimes slower holiday days I thought a share of the Microsoft Certification Poster might be helpful for those interested in the following: 

Knowledge Sharing Power Platform Vocabularly

One of my favorite ways to learn is to share knowledge. I find that all of the other perspectives I get from this exercise really help me shift and refine what I have learned. 

In the last two years I have been under the fire house learning. It is both exciting, amazing and daunting when we consider how much more there is always to learn. It is also a twist for those of us who have years of experience. The experience makes a huge difference, but it also always has to be continually refined.

One of the first major learning tips is to get your head around the vocabulary quickly. It has served me well to think about the following.

The Power Platform, this is really an evolution to getting closer and closer to using the entire Microsoft Stack of awesome. The long loved deep integration to Office is now 100 times better AND there is also the deep integration to Azure and many of the new Azure functions. 

Microsoft Dynamics 365 "Apps" are all Model Driven Power Apps on the Power Platform. 

Power Automate (Flow) The ability to automate, respond and receive responses and an alignment/replacement or stepping stone to both work flows and logic apps and you can learn more here.

Power BI Much loved and amazing reporting and business intelligence and analytics and you can learn more here

 

Power Virtual Bots, Not only bots, but Robotic Process Automation (RPA) and you can learn more here and here.

Power Platform Resources and Documentation

The Microsoft DOCS team has been incredibly busy over the last numerous months. You will find that many (if not all) documentation found at Docs.Microsoft.com has been updated and has a 2020 associated date. If you are not sure where to get started take a look at this incredibly helpful LINKS list. 

https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/