You’re offline. This is a read only version of the page.
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
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.
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
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 😀
Hey @pete_bradshaw
Couple of options
If my reply helped, consider marking it as answered. Thanks for your time in sharing your issues and helping the community
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
