azure-logic-appsazure-logic-app-standard
Copy files - SharePoint data to Azure Blob using Logic Apps
I have a scenerio where i have multiple Parent folders in sharepoint, these folders contain multiple nested or sub folders and then have a file. How can i copy those files to blob by maintaining the same folder structure what we had in Sharepoint using Logic app.
Folder Structure- Under Document folder i have 2 folders Result and Test .
Result -> Result1 -> Result2 -> test.xlsx
test -> Folder1 -> Folder2 -> Folder3 -> file1.xlsx,file2.xlsx,file3.xlsx
Flow which i tried-
Solution
I have files in Test/demo/demo1 folder in SharePoint.
I am using the below workflow to copy these files to blob storage by keeping the folder structure intact.
Code-
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"For_each": {
"actions": {
"Create_blob_(V2)": {
"inputs": {
"body": "@body('Get_file_content_using_path')",
"headers": {
"ReadFileMetadataFromServer": true
},
"host": {
"connection": {
"referenceName": "azureblob"
}
},
"method": "post",
"path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('AccountNameFromSettings'))}/files",
"queries": {
"folderPath": "/samples-workitems",
"name": "@items('For_each')?['Path']",
"queryParametersSingleEncoded": true
}
},
"runAfter": {
"Get_file_content_using_path": [
"SUCCEEDED"
]
},
"runtimeConfiguration": {
"contentTransfer": {
"transferMode": "Chunked"
}
},
"type": "ApiConnection"
},
"Get_file_content_using_path": {
"inputs": {
"host": {
"connection": {
"referenceName": "sharepointonline"
}
},
"method": "get",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('**********'))}/GetFileContentByPath",
"queries": {
"inferContentType": true,
"path": "@items('For_each')?['Path']",
"queryParametersSingleEncoded": true
}
},
"type": "ApiConnection"
}
},
"foreach": "@body('List_folder')",
"runAfter": {
"List_folder": [
"SUCCEEDED"
]
},
"type": "Foreach"
},
"List_folder": {
"inputs": {
"host": {
"connection": {
"referenceName": "sharepointonline"
}
},
"method": "get",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('*********'))}/folders/@{encodeURIComponent('%252fTest%252fdemo%252fdemo1')}"
},
"metadata": {
"%252fTest": "/Test",
"%252fTest%252fdemo%252fdemo1": "/Test/demo/demo1"
},
"runAfter": {},
"type": "ApiConnection"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"triggers": {
"When_a_HTTP_request_is_received": {
"kind": "Http",
"runtimeConfiguration": {
"concurrency": {
"runs": 1
}
},
"type": "Request"
}
}
},
"kind": "Stateful"
}
Output-
Update-
I have two below folder structure-
Test -> Folder1 -> Folder2 -> Folder3 -> All the files
Test -> Result -> Result1 -> Result2 -> All the files
My workflow looks like to below-
Code-
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"For_each": {
"actions": {
"Condition": {
"actions": {
"Create_blob_(V2)": {
"inputs": {
"body": "@body('Get_file_content_using_path')",
"headers": {
"ReadFileMetadataFromServer": true
},
"host": {
"connection": {
"referenceName": "azureblob"
}
},
"method": "post",
"path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('AccountNameFromSettings'))}/files",
"queries": {
"folderPath": "/samples-workitems",
"name": "@items('For_each')?['{FullPath}']",
"queryParametersSingleEncoded": true
}
},
"runAfter": {
"Get_file_content_using_path": [
"SUCCEEDED"
]
},
"runtimeConfiguration": {
"contentTransfer": {
"transferMode": "Chunked"
}
},
"type": "ApiConnection"
},
"Get_file_content_using_path": {
"inputs": {
"host": {
"connection": {
"referenceName": "sharepointonline"
}
},
"method": "get",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('**************'))}/GetFileContentByPath",
"queries": {
"inferContentType": true,
"path": "@items('For_each')?['{FullPath}']",
"queryParametersSingleEncoded": true
}
},
"type": "ApiConnection"
}
},
"else": {
"actions": {}
},
"expression": {
"or": [
{
"equals": [
"@items('For_each')?['{Path}']",
"Test/Folder/Folder1/Folder2/Folder3/"
]
},
{
"equals": [
"@items('For_each')?['{Path}']",
"Test/Result/Result1/Result2/"
]
}
]
},
"type": "If"
}
},
"foreach": "@body('Get_files_(properties_only)')?['value']",
"runAfter": {
"Get_files_(properties_only)": [
"SUCCEEDED"
]
},
"type": "foreach"
},
"Get_files_(properties_only)": {
"inputs": {
"host": {
"connection": {
"referenceName": "sharepointonline"
}
},
"method": "get",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('*********'))}/tables/@{encodeURIComponent(encodeURIComponent('ea140ea6'))}/getfileitems",
"queries": {
"viewScopeOption": "RecursiveAll"
}
},
"runAfter": {},
"type": "ApiConnection"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"triggers": {
"When_a_HTTP_request_is_received": {
"kind": "Http",
"runtimeConfiguration": {
"concurrency": {
"runs": 1
}
},
"type": "Request"
}
}
},
"kind": "Stateful"
}
Output:-
- Error in Azure logic app workflow when using inline java script action
- Azure Logic App - Create CSV form JSON to send in Email
- Azure Key Vault Disabled public access, how to access it through the portal via internet
- trigger logic app from Azure Service bus in sequance
- Initiate Azure DevOps Release Pipeline from Logic App and Retrieve Environment Variable Output from the pipeline
- xpath expression not working in Logic Apps
- Blocker when adding a blob action in the logic app
- Workflow and API connection provisioning for Standard logic app via Bicep templates/scripts
- Logic App (standard) deployment via DevOps pipeline - kudu service unavailable 503
- Logic Apps copy action gives: The managed identity used with this operation no longer exists. To continue, set up an identity or change the connection
- Logic App PDF File from Sharepoint uploading to Azure Blob is Blank
- Delete files from destination if deleted from source using logic app
- Creating CSV table from Crowdstrike API output
- Convert report JobFailureCode name Succes with Green and Failed with Red
- Logic App Workflow - Flat File Encode error - Invalid Schema
- Copy Folder along with files from Azure Blob to SharePoint
- In Azure Logic Apps, how do I take SQL query results that are JSON and populate an array so I can use the results is a conditional logic?
- Append result in Azure Logic Apps
- Create an API Connection to Azure KeyVault using Service Principal Authentication through ARM template
- How to trigger Azure Logic App when a file is not being uploaded in Blob Storage? When you have replacing previous file?
- How to iterate through a JSON array and read a specific value using Logic App?
- Generate workflow in current devops sprint through logic apps
- Trigger concurrency runtime configuration cannot be removed once specified
- The execution of template action 'Response' is skipped: the client application is not waiting for a response from service
- Using Terraform to deploy Standard Logic App with Liquid Template Maps
- VSCode Logic App func.exe Service Bus Transport Type
- How can I get the UPN of the person who is activating a EntraID Identity Governance Lifecycle Workflow?
- Azure Logic App - xpath for xml with namespace prefix
- How to get data from Azure Workflow Trigger Histories - List
- Can Azure Logic Apps call a stored procedure with multiple select statements?