Answered

Extract data from ALL emails in Folder and put it in Excel File

(0) Share

Report

Posted on by ferjus

Hi all,
I'm working doing Technical Support and we receive around 20 emails per day with questions of different kinds.

Once we reply to an email, it get gets automatically moved to the "Processed" folder.
I would like to know if it's possible to create a flow that allows me to extract data from all the emails in the "Processed" folder and include it in an Excel Sheet.
The way I need this Excel to look like is the following:

- Rows:

+ One row per email in the folder

- Columns:
+ Sender's email

+ Date (hour, day, month, year)

+ Subject

+ Body

+ Category (we assign manually a category to each email that we receive)

Is it possible to do such a thing? What's the most appropiate flow?
Thank you!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (2)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ferjus

Start with this and see how you go. The trigger lets you pick a folder. In your case it would be processed folder.

There is no easy way to pick a category. But you can use conditional logic in Power Automate to achieve something like that.

Was this reply helpful? Yes No
Verified answer

ferjus 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer sudeep.
In this case I don't want the trigger to be "When a new email arrives" but rather just check all the emails in the folder, only once.
What would be the best way in your opinion to achieve this?

Thanks!

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sure

In that case just use a manual trigger and use the Get emails action. You can specify a folder name.

Was this reply helpful? Yes No
ferjus 13 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ
Thank you for your inputs.
I implemented the flow and it works, Unfortunately, the "for each" loop runs only up to 10 times and I have literally hundreds of emails... Is there a way of running a flow for as many emails htere are in a folder?

Was this reply helpful? Yes No