Azure Logic App to Report on Neglected Dynamics 365 (CRM) Cases

Scenario: You want to send an email to the owner of an unresolved CRM case record if the modifiedon date/time is greater than 24 hours.

Solution: Azure Logic App and Azure Function

Note: The Logic App references an Azure Function named GetHoursSinceUtcDateTime. You can find the function code and instructions here: https://gist.github.com/tdutch1/a14c60eed1a005c074f317b581cd6f01

Logic App

• For the "Send an email" action, you can include fields from the CRM case. Consider providing a link to the case record in CRM.
• In the "List records" action, set the query condition to "statuscode eq 0" to include only active cases.