Daily count of emails in shared mailbox folder

[Gwill1983]

Hi all,

I am trying to achieve an automated count of emails in a shared mailbox folder at the end of each day, but ignoring what date the email was received as they could be from previous dates.

I had been trying to achieve this by adding a row to a list when they are added to the folder, but discovered that emails with a date prior to the last flow run were not counted as new so that is not an option.

Ideally I would like to be able to schedule a flow to run, count what is in the folder (named DONE) and then move all of those emails to another folder.

I am absolutely stumped!!

any help would be great

[VictorIvanidze]

Use a single GRAPH request to do what you want.

Request:

https://graph.microsoft.com/beta/me/mailfolders/inbox/

Result  (note totalItemCount):

{
    "@odata.context": "https://graph.microsoft.com/beta/$metadata#users('f078e88e-797c-46da-8f4a-c91c832774e2')/mailFolders/$entity",
    "id": "AAMkADVjNzc0NWZmLTRlNjctNDk3YS05OTVmLTk3MDE5NzMwZjRhYwAuAAAAAADyW2DLP5JUSJc_cjIQPjsTAQBrAj4i9HMnQpl_Colj4t7UAAAAAAEMAAA=",
    "displayName": "Inbox",
    "parentFolderId": "AAMkADVjNzc0NWZmLTRlNjctNDk3YS05OTVmLTk3MDE5NzMwZjRhYwAuAAAAAADyW2DLP5JUSJc_cjIQPjsTAQBrAj4i9HMnQpl_Colj4t7UAAAAAAEIAAA=",
    "childFolderCount": 4,
    "unreadItemCount": 0,
    "totalItemCount": 816,
    "wellKnownName": "inbox",
    "isHidden": false
}

[Gwill1983]

Thanks for the reply!

i have no idea what this means, but will research graph requests and use the code you have given.

much appreciated

[v-LilyW-msft · Accepted solution]

Hi @Gwill1983 

Has your problem been solved?

You also can take a try to use Get emails action and Move email action and set variables to move all email from one folder to another folder and count the total number of emails in the 'Done' folder.

I set up a flow, you can refer to the screenshots below.

Get emails action cannot directly select the shared mailbox folder,So first we need to get the folder path of 'Done' folder.

In Compose is the path of the 'Done' folder. How to get the folder path, you can refer to this article.

https://tomriha.com/how-to-get-emails-from-a-folder-in-a-shared-mailbox-with-power-automate/

Expression:

length(body('Get_emails_(V3)')?['value'])

After flow runs, the emails in 'Done' folder will be moved to 'Archieve-1' folder and the number of emails will be recorded in excel.

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gwill1983]

This looks amazing! Thanks

I will try to set this up later and let you know if it has solved all of my problems! 

[VictorIvanidze]

Hi @v-LilyW-msft,

how long will run your flow if you have 1000 items in the folder - did you test it?  

[Gwill1983]

Hi.

not tested yet. I plan to do it today. 
my flow will need to be duplicated as I have 2 sub folders that need to be counted along with an overall incoming email count withon the same flow.

I will update you on how long this takes later. My count is only likely to be approx 300 emails per day 

[Gwill1983]

So.... I have tested this and it doesn't appear to work. This section is completely greyed out when my flow is tested

(This is the moving emails section just before adding the row to the spreadsheet)

I don't think it is finding the email folder so doesnt attempt to move anything.

Any ideas?

[Gwill1983]

Hi. 

I was making a rookie mistake and only trying to move unread emails (which is why none were moving!!)

This works absolutely perfectly. Thanks so much for your help

[Mark74]

Hello, I can't find the solution to the issue I'm facing, and hope someone can help me with this.

Purpose flow: 
The purpose of the flow is to count the number of emails (read & unread) in a shared Outlook mailbox folder and sent an email with the day and number of emails of that day.

Built flow:

The result of my built flow is that all emails are forwarded instead of 1 email with the number of emails of that day.

See also the attached photos of my flow.

Issues:

1. One email instead of all the emails

2. Count the emails of that day

3. Add to Subject (or body) the date of counting and the number of counted emails.

I hope someone can help me with this. Thank you!
@Gwill1983 ; @VictorIvanidze 

1.2.3.

[Gwill1983]

Hi. 

My email count is currently working by adding all of the various counts to a spreadsheet and then constructing my daily email from the entries within the spreadsheet. It is counting emails from 2 sub folders and an overall daily incoming email count.

I have compared my flow to yours and it looks as though yours is missing the 'do until' step as below:

It is this final 'increment variable' named 'Count' that I reference in my email.

Hopefully this helps

[Gwill1983]

Hi. I know it has been a while since this thread. My flow was working absolutely perfectly, but then somebody deleted the sub folder that my flow referenced!

I am trying to fix this, but cannot find the ID for the sub folder. Are you able to help me with this?

There is nothing early in my flow that uses the sub folder so I cant peek code to get the reference!

[VictorIvanidze]

Hi @Gwill1983, the only way to find the ID of the subfolder I see is using a GRAPH request.

[Gwill1983]

Thanks for this. 

I found it in the end by creating a new TEST flow using the trigger of receiving an email into the folder that I required. I then peeked at the code after this had run and the ID was in there. 

[VictorIvanidze]

It means you've "hard-coded" the id. I told you how to get it dynamically when your flow is running.

[LarryAlx]

Hey @VictorIvanidze 

Does this go in a power automate step?

What is the connector?

The second row has a users id of some sort, where do I get that?

I'm trying to also get a count of how many email's we have replied to.  Can I use this GRAPH request for this?

Appreciate any help.

[VictorIvanidze]

Hi @LarryAlx,

sorry I don't catch your point. What's your question? 

[nirav_kalola]

Hi v-LilyW-msft,

I have implemented above flow for one of our shared mailbox. seems working fine.

Once we action any e-mails, we will move it to actioned folder so I selected actioned folder under compose and move them to another folder however where can I specify date range such only yesterday email or last months emails so I can report only to last month or yesterday emails.

Currently this flow dosent stop and moving all emails from action folder to another folder.

Any help would be appreciated.

[mespiritu]

Tried to do what you  posted as the solution in this thread but I can't seem to count if the received items is more than 10 as the get items (emails) top is only 10

[VictorIvanidze]

Try this: https://ivasoft.com/countemailsflow.shtml