File System
Connect to File Systems on your local or network machines to read from and write to files using the On-Premises Data Gateway.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions |
Power Automate | Standard | All Power Automate regions |
Power Apps | Standard | All Power Apps regions |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
For more information about the connector, see the in-depth section.
- In some cases, When a file is added or modified (properties only) and When a file is created (properties only) triggers may delay in returning files immediately and postpone newly created/modified files for the next trigger runs. This means that the trigger does not guarantee to return all files in a single run when "Split On" option is disabled.
Name | Value |
---|---|
Maximum file size for general operations (in MB) | 30 |
Maximum file size for create file operation (in MB) | 20 |
On-premises data gateway connection timeout (in seconds) | 30 |
Maximum number of megabytes being transferred to/from the connector within a bandwidth time interval (per connection) | 1000 |
Bandwidth time interval (in miliseconds) | 60000 |
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
Root folder | string | Root folder path (examples: \MACHINE\myShare or C:\myShare) | True |
Authentication Type | string | Authentication type to connect to your gateway computer | |
Username | securestring | Username credential (e.g. DOMAIN\Username) | True |
Password | securestring | Password credential | True |
Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
Append file |
This operation appends data to a file. |
Copy file |
This operation copies a file to a file system. |
Create file |
This operation creates a file. If the file already exists, the existing content is replaced. |
Delete file |
This operation deletes a file. |
Extract archive to folder |
This operation extracts an archive file into a folder (example: .zip). |
Get file content |
This operation gets the content of a file. |
Get file content using path |
This operation gets the content of a file using the path. |
Get file metadata |
This operation gets the metadata for a file. |
Get file metadata using path |
This operation gets the metadata of a file using the path. |
List files in folder |
This operation gets the list of files and subfolders in a folder. |
List files in root folder |
This operation gets the list of files and subfolders in the root folder. |
Rename File |
This operation renames a file. |
Update file |
This operation updates a file. |
This operation appends data to a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
File content
|
body | True | binary |
Content to add to the file |
Returns
Blob metadata
- Body
- BlobMetadata
This operation copies a file to a file system.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Source path
|
source | True | string |
Path to source file |
Destination file path
|
destination | True | string |
Destination file path, including target filename |
Overwrite?
|
overwrite | boolean |
Overwrites the destination file if set to 'true |
Returns
Blob metadata
- Body
- BlobMetadata
This operation creates a file. If the file already exists, the existing content is replaced.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder path
|
folderPath | True | string |
Select a folder |
File name
|
name | True | string |
Name of the file |
File content
|
body | True | binary |
Content of the file |
Returns
Blob metadata
- Body
- BlobMetadata
This operation deletes a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
This operation extracts an archive file into a folder (example: .zip).
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Source archive file path
|
source | True | string |
Path to the archive file |
Destination folder path
|
destination | True | string |
Path to the destination folder |
Overwrite?
|
overwrite | boolean |
Overwrites the destination files if set to 'true' |
Returns
- response
- array of BlobMetadata
This operation gets the content of a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
This operation gets the content of a file using the path.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File path
|
path | True | string |
Select a file |
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
This operation gets the metadata for a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
Returns
Blob metadata
- Body
- BlobMetadata
This operation gets the metadata of a file using the path.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File path
|
path | True | string |
Select a file |
Returns
Blob metadata
- Body
- BlobMetadata
This operation gets the list of files and subfolders in a folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder
|
id | True | string |
Select a folder |
Returns
- response
- array of BlobMetadata
This operation gets the list of files and subfolders in the root folder.
Returns
- response
- array of BlobMetadata
This operation renames a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
New name
|
newName | True | string |
New name for the file |
Returns
Represents blob datasets metadata response
- Body
- BlobMetadataResponse
This operation updates a file.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Select a file |
File content
|
body | True | binary |
Content of the file |
Returns
Blob metadata
- Body
- BlobMetadata
When a file is added or modified (properties only) |
This operation triggers a flow when one or more files are added or modified in a folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created. |
When a file is created (properties only) |
This operation triggers a flow when one or more files are created in a folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created. |
This operation triggers a flow when one or more files are added or modified in a folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder
|
folderId | True | string |
Select a folder |
Number of files to return
|
maxFileCount | integer |
Maximum number of files to return by single trigger run (1-100). Note that 'Split On' setting can force trigger to process each item individually. |
|
Check Created and Modified Time
|
checkBothCreatedAndModifiedDateTime | boolean |
If the flag is set to true, the trigger will check the file's created date and time and the file's last modified date and time. If the flag is set to false, the trigger will only check the file's last modified date and time. |
Returns
Blob metadata
- List of Files
- BlobMetadata
This operation triggers a flow when one or more files are created in a folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder
|
folderId | True | string |
Select a folder |
Number of files to return
|
maxFileCount | integer |
Maximum number of files to return by single trigger run (1-100). Note that 'Split On' setting can force trigger to process each item individually. |
Returns
Blob metadata
- List of Files
- BlobMetadata
Blob metadata
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
The unique id of the file or folder. |
Name
|
Name | string |
The name of the file or folder. |
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
Path
|
Path | string |
The path of the file or folder. |
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
Size
|
Size | integer |
The size of the file or folder. |
MediaType
|
MediaType | string |
The media type of the file or folder. |
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
ETag
|
ETag | string |
The etag of the file or folder. |
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
Represents blob datasets metadata response
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
The unique id of the file or folder. |
Name
|
Name | string |
The name of the file or folder. |
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
Path
|
Path | string |
The path of the file or folder. |
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
Size
|
Size | integer |
The size of the file or folder. |
MediaType
|
MediaType | string |
The media type of the file or folder. |
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
ETag
|
ETag | string |
The etag of the file or folder. |
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
This is the basic data type 'binary'.