2

I want to copy files from Azure blob storage to SharePoint Folder using Microsoft Flow. I have tried several times and the flow always fail when its running.

I have attached the flow that I'm currently trying to execute:

Can someone help me with this?

TylerH
  • 20,799
  • 66
  • 75
  • 101
Mishi
  • 55
  • 1
  • 2
  • 12
  • Would you kindly share some more details about whatever you have tried. Thanks – Md Farid Uddin Kiron Nov 06 '19 at 08:47
  • Could you please provide more details or screenshots of your requirements and your microsoft flow ? – Hury Shen Nov 06 '19 at 09:27
  • Are you trying to copy large file and it failed? – George Chen Nov 06 '19 at 09:36
  • https://i.stack.imgur.com/PWQUA.png this is the screenshot that i have tried.In here anyway i cannot copy the file.this is a CSV file and not a big file. I have tried to put a condition and its also failed. – Mishi Nov 07 '19 at 03:17
  • Hi @Mishelle , I have post the solution to the answer area. May I know if the solution helps your problem ? If it worked, could you please [mark](https://stackoverflow.com/help/someone-answers) my answer as "accepted" ? Thanks in advance. – Hury Shen Nov 07 '19 at 12:49
  • Hi @Mishelle, why did you unmark the answer below ? May I know if you have any other concern about this question ? If still have any other concern about it, please feel free to let me know. – Hury Shen Nov 08 '19 at 04:19

2 Answers2

2

For your problem, please refer to the logic I post below (I have upload a testcsv.csv file to the blob storage):

enter image description here

After the trigger "When a blob is added or modified", we need to use "Get blob content" action to get the content of the csv file. Then add "Create file" action of SharePoint and put the file content which we got from blob to the "File Content" box.

By the way, as you mentioned it is a csv file, so in my blob storage container I only have one file by default. If there are more than one file in your blob storage, you can use "List blobs" action and use "For each" to loop it and then create each of the file in SharePoint.

TylerH
  • 20,799
  • 66
  • 75
  • 101
Hury Shen
  • 14,948
  • 1
  • 9
  • 18
2

I tried that however failed as it would not handle if you have folder structure in the blob and you'd like to mirror that structure in SP and copy individual files to folders.

Mehmet Cobanoglu
  • 21
  • 1