cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HeinBoucher
New Member

File system flow to copy specific file extension from network folder (system) to Sharepoint folder

Hi all

 

I am trying to create an automated flow to grab a system file (with a specific file extension) and copy it into an existing Sharepoint folder. 

 

I've followed what I consider the appropriate route to create the flow, but it is not working. I need some help to get this to work please.

 

Regards,

 

{
    "inputs": {
        "host": {
            "connectionName": "shared_filesystem_1",
            "operationId": "OnUpdatedFiles",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_filesystem"
        },
        "parameters": {
            "folderId": "6e202211-2856-4d17-9ded-5beb8b8626b0",
            "maxFileCount": 10,
            "checkBothCreatedAndModifiedDateTime": true
        },
        "authentication": "@parameters('$authentication')"
    },
    "recurrence": {
        "interval": 5,
        "frequency": "Minute"
    },
    "metadata": {
        "6e202211-2856-4d17-9ded-5beb8b8626b0": "/",
        "operationMetadataId": "1c685d6c-26ff-407a-acaa-d0850de9396d"
    },
    "splitOn": "@triggerOutputs()?['body']"
}
{
    "inputs": {
        "host": {
            "connectionName": "shared_filesystem_1",
            "operationId": "GetFileMetadata",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_filesystem"
        },
        "parameters": {
            "id": "@triggerOutputs()?['body/Id']"
        },
        "authentication": "@parameters('$authentication')"
    },
    "metadata": {
        "operationMetadataId": "2879eb91-92ed-442e-b506-9abcf383f526"
    }
}

 

{
    "inputs": {
        "variables": [
            {
                "name": "SourceFolderPath",
                "type": "array",
                "value": "@split(outputs('Get_file_metadata')?['body/Path'],'/')"
            }
        ]
    },
    "metadata": {
        "operationMetadataId": "4d9e1329-3bfc-47da-adfd-736f6e64b6fc"
    }
}

 

{
    "inputs": {
        "variables": [
            {
                "name": "varSub",
                "type": "string",
                "value": "@{variables('SourceFolderPath')[1]}"
            }
        ]
    },
    "metadata": {
        "operationMetadataId": "6422a75d-9128-492e-8e11-81e1628cc375"
    }
}
{
    "inputs": {
        "host": {
            "connectionName": "shared_sharepointonline",
            "operationId": "CreateFile",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
        },
        "parameters": {
            "dataset": "https://angloamerican.sharepoint.com/sites/KumbaGeologyDroneSurveys",
            "folderPath": "/Shared Documents/General/Kolomela Stockpile surveys",
            "name": "@outputs('Get_file_metadata')?['body/Id']",
            "body": "@outputs('Get_file_metadata')?['body/Name']"
        },
        "authentication": "@parameters('$authentication')"
    },
    "runtimeConfiguration": {
        "contentTransfer": {
            "transferMode": "Chunked"
        }
    },
    "metadata": {
        "operationMetadataId": "83dc0a5d-8071-46cd-b0b9-95e95007554f"
    }
}

Hein

 

 

 

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,340)