Copy folder with files from Sharepoint to Blob Storage

Prajapati, Hridesh [L&T Infotech] 6

I want to copy folder along with files from Sharepoint to Blob storage

1 answer

MayankBargali-MSFT 68,471 Reputation points

2021-09-07T04:52:03.097+00:00

@Prajapati, Hridesh [L&T Infotech] Logic app have Sharepoint connector and Azure blob connector that you can use in your workflow to achive your requirement.
The workflow will be : Logic app trigger --> Get files (properties only) --> loop in through result --> check condition if the item is not folder --> Get file content --> Create Blob v2

For you reference attaching the code view and screeshot of the workflow. You can modify it according to your need.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Please sign in to rate this answer.

2 people found this answer helpful.
Prajapati, Hridesh [L&T Infotech] 6 Reputation points

2021-09-08T14:40:09.133+00:00

This solution looks good. As I am new to Logic app I have to learn little bit on it and then implement your solution. Appreciate your effort for providing codeview

Prajapati, Hridesh [L&T Infotech] 6 Reputation points

2021-09-08T17:45:49.49+00:00

@MayankBargali-MSFT : Can you also guide me how I can do the recursive call in logic app to check if it folder or file. Using "for each" I can just iterate to single folder level. In my case files can be present at any hierarchical level i.e. Folder1-> Folder2-> Folder3->Folder4 -> xyz.pdf

MayankBargali-MSFT 68,471 Reputation points

2021-09-10T04:06:04.823+00:00

@Prajapati, Hridesh [L&T Infotech] Get-Files (properties-only) action returns the list of all files/folder in the library and by default it returns the nested files and folder. You only need to loop in through the result list of Get-Files (properties-only) as I have done in my workflow screenshoot and the same you can see in the code view.

Prajapati, Hridesh [L&T Infotech] 6 Reputation points

2021-09-27T05:43:19.527+00:00

Solution works good ! Thanks
One issue is since the Sharepoint library has lots of files in it , it return me error as reached max size.
So I applied Filter Query to limit the output of the Get Files (Properties)
Odata Filter Query :

Option 1 : substringof( 'XYZ',FileDirRef) eq -1
Option 2 : indexof(FileDirRef, 'XYZ') gt -1

but both of this option didn't worked.
Can you please guide me to provide any solution how I can apply the filter or else who to limit the output of Get Files (Properties)

Sean Duff 10 Reputation points

2023-04-19T17:37:20.3133333+00:00

Hi that did not answer the question can you copy the files and the folder structure to Azure files or blob??

charitha gamage 0 Reputation points

2023-10-28T04:57:42.97+00:00

Does it copy folders too? @MayankBargali-MSFT
Sign in to comment