News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... CRM - Roll Query Email...

Microsoft Dynamics 365 | Integration, Dataverse...

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

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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans