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 !