Skip to main content

Ms Flow: Copy a set of files in SharePoint using their ID's

    If you have a small set of files in a SharePoint Library, which has too many folders, using MS Flow to copy all files from one specific folder is easy. But if you want to pick a small set of files from multiple folders and copy them all using one Flow, it might be tricky.

If you open any document from SharePoint in a web-browser, you'll notice a text like "Listitemid = ####" where #### is a number. That is a unique ID of that file in that SharePoint. You can use this to get the details of that file.

Example:
https://testsite.sharepoint.com/:x:/r/sites/test123/_layouts/15/Doc.aspx?sourcedoc=%7Bb8exxx66-2f8a-486a-9426-6cd93abcd22097b%7D&action=default&uid=%7BB8EFG30666-2F8A-486A-9426-6CD93A22097B%7D&ListItemId=671204&ListId=%7B7BDD3AD3-36BCDE-4E43-BB21-9B68136E8091%7D&odsp=1&env=prod

You can store a set of those values as an array variable in the Initialize Variable step(blue box in below screenshot) in MS Flow and use those to Get file properties and the copy the respective files. Please find a sample screenshot below.

Copy specific files in SharePoint


Comments