In the past month I’ve had 3 requests to send emails on a daily/weekly basis. With On-Premise Dynamics, this was possible via an SSRS Subscription. Today, most of our clients are online and need an alternative solution.
There is a template for “Receive a weekly email summary of new Dynamics 365 Opportunities,” and this is just what I was looking for.
It shows you how to do the hard work of creating an HTML table (doesn’t look so hard any longer). Also injecting that table into an email body with simple HTML.
Next, I need to see if the html could be injected into the body of a Dynamics 365 CE email. Some of our clients aren’t running Office 365 with Exchange Online yet.
Another cool solution that we have been able to develop with Flow is the ability to run a Dynamics workflow that generates a mail merged Word template and stores it as an attachment in a note record. Next, Flow is triggered and extracts the attachment from the note and emails it out to people.
Embedding a Canvas App inside a Model Driven (D365 CE) Form
This is something I’ve been tinkering with lately. In CE form customization, you can select a field to customize and add a Canvas App control. It links that field to a Canvas App.
Click on Customize and then it will open a new Canvas App for you to build. The data source is automatically passed through an object called ModelDrivenFormIntegration.data.
Power Platform – Appropriately named indeed!
PowerApps has been around for a while now, since Oct 2016.
But Microsoft has been building the appropriate administrative pages to augment and complete the platform.
Let’s take a tour of the new Power Platform Admin Center.
Power Platform Admin Center
It can be found at https://admin.powerplatform.com.
One of the changes in April 2019 is the announcement of new capacity model. The new capacity model splits storage into Database, File, and Log storage. It also allows for additional Orgs (tenants) to be provisioned as you see fit.
You will not see this in effect until the company renews their agreement though.
PowerApps Admin Center
Templates are available for SQL Server. This could come in very handy! I’ll be testing this out in the future.
Have any questions about Solution Architect Notables? Please contact us at Sikich any time!