Power Platform Community Forum Thread Details

Please use this flow.

Say I have these files in my SharePoint Document Library:

I want these same files in my local folder:

Flow details:

I am using "Get files (properties only)" action as I need only those files and not any other data or folders. I think when you use the action "List folder" action, you will get one first folder as "Forms". We don't want that extra trouble of checking that as well. Instead use this action I suggested and it gets only the files. In my case, I'll get those 2 files data:

From the above pic, this much data will serve the best in getting your files data.

For each loop for each file.

Next use "Get file content" action. As I said the Identifier from the previous pic. plays an important role in getting your data. This will give you a binary data.

Next action is "Convert binary data to file". You have the binary data got from the previous action, use that in this action, mention the main path folder and also give the file name. You need to use FileNameWithExtension to get the same file stored on your system.

If you see in your flow in that convert binary data to file action, you used the name. That will save it as non-readable file as it doesn't have the extension of the file. Hence you need to use the FileNameWithExtension.

Output:

Before:

After:

Code (just copy paste this into your flow):

SET MainSharepointFolder TO $'''C:\\Users\\Username\\Desktop\\Sharepoint files'''
@@dataset: 'Nathan Sharepoint - https://tangentia.sharepoint.com/sites/NathanSharepoint'
@@table: 'MainFolder'
@@folderPath: ''
@@viewScopeOption: ''
@@view: ''
@@'OutputSchema:GetFileItemsResponse': '472971001'
@@connectionDisplayName: 'Cr327ea_shared_sharepointonline_b2cd1d10'
External.InvokeCloudConnector Connection: '53a7b581-ebd3-4b71-ad09-91eb167a74a8' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'GetFileItems' @dataset: $'''https://tangentia.sharepoint.com/sites/NathanSharepoint''' @table: $'''fe9a8b54-9a57-4b43-8a2b-e3f1d9b61721''' @GetFileItemsResponse=> GetFileItemsResponse
LOOP FOREACH CurrentItem IN GetFileItemsResponse.value
 IF CurrentItem['{IsFolder}'] = $'''False''' THEN
 @@dataset: 'Nathan Sharepoint - https://tangentia.sharepoint.com/sites/NathanSharepoint'
@@id: '%CurrentItem[\'{Identifier}\']%'
@@connectionDisplayName: 'Cr327ea_shared_sharepointonline_b2cd1d10'
External.InvokeCloudConnector Connection: '53a7b581-ebd3-4b71-ad09-91eb167a74a8' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'GetFileContent' @dataset: $'''https://tangentia.sharepoint.com/sites/NathanSharepoint''' @id: CurrentItem['{Identifier}'] @inferContentType: True @GetFileContentResponse=> GetFileContentResponse
 File.ConvertFromBinary BinaryData: GetFileContentResponse File: $'''%MainSharepointFolder%\\%CurrentItem['{FilenameWithExtension}']%''' IfFileExists: File.IfExists.DoNothing
 END
END

# [ControlRepository][PowerAutomateDesktop]

{
 "ControlRepositorySymbols": [],
 "ImageRepositorySymbol": {
 "Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}",
 "ImportMetadata": {},
 "Name": "imgrepo"
 },
 "ConnectionReferences": [
 {
 "ConnectorId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
 "DisplayName": "Cr327ea_shared_sharepointonline_b2cd1d10",
 "InternalId": "53a7b581-ebd3-4b71-ad09-91eb167a74a8",
 "IsDisabled": false,
 "LogicalName": "Cr327ea_shared_sharepointonline_b2cd1d1030914d73acf2e7e0c034dd5d",
 "IsEmbedded": false,
 "ConnectionName": "shared-sharepointonl-e375c369-f52d-4c7e-a704-11a21f81186a",
 "ConnectionDisplayName": "nalvares@tangentia.com"
 }
 ]
}

I hope this helps.