Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Scheduling a mail and send to Team members from Dynamics CRM with Case Details

(0) ShareShare
ReportReport
Posted on by 285

Hi Everyone,

Please note, We need send a mail to team members/group mail Id for receiving the Ticket case(Service Request) details from Dynamics CRM portal in daily basis with schedule time.

In this, We have to filter the every agent ticket details and ticket status like a)open b)Work-in-progress c) Closed 4)waiting for confirmation etc. Herewith I have attached table details for reference.

Total No. of Tickets September Month

      43

No. of Tickets assigned to xxx1

       1

No. of Tickets assigned to xxx2

      16

No. of Tickets assigned to xxx3

12

No. of Tickets assigned to xxx4

3

No.of  Ticket  assigned  to xxx5

     10

Unassigned Tickets

1

Information Tickets

0

No. of Open Tickets

2

No. of Closed Tickets

      34

No. of Work in Progress

7

No. of waiting for client response

0

No. of Waiting for confirmation closure

0

No.of  Hold Tickets

0

 

Regards,

Vinoth Kumar A K

  • Suggested answer
    tejesh.sharma@hotmail.com Profile Picture
    30 on at
    RE: Scheduling a mail and send to Team members from Dynamics CRM with Case Details

    Hi, you can achieve this using Power automate(MS Schedule flow) or azure Logic Apps. You can refer my blog for the same its not exact but might help you out d365blogs.tejeshsharma.com/.../trigger-email-when-account-is-created.html. Please like if this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 51 Most Valuable Professional

#2
Ramesh Kumar Profile Picture

Ramesh Kumar 42

#3
David Shaw_UK Profile Picture

David Shaw_UK 27

Featured topics

Product updates

Dynamics 365 release plans