Email summary of emails in a shared mailbox that are over an hour old

[detox1978]

Hi All,

I'm very new to Power Automate.

I am trying to setup a schedule that emails a summary of all emails in a shared mailbox that are over an hour old.

Many thanks

D

[v-litu-msft]

Hi @detox1978,

It's unfortunate that Get emails form a Shared mailbox not supported currently in Flow, if you want this feature could be added in Flow, you could head to IDEA forum to vote this idea, raise votes to make it come true in the future:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Get-Emails-from-Shared-Mailbox/idi-p/135176

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[detox1978]

Oh, i need the feature, so will have to use a standard mailbox.

Any idea how to do it on a standard mailbox?

many thanks

[v-litu-msft]

Hi @detox1978,

You could create a recurrence trigger to run the Flow every hour, then Get emails received in the inbox, set the Fetch Only Unread Messages to No, Top to 100(if you have many emails received in one hour, you could set it higher).

Then use Filter array action to filter out received time greater than the time in the past 1 hour.

This expression gets the past 1 hour timestamp:

addHours(utcNow(), -1)

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[detox1978]

Looks good.

How could i send it as a summary in an email to someone?

[v-litu-msft · Accepted solution]

Hi @detox1978,

You could export these messages to .eml files, and send them as attachments in a email:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[detox1978]

The body, subject and message_id are not displayed as variables.  Any ideas?

[v-litu-msft]

Hi @detox1978,

You could use expression instead, for example:

item()?['Subject']

item()?['message_id']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[detox1978]

I'm not sure where I am going.  It runs ok (all green ticks), but doesnt send any emails.

Looking at the log the the Filter array has the email INPUT data, but the OUTPUT is empty.

Here is my Flow

Many thanks

[detox1978]

I've had a play around and managed to get it working.  I'll repost the final flow tomorrow, just in case anyone else would like it.

many thanks for your help.

D