News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum CRM - Roll Query Email...

Dynamics 365 general forum

Suggested answer

CRM - Roll Query Emails sent by User

(0) Share

Report

Report

Posted on by Community member

I am trying to run a query to see how many emails were sent by each user in the past 7 days. I have been unable to gather this data

Categories:

Other Functionality

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

CRM - Roll Query Emails sent by User

Hi Partner,

Maybe you can create one chart for emails:

https://learn.microsoft.com/en-us/power-apps/user/chart_on_form

Legend Entries：Subject Count(All)

Horizontal ( Category ) Axis Labels: From

Result:

To fit your needs: filtering views to create new ones:

--Emails sent by users in last 7 days.

--Select this view and this chart to count emails.

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah
Suggested answer

Mohamed GRAIB 2,498 Super User 2024 Season 2 on at

Like (0)

Report

CRM - Roll Query Emails sent by User

Hi,

From advanced Find, you can filter with E-mail entity, then in the From field you can define the user

You can also define your filter date,

I don't know if you can use a dynamics value for each user.

But I think that, you can export this query from Microsoft 365 Admin Center, or using a graph API query :

Microsoft 365 admin center email activity reports - Microsoft 365 admin | Microsoft Learn

Hope that's helpful,

Please mark answer as verified if that's helpful.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2

Martin Dráb 228,469 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans