Flow to count emails received each day

Like (0) Share

Report

Posted on 9 Jun 2020 12:00:08 by pete_bradshaw

Hello everyone,

I hope you can help with a query regarding Flow and Outlook.

I've never used Flow before and want to know if it's possible to record the number of received emails from a shared mailbox in a table using either lists or Excel in SharePoint.

The daily count just needs to increment by 1 for each email received, and record that against the corresponding date. The table will only have the Date and Count fields.

It's this possible?

Any advice or pointers will be much appreciated

I have the same question (0)

All responses (7)

Answers (0)

GIGI99 4 on 22 Feb 2022 at 18:36:33

Like (0)

Report

Re: Flow to count emails received each day

How to use the TOP field in V3 get emails ? If you want all emails - what should this be set to ?

Was this reply helpful? Yes No
GIGI99 4 on 22 Feb 2022 at 18:31:36

Like (0)

Report

Re: Flow to count emails received each day

Hi ,
What is the maximum no that can be set in the field "Top" ? - a mailbox could have 100s - 1000's of emails per day

Was this reply helpful? Yes No
WillPage 2,241 Super User 2025 Season 2 on 17 Dec 2020 at 00:35:38

Like (2)

Report

Re: Flow to count emails received each day

To get a count of items in an array, use the length() function.
Add a Compose action. With the cursor in the input box, switch to the expression editor (as opposed to dynamic content), type length() and place the cursor between the brackets.
Now click on the Dynamic Content tab.
The expression will remain in view (can be buggy, if it doesn't, try again) and you can then scroll down to find the dynamic content that represents the array of items from the Get emails action. It might be called 'value'.
When you click it, it places the dynamic content reference in the expression. Save and run that and see if you get a number in that compose.

Was this reply helpful? Yes No
mlm198 2 on 16 Dec 2020 at 22:54:06

Like (0)

Report

Re: Flow to count emails received each day

I am trying to implement this but not sure what the output term is to feed into my excel table of date and count?

Are you able to help.

Thanks in advance.

Matthew

Was this reply helpful? Yes No
LinkeD365 105 on 11 Jun 2020 at 07:13:58

Like (0)

Report

Re: ThisRe: Flow to count emails received each day

Hey @pete_bradshaw

1. This won't impact Flow performance, it might have unwanted outcomes. Say you add 1 to the count each time, you have to read a count first, then write it. Between the read and the write, another email may have triggered an update, so the count may be off. Unlikely, but possible.

2. Definitely, the Excel connector supports this.

https://www.youtube.com/watch?v=ibqFGgkZ1Cs

Cheers

If my reply helped, consider marking it as answered. Thanks for your time in sharing your issues and helping the community

Was this reply helpful? Yes No
pete_bradshaw 2 on 10 Jun 2020 at 15:58:10

Like (0)

Report

ThisRe: Flow to count emails received each day

Hi, many thanks for getting back to me with this. I'll have a look tomorrow now to see if I can get it to work.

A couple of questions;
1. Regarding the first suggestion, we expect about 500 emails a day with the bulk during core work hours, would that volume have an impact on performance of Flow? I'm leaning to the second option as it seems lighter and will only be run once a day out of hours, but I'm curious about potential difficulties large volumes may cause.

2. The second option could probably be run once at some point after midnight to perform the Flow. Can this be added to the bottom of a list or add a new row to a spreadsheet?

I'm happy to do some reading and practice here if there is an online source that can be recommended?

Many thanks 😀

Was this reply helpful? Yes No
LinkeD365 105 on 09 Jun 2020 at 14:50:44

Like (0)

Report
Re: Flow to count emails received each day

Hey @pete_bradshaw

Couple of options

Create a flow which is triggered everytime you receive an email & read / increment count
Not ideal, depending on how many emails as it is a flow run each time
Have a scheduled flow run every day which finds all emails in inbox received that day

If my reply helped, consider marking it as answered. Thanks for your time in sharing your issues and helping the community

Was this reply helpful? Yes No