Unanswered

category display

(1) Share

Report

Posted on by ÁN-30071448-0

Hello There,

I would like to do the following system solution. If somebody send an email to out shared mailbox, then the system puts automatically the data about the email into an shared Excel. The data I would need: subject, the time when we get the the email and the most important category. Do you have any idea how should I make it?

The loop is like that:

1. Customer send an email to our shared mailbox.

2. I read it.

3. I give an category for the given email.

Can you help me please?

Thanks a lot,

Ákos

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

rzaneti 4,476 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Some months ago I wrote a step-by-step to a very similar process, where the data was extracted from email body and loaded into an Excel table. You can find it here: http://digitalmill.net/2023/11/02/data-extraction-from-email-to-excel-with-power-automate/

You can follow basically the same process, but for your use specific case you will need to change the trigger to When a new email arrives in a shared mailbox (highlighted in red) and select the dynamic content from Subject (highlighted in yellow), Importance and Received time:

If the steps detailed in the article are not clear enough or if you have any other questions related to this flow, let me know and I will be glad to support you :)

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
ÁN-30071448-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

First of all, thank you very much for your help.

My main problem is I cannot build up the process for getting back the categories of the given mail. I try to explain the whole process. My Team and I are getting a lots of mails (especially RFQ) to our shared mailbox. I am the team leader and because of that I read every single mail and I put the categories on like this:

The categories mean the responsible person for the given task (I marked with the red circle). I would like to make an automate report about that into an Excel. For that I would need the categories about the mails. I solved every other thins, but the category is a different thing. Do you have any idea?

Thanks a lot, best regards:

Ákos

Was this reply helpful? Yes No