SharePoint get files action

Use the Get file(s) action to retrieve one or more file details from your SharePoint site.

Prerequisites

Ensure that you are authenticated before initiating any SharePoint action. For more details, see SharePoint authenticate action.

Procedure

  1. From the Actions pane, select SharePoint > Folder and file > Get file(s) and place it in the canvas.

    SharePoint get files action
  2. In the Site field, select one of the following options:
    • Default site: The site name used during authentication is considered the default site.
    • Other site: If you want to choose a different site, specify the different site name.
  3. In the Folder path field, specify the main Document Library folder name followed by the parent folder.
  4. In the Get all / filter by field, select one of the following options:
    • All files: Select this option to retrieve all file details available in your SharePoint site.
    • File name: Specify a file name to retrieve the file details.
    • File extension: Specify a file extension to retrieve all file details with the specified extension.
  5. In the Session field, select one of the following options:
    • Session name: The name you provided for the session during authentication.
    • Variable: Select a variable which contains the session name.
  6. In the List of files field, select a variable to store the file details.
One or more file details are retrieved and stored in the variable.
Note: The output is retrieved as a list of type Dictionary. To read an individual record (row) in this list, you need to loop through all the dictionary items using the Loop action and read or extract the records (rows) individually. For example, if the list is stored in the variable list_FileDetails and it contains five records, then each record is passed to the Loop action to be processed one at a time. The loop reads the filename, URL, last modified time and Unique Id of each file.SharePoint Get Files Action