OneDrive to SharePoint migration based on modified date

(0) Share

Report

Posted on by oferz

Hi all,

I'm fairly new to flows and would love to get your help with a task I've got.

Two weeks ago we've moved all users files and folders to SharePoint while keeping most of the folder structure the same.

Now we want to make a cutoff and hopefully automate a way to move only the items they've worked on the past two weeks.

Some of the users worked on a few hundreds of items and/or created new ones so manual work will be hard.

Is there any way to automate this task using flows? So far I've found built-in flows that initiate only with a file have just been modified, but couldn't find a task that filters items based on modification date and then merge them into the site.

Does anyone have any suggestions? Or if you ever made this flow and able to share.

Thanks,
Ofer.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@oferz
You can make a Manual flow that calls the List Files Action and then a condition on the Last Modified on Date

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
oferz 8 on at

Like (0)

Report

Thanks for the reply!

I've gone through and made this flow, but I've got an error while running it:
"ActionFailed. An action failed. No dependent actions succeeded."

My idea is to move all items under a single folder in the OneDrive, and then moving the folder to SharePoint since I haven't found an action to copy files from OneDrive to SharePoint while automating or manually entering the destination for each identified item.

Thanks again,
Ofer.

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

Hi @oferz
The flow did not evaluate because of the date condition.
You are using greater than current Date so it will not cause any dependent actions to succeed; i was just adding it as in example while showing how to do it, you need to modify to suit your business
To save to sharepoint there is not direct action to copy from one drive to sharepoint but you need to create the file in sharepoint, So use the Get File content to retrieve the file content using Input Parameter Id from you List Files in a Folder Action and then Create File in SharePoint is illustrated in the below image
If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
oferz 8 on at

Like (0)

Report

@Mira_Ghaly

Thanks, I've managed to make it work!

Only one question, is there an automated flow that goes recursively through the sub-folders? so far I've managed to make it to get only the given folder list.

Thanks again,
Ofer.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@oferz
Currently there is no way you can vote for the idea here:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Copy-folder-with-subfolders-between-onedrive-for-business/idi-p/130077

Was this reply helpful? Yes No