Saving Attachments From Previous Emails in INBOX

[bbanic23]

Hello, 

I use the Power Flow that automatically saves email attachments to OneDrive. Is there a way to get the flow to manually run through my entire inbox. I essentially need to do this only once. 

Thank you.

[annajhaveri]

@bbanic23  you can use Get Emails action to get emails from the inbox and then add apply to each action to loop through emails and add get attachment action inside the apply to each action to get attachment and save it to onedrive 

[bbanic23]

I am having a hard time following this. I don't see the "Get Emails" action. Can you provide a couple screen shots?

[annajhaveri]

@bbanic23 just search for Get Emails as shown in below screenshot

[annajhaveri · Accepted solution]

@bbanic23  configure your flow as follows:

Configure the Get Emails action as follows, you can apply more settings, like select specific folder, change Top count - count of emails to be returned by this action, apply filters like from, to, etc. I would suggest to apply more filters to narrow down the number of emails to be returned by this action

Then loop through value (items from Get Emails) using Apply to each action, then again loop through attachments of email inside the Apply to each using Apply to each again, see below screenshot for reference, then get the attachment and save it to onedrive.

[bbanic23]

I really appreciate this. Thank you so much. This will help out immensely!

[MelGen]

any way to include a specific date or date range for these email attachments? I only want to put email attachments from 06/25/2022.  thanks

[annajhaveri]

@MelGen  are you looking for emails within specific date range? You can try using search query on Get Emails action to get emails of certain dates.

[MelGen]

Could provide an example of a search query on Get Emails?  

[annajhaveri]

@MelGen below is example

received<2015-06-30 and received>2015-06-01

[MelGen]

I'll give it a try.. thanks 

[shikhasodhi]

Hello,

          I wanted to extract  Emails of  14 July,2023 from 11 AM to 4PM. I tried And(greater(formatDateTime(addDays('2023-07-14T17:00:00Z', -1),'yyyy-MM-ddTHH:mm:ssZ'),'17:00:00'),less(formatDateTime(addDays('2023-07-14T17:00:00Z', -1),'yyyy-MM-ddTHH:mm:ssZ'),'21:00:00')) But it is not working. I put this query in Get Email(v3) in Search Query. If anyone can help me that would be appreciated.

Thanks

[shikhasodhi]

Hello,

          I wanted to extract  Email attachments of  14 July,2023 from 11 AM to 4PM. I tried And(greater(formatDateTime(addDays('2023-07-14T17:00:00Z', -1),'yyyy-MM-ddTHH:mm:ssZ'),'17:00:00'),less(formatDateTime(addDays('2023-07-14T17:00:00Z', -1),'yyyy-MM-ddTHH:mm:ssZ'),'21:00:00')) But it is not working. I put this query in Get Email(v3) in Search Query. If anyone can help me that would be appreciated.

Thanks

[annajhaveri]

@shikhasodhi  try below search query expressions

received>@{addDays(utcNow(),-3,'yyyy-MM-ddThh:mm:ss')} AND received<@{addDays(utcNow(),-2,'yyyy-MM-ddThh:mm:ss')}

received>2023-07-14T11:00:00 AND received<2023-07-14T14:00:00

[shikhasodhi]

@annajhaveri Thanks ! I will give it a try. I have one more question about email attachment limit(25). Can we increase the limit to extract the attachments from outlook?

[JDR100]

The top count returns a maximum of 25, how can i loop through to do more emails? I am looking for circa 500 

[bbanic27]

You can bypass power automate all together and just use the “rules” feature in edge mail. Once it’s set up it works with the desktop application as well. I prefer setting up in the browser version because, to me, it is easier to use.