Announcements
Click Create > Automated Cloud Flow
Name: Extract Email Data to Excel
Extract Email Data to Excel
Trigger: When a new email arrives (V3)
Folder: Inbox
Optional:
Add a filter like Subject contains or From address
Subject contains
From
Date: 2025-06-21 Name: John Doe Amount: $1200 Reference: INV12345
Name: Extract Date
Extract Date
Expression:
trim(split(split(body('Get_email')?['Body'], 'Date:')[1], '\n')[0])
Replace "Date:" with whatever label appears in your email.
"Date:"
Do similar for:
Name: → Extract Name
Name:
Amount: → Remove $ if needed
Amount:
$
Reference: → Extract string
Reference:
Add action: Add a row into a table
Location: Choose OneDrive / SharePoint
File: Browse to your Excel file
Table: Choose the table you created
Map values:
Date → Output from Compose "Extract Date"
Name → Output from Compose "Extract Name"
Amount → Output from Compose "Extract Amount"
Reference → Output from Compose "Extract Reference"
Save your flow.
Send a test email to your inbox in the expected format.
Wait a few seconds.
Check your Excel file — it should now have a new row with the extracted data!
If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍. Regards, Riyaz
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 604
Valantis 502
Vish WR 417
