Share
ReportHey Team!
On https://learn.microsoft.com/en-us/power-platform/admin/policies-communications it's stated that Microsoft deploys weekly updates and that there are two major events, as well as there might be service incidents or planned maintenances. All this information is posted on Microsoft 365 Admin Center under Health, and from there, we can choose the Service Health (for issues affecting specific technologies) or Message Center (for updates/notifications). However, this information is only available to people with access to such Admin center (although tthere's an option to send a weekly bulletin to people on a specific list (max 2 mailboxes on the list)
But it might happen that on large companies, Dynamics 365 Administrators or environment Administrators don't have access to this and therefore, they're not aware of these updates or status.
so, How do we send an email to our Dataverse environment Administrators with the planned updates or system issues? Well. We can take advantage of a couple tools: Microsoft Graph API and PowerAutomate.
Microsoft Graph API
On https://learn.microsoft.com/en-us/graph/api/resources/service-communications-api-overview?view=graph-rest-1.0&preserve-view=true we have some interesting information about using GRAPH API to retrieve messages (planned updates sent in advance of security/scheduled update) and Issues (Problems affecting availability of services). We would need to build our query using GraphAPI to retrieve for example, Dynamics Messages and Dynamics Issues. Please note that we'll be using the following information
https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http >> How to use QueryParameters
https://learn.microsoft.com/en-us/graph/api/serviceannouncement-list-messages?view=graph-rest-1.0&preserve-view=true&tabs=http >> To retrieve messages
https://learn.microsoft.com/en-us/graph/api/serviceannouncement-list-issues?view=graph-rest-1.0&preserve-view=true&tabs=http >> to retrieve incidents
This shows the sample GraphQuery to get the last 20 messages order by StartDate descending where the title of the message starts with "Dynamics":
graph.microsoft.com/.../messages desc&$top=20
As a result (showing only the first record)
And this would be the graphQuery for a similar response for Incidents:
graph.microsoft.com/.../issues desc
PowerAutomate
With the previous outcome (a pair of JSON files) we can take advantage of PowerAutomate, ot repeat the query by using an HTTP Request, then process the outcome to generate a table that we can use for example, to attach to an email:
This would be an example of the table:
With this information, we can then send an email to a set of users (that we read from a file, or from a SharePoint list).
Hope this helps!
All responses (
Answers (
292,575
