cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Macie_J
New Member

Archiving files based on the same column value based on date or other column value

Hi,

 

I know little about power automate , I have managed to pick some stuff up but this issue I am having, I am not sure how to even attempt it. Maybe someone has a minute to help me. 

I am trying to archive files (one a week interval) with  different names but with the same column value (A) based on a date processed (B) or date modified (D) . I want to move the older files to archive dir . 

 

In my simple terms , look through  all files in the folder and if any have  the same number in column (A) look at column (B or D) and move old ones to Archive folder . 

 

Any help on this would be apricated  it. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Macie_J,

Do you want to move files based on  the same column value and date?

Could you please share a bit more about the scenario?

 

You should use the Recurrence trigger.

 I have a test on my side, please take a try as below:

vqiaqimsft_3-1637220726098.png

 

vqiaqimsft_0-1637220640561.png

 

I assume that the Column you used to compare with the same value is a Status column in my scenario.

 

vqiaqimsft_1-1637220680810.png

vqiaqimsft_2-1637220694137.png

 

Best Regards,
Qi

View solution in original post

1 REPLY 1
v-qiaqi-msft
Community Support
Community Support

Hi @Macie_J,

Do you want to move files based on  the same column value and date?

Could you please share a bit more about the scenario?

 

You should use the Recurrence trigger.

 I have a test on my side, please take a try as below:

vqiaqimsft_3-1637220726098.png

 

vqiaqimsft_0-1637220640561.png

 

I assume that the Column you used to compare with the same value is a Status column in my scenario.

 

vqiaqimsft_1-1637220680810.png

vqiaqimsft_2-1637220694137.png

 

Best Regards,
Qi

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,157)