Shared Inbox Excel Tracking

[MSFlowsLA14]

I’m managing a shared inbox and would like to add a line in a spreadsheet for any new emails and to update the name of the folder any existing emails are in. (Thinking I can duplicate the flow and filter for each "folder" in the email trigger and then hard code that into the excel column)

With the “new email” trigger this would be easy to do so I could log a new email and then look it up periodically to update the folder and any other attributes. The problem with shared inboxes is I can’t use the regular “new email” trigger and have to trigger off of “new emails from shared inbox” which only runs every 15 min and collects top 10 emails in a folder OR “get emails v3” which each return an array of emails.

Any ideas on how I’d take that array, for each email assess if the email already exists in the spreadsheet: if yes, update the “read” status (and a couple other attributes) and if no, add it to the sheet as a new row in a table?

I've tried all kinds of loops and have had things work sometimes but either it adds the same email 100+ times or errors out. Appreciate any ideas!

[Nived_Nambiar]

Hi @MSFlowsLA14 

May be i am bit confused on the following points 

1. I’m managing a shared inbox and would like to add a line in a spreadsheet for any new emails and to update the name of the folder any existing emails are in - What you meant by highlighted sentence ?

2. I still did not get the idea why you are not trying to use when email arrives in shared mailbox trigger for your case - is its run interval the problem ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[MSFlowsLA14]

A couple additional details!

1. When moving from "Inbox" into a sub-folder I'm updating a field on a spreadsheet to the name of that sub-folder (triaging emails from the inbox into category folders for specific team members to monitor by subject.)  I've figured out how to record the folder on the email but I haven't figured out how to log a new email if the email has already been received, read and triaged into a sub-folder since the trigger "when new emails arrive to a shared inbox" only runs every 15 min instead of running every time a new email is received?  So I am missing logging emails that are moved before sitting in the "inbox" folder for 15 min.

2. The "when email arrives in shared mailbox" trigger does work but it only runs every 15 min but default and won't allow me to save anything else.  Ideally it would function like the "when new email arrives" trigger so it would trigger on each individual email but this trigger will only let you connect to your own user inbox, not a shared inbox.  I've also tried increasing the frequency to run every min (from the default of every 15 min) but the flow will not save the update?  So if an email is replied to and moved to a new folder within 15 min, this trigger will not pick it up because it only runs once every 15 min and scans just the "inbox" folder.  Looking for a way to scan the sub-folders to add anything to the excel table that was received and moved within that 15 min timer. 

I've tried to decrease the 15 min timer to 1 min but it won't save the changes?