Need help to automate a manual outlook task using Power Automate

(0) Share

Report

Posted on by Community Power Pla...

Hello All,

I'm a newbie at Power Automate and hence I need help to automate a manual task.

The task is:

1. To count the total number of emails for the previous day from a particular mailbox, get that count.

2. Out of those emails count how many of them are not replied yet, note that count as well.

3. Get the Subject Line of all the emails which were not replied, collect all these data and then create an excel file with all the data with excel structure as below

Mailbox

Name

Total Emails Received

Emails Replied

Emails Pending

Total

Emails Missed(Subject Line of emails)

Mailbox 'A'

125

121

125

1) Re: Hong Kong Disneyland Upgrade

2)JPUpload

3) Group Evaluation Inventory Error

4) FW: Rates

Any help would be appreciated, Thanks in advance!

Sherin Roy

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi,

There are no Power Automate (PA) action steps to find which email are replied or not. Unfortunately you won't be able to do this via PA steps. If you thinking this needs to be added that as a feature for the future release then please post this in idea forum.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

Thanks

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Anonymous you can't list the emails forwarted or not. Sorry

Was this reply helpful? Yes No
Sherin9767 4 on at

Like (0)

Report

Thanks for the update, but still what are the other ways to do it as of now if without power automate using manual code ?? Any such references would help.
Thanks

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi @Anonymous, it seems you do not need to use flow at all. Just create a script or an add-in for Outlook.

Was this reply helpful? Yes No
Sherin9767 4 on at

Like (0)

Report

Hello @victorlvanidze, thanks for the reply. Hey are there any good reference notes or resources details you can share or the python module which would help me to get this work done. Thanks.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

@Sherin9767 , just google for "Outlook add-in". As a starting point use www.slipstick.com

Was this reply helpful? Yes No