Power Platform Community Forum Thread Details

How to write retrieved email information into excel in particular column by power automate desktop?

Categories:

Some details missing in your question (do you have Outlook? You're talking about one email or a list of emails? Which email information?), but basic structure is something as this:

1) 'Launch Outlook'

2) 'Retrieve email messages from Outlook' and filter emails with parameters. This will give you a %RetrievedEmails% list variable with several properties (you can see them in the Flow Variables panel: click in the variable and them 'More' in each item of the list

3) 'Launch Excel'

4) 'Write to Excel worksheet':

In 'Value to write', you have to specify which email info you want to write. The syntax is %RetrievedEmail[item index as number].property%. For example, %RetrievedEmail[0].Subject will get the property Subject of the first email on list
Select the column and row (as numbers) you want to write to

If you're dealing with an email list, you'll have to include loop in this basic flow.