How to move old emails from a shared mailbox Inbox to Archive folder

[UI-namanjoshi]

Hi All,

I am trying to build a flow to move all my old emails (95,000+) from Inbox to Archive folder, I have tried moving them via Outlook application but that did not work.

So I have created an "PA FLow" to move emails <01-01-2021 to the Archive folder, but the flow is only being executed on New emails coming into my Shared Inbox, not on emails that are already present in my shared-Inbox.

Can someone help me on this, is this possible to achieve from PA flows or is there any other way I need to look to achieve this goal?

Thank you!

[Gericom]

Hi @UI-namanjoshi 

i have found a solution for your question 

notes you can only get the top 25 so you need to calculate the number of loops you need 

you need to add a filter query 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

[UI-namanjoshi]

Hi @Gericom , thanks for the snippets, I tried the steps from your snippets, but 1st step not able to create, it says you can not initialize a variable, is something being cropped from your snippet? Also is your solution for the Sharedbox email folder?

[Gericom]

hi @UI-namanjoshi 

my bad 

yes you can use it on a shared mailbox but you need to add it to my connections  see the picture

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

[UI-namanjoshi]

Hi @Gericom , thank you for your reply, am bit new in this Power Automate era 🙂

Let me re-brief the goal which I am trying to achieve here is to move all the email which are less than 01-01-2021 from my "sharedbox Inbox" folder, surprisingly when I used the "Get emails(V3)" which you have used in your snippet, I am not able to select the Inbox from sharedbox account, it's showing my Inbox.

Below is the snippet of my flow experiment which I have written to move old emails into a different folder.

[UI-namanjoshi]

Hi @Gericom I got your point and able to move 10 emails from (Sharedbox) the Current Inbox to Old-Inbox folder using the below flow, now the only point is, it's moving the new emails, my goal is to move emails that are older than 01-01-2021, am I missing something in adding the timestamp condition somewhere?

[Gericom]

Hi @UI-namanjoshi 

To do that you need to add a filter querty in de get emails action these are the same syntax as you would use in oultook 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

[UI-namanjoshi]

Hi @Gericom , I tried the same syntax which works in outlook filter query but here it's not working, could you pls try once from your end, below are the test snippets from my end.

[Gericom]

Hi @UI-namanjoshi 

use 

received<2021-01-01 

this would work 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

[UI-namanjoshi]

thanks @Gericom  for the timestamp condition, but I have tried by providing the same input condition as "received<2021-01-01" , no output from the result.

Also I see one warning too in that success run output... 

[VictorIvanidze]

Hi @UI-namanjoshi,

why didn't you run AutoArchive in Outlook? Why re-inventing a bike?

[UI-namanjoshi]

Hi @VictorIvanidze , Thank you for your response, As I mentioned in my base question, we have more than 9,90,000 emails in "Inbox" folder, we have tried applying Rules via Outlook Application & Web, but nothing worked. that's the reason I am trying to find other possibilities to solve this basic problem to move my old emails into different folder which unfortunately Microsoft can not fix at the moment. 

[VictorIvanidze]

Hi @UI-namanjoshi, I understood you " have tried applying Rules via Outlook Application & Web", but did try to use Outlook native method (see my screenshot above)?

[UI-namanjoshi]

Hi @VictorIvanidze , for some reason in my Windows Outlook application I don't see this option. But from Web I can see on Inbox we can assign policy, I have added as "1 year move to Archive" but till now no old emails moved to "Archive" folder...

From Outlook Application:

From web:

[NotAGovEmployee]

This does not work. The loop only loops through the top 25 emails. Then if you put that in another loop (do until), it will still only search the top 25 emails (the same top 25). It loops through the same emails until the first loop ends. My example is set to loop 16 times, see below pictures which show the same output for each iteration of the loop: 

My use case is I need to archive/move multiple emails over the course of years based off a keyword in the subject line or body of the email. 

[VictorIvanidze]

Please show the whole flow.

[NotAGovEmployee]

Hello. I played with it a little more and changed it up best I could. Its accuracy is about 80% still... I can clearly see the flow did not move an email that satisfies the criteria of the flow. Thoughts?

I did use your workaround by using rules in Outlook, but my fear is I won't have as much control over those I'm supporting as I would with Power Automate.