Power Platform Community Forum Thread Details

Hello Power Automate Community,

I'm trying to create a daily backup flow where all files from a specific Google Drive folder are copied to a SharePoint site. The backup should occur every day and create a new folder in SharePoint named with the current date (in the format YYYY-MM-DD), and then copy all files from the Google Drive folder into that newly created folder.

Here’s what I’ve attempted so far:

Trigger: A recurrence trigger set to run daily.
Action 1: Create a new folder in SharePoint using the "Send an HTTP request to SharePoint" action with the following parameters:
Action 2: List all files in a specific Google Drive folder.
Action 3: Use an Apply to Each action to loop through the files and copy them to the newly created SharePoint folder. For each file, I use:
- "Google Drive - Get File Content" to get the file from Google Drive
- "SharePoint - Create File" to create the file in the new folder on SharePoint.

The issue I am encountering is that the folder creation works fine, but copying the files from Google Drive to the new folder in SharePoint isn't working as expected. Either the flow throws errors or doesn't complete properly.

Has anyone else successfully set up a similar flow or have any suggestions on how to resolve this issue? Am I missing something in the process?

Any advice or a step-by-step guide on how to achieve this would be greatly appreciated!

Thank you in advance for your help.

Categories:

Building flows