Power Platform Community Forum Thread Details

Hi all - I’m trying to create a simple Power Automate flow that logs emails from a specific Outlook folder into a table for analytics. I’ve hit a wall and would love a quick sanity check from someone who’s built this pattern before. Any power users willing to help?

Categories:

Power Automate Desktop

Hi @ST-01042049-0,

Yes, this is a very common and supported pattern.
Use “When a new email arrives (V3)”, set the Folder to your target Outlook folder, then log metadata using Add a row into a table (Excel/SharePoint).
Avoid filtering with Conditions, do it in the trigger for better performance. For historical emails, use Get emails (V3) in a one‑time or scheduled flow.

How to Build It

1) Prepare your table

Excel file stored in OneDrive or SharePoint
Data must be inside an Excel Table (not a plain range)

2) Create the flow

Trigger: When a new email arrives (V3)
Set Folder to your specific Outlook folder
(Optional) Add subject/sender filters in the trigger

3) Log the email

Action: Add a row into a table
Map fields like:

   Received time
   From
   Subject
   Conversation ID

4) For historical emails

Create a manual or scheduled flow
Use Get emails (V3) pointed to the same folder
Loop and insert rows

This pattern scales cleanly for analytics and reporting.

Solved: Trigger 'when a new email arrives in a subfolder': chronical order of mail arrival important?

Power Automate Basics: When a New Email Arrives (V3) Trigger Explained

Trigger a cloud flow based on email properties in Power Automate - Power Automate | Microsoft Learn

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.