Forum Discussion
Sharepoint Backups using Flow (Best Practice, Advice Needed)
Hi @shaneOZ,
I recommend that you back up the data over 100 days to the new list and clean up the data over 100 days in the original table. I will give you a screenshot of the configuration. You can refer to this flow to create your workaround:
Step1: Create a recurrence set as every day. Then Get the items of the original table.
Step2: Create a condition to filter the items 100 days ago in the original table
formatDateTime(item()?['Modified'],'yyyy-MM-dd') is less than addDays(utcNow(),-100,'yyyy-MM-dd')
Then create these over 100 days items in a new list, and delete these items in the original table.
You can have a try with it. If there is any problem, please contact us.
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.
AdministratorHi @shaneOZ,
I recommend that you back up the data over 100 days to the new list and clean up the data over 100 days in the original table. I will give you a screenshot of the configuration. You can refer to this flow to create your workaround:
Step1: Create a recurrence set as every day. Then Get the items of the original table.
Step2: Create a condition to filter the items 100 days ago in the original table
formatDateTime(item()?['Modified'],'yyyy-MM-dd') is less than addDays(utcNow(),-100,'yyyy-MM-dd')
Then create these over 100 days items in a new list, and delete these items in the original table.
You can have a try with it. If there is any problem, please contact us.
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.
@v-lin-msft wrote:Hi @shaneOZ,
I recommend that you back up the data over 100 days to the new list and clean up the data over 100 days in the original table. I will give you a screenshot of the configuration. You can refer to this flow to create your workaround:
Step1: Create a recurrence set as every day. Then Get the items of the original table.
Step2: Create a condition to filter the items 100 days ago in the original table
formatDateTime(item()?['Modified'],'yyyy-MM-dd') is less than addDays(utcNow(),-100,'yyyy-MM-dd')Then create these over 100 days items in a new list, and delete these items in the original table.
You can have a try with it. If there is any problem, please contact us.
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.
Hi Thankyou for the response ive had time to test this,
and it works brillantly ive done large list moving around before and im curious to know of any limitations?
WIll this work with a large list of say 100,000 only sending a 1000 a day for example?
- Syndicate_Admin
Hi @shaneOZ,
Yes, you can set it at the action Get items by appending the number of Top Count.
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.
@v-lin-msft wrote:Hi @shaneOZ,
Yes, you can set it at the action Get items by appending the number of Top Count.
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.
Thankyou curiously with the
addDays(utcNow(),-100,'yyyy-MM-dd')
am i able to modify that to say select the months from
1st of January to the 30th of june or similar to select 6months worth of data? im just thinking of trialing it on a large list i have?
- Syndicate_Admin
Hi @shaneOZ,
Currently, the largest unit of adjustment as a function of time is days in flow,
If you want to screen items from January 1 to June 30, you can add a condition to determine if the modification date is larger than January 1 and smaller than June 30.
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.