Not able to fetch received time, subject etc in different columns

Like (0) Share

Report

Posted on 24 Sep 2020 04:32:09 by vaibhavtandon87

182

Hello team,

I am using the below desktop flow to try to capture all the emails in my inbox but the information is coming in 'one' column only and that too only subject and some information from exchange.

Image 2.png

What i want is :

Subject, from, to , time received , categories etc all in different columns in excel.

Attached is the screenshot of the flow

All responses (1)

Answers (1)

Verified answer

John_Mavridis Microsoft Employee on 24 Sep 2020 at 08:06:36

Like (3)

Report

Re: Not able to fetch received time, subject etc in different columns

Hello,

After retrieving the Outlook email messages, you would first need to use a 'For each' loop action, so as to iterate through your emails one by one. This will generate a %CurrentItem% variable, whose type is 'Outlook mail message'.

Such email variable types come with a set of properties, which allow you to extract the subject, the body text and so on - you will be able to see the available properties after clicking on the variable picker icon and expanding the said variable, as per the below screenshot:
The above being said, within your loop you will need to use multiple 'Write to Excel worksheet' actions, which will of course point to different Excel columns, one for each category you are interested in. In each of these actions, you will need to use the respective email variable property.

As a side note, regarding the '.From' and '.To' properties, currently they cannot be used via the proposed dot notation, ie %CurrentItem.From%. Instead, the bracket notation should be used in these 2 cases, ie %CurrentItem['From']%.

Let us know if the above works for you.