web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create excel file with...
Power Automate
Unanswered

Create excel file with content from several incoming mails...

(0) ShareShare
ReportReport
Posted on by
Hi, i am new to power automate and don´t get it if its possible.
 
I get some mails with information in the body from servers wich made a backup. 
 
Like :
 
Backup on Server xxx was succesfull
 
And now like to create an excel file on one drive wich fills up with the information like :
 
from wich is the mail, wich date, status ok or not
 
i tried yesterday hours but can´t find my failure.
 
my flow is :
 
on incorming mail outlook 365 (V3)
then a condition check with false or true for the sender adress and body content.
 
if true : i have a promt created 
 
my prompt : Analyze the email and reproduce the information as one line according to the following format: Date, sender, and backup status (OK or error).
 
i put text information for Date, Sender and Backup status in the prompt.
 
if i test the prompt i get the right data i need like : 17.04.26, Johnson, OK
 
And now i like to do this with many others mails but put the info in one excel flle together and check all 3 days or so the excel file.
 
Is this possible ???
 
Thank you !
 
 
 
Bildschirmfoto 2026-04-17 um 12.53.04.png
Categories:
I have the same question (0)
  • Vish WR Profile Picture
    777 on at
     
    Instead of building one file at the end, do this:
    • Create an Excel file in OneDrive with a table (columns: Date, Sender, Status).
    • In your flow:
      • Trigger: When a new email arrives (V3).
      • Your condition and AI prompt (what you already have).
      • Then add action: “Add a row into a table” (Excel Online). Map:
      • Date → from AI output.
      • Sender → from email.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 469

#3
11manish Profile Picture

11manish 364

Last 30 days Overall leaderboard