Sometimes it's the simplest ones that give me the most trouble. I have a flow that each day moves our sent emails from a shared mailbox to the archive folder, counts them and returns the total number from the prior workday into a row in Excel. The sent part is working great.
To capture our daily received count, we have a SharePoint list that populates the Sender, Subject and Received date/time column.
I want to add on to the end of my Sent Count flow a simple action to get the items from the SharePoint list from the prior day (in my screenshot, I have it set to minus 4 because we get Friday's counts on Tuesdays), and then return that day's total number of items back into the Excel spreadsheet.
My sent count is always returning correctly, but no matter what I've tried for the received count, it returns a 0 value. (I have pagination turned on for Get Items)
I had also tried a simple Get Items with ODATA filter and then a compose length action, that didn't work. I think this is more the path I need, but I can't get it to give me the count of the prior day's total items. I just want to know that we received 183 emails Friday without having to go to the SharePoint list and retrieve the number manually.
