search

Find File Path

This is a pre-built Action located under the @Generic Element. The functionality of this Action in Avo Assure is to find a file in a given folder location. The retrieved file path is stored in a dynamic variable.

hashtag
Syntax

Input Value: <file name>;<folder path>

circle-info

Supported Input Formats:

  • Text: Plain string input.

  • Static Value: A fixed value that you manually provide.

  • Dynamic Variable: Value retrieved from a previously stored output variable.

Argument
Description

<file name>

(Required)

Provide the file name to search for a specific file.

Note: To find the file path of the most recently downloaded file, use the LATEST or latest or Latest word parameter.

<folder path> (Required)

Provide the folder path where the action searches for the specified file.

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument
Description

<Dynamic Variable> (Required)

This dynamic variable holds the file path.

<Dynamic Variable> (Optional)

This dynamic variable stores the status as True or False.

hashtag
Example 1: Searching for a File Path by File Name and File Path

In this example, we explain how to search for a file inside a folder.

  • Action: Find File Path

  • Input Value: New Orders;C:\Users\jhon\Downloads

    • The first argument (New Orders) specifies the name of the file to search for.

    • The second argument (C:\Users\jhon\Downloads) specifies the root folder path where the search begins, including all subfolders.

  • Output Value: {File path}

    • The file path (e.g., ['C:/Users/jhon/Downloads/New Orders.xlsx']) is stored in this {File Path} dynamic variable.

    • If the second output variable is defined, the action returns the status as True or False:

      • True: If the file exists in the given folder or any of its subfolders.

      • False: If the file is not found.

  • Logical Explanation: The Find File Path action takes the value from the Input Value column (New Orders;C:\Users\jhon\Downloads) and searches for the specified file within the given folder and all nested subfolders. If the file exists, the action stores the full file path (C:/Users/jhon/Downloads/New Orders.xlsx) in the {File path} variable.

hashtag
Example 2: Searching the File Path for the Latest Downloaded File

In this example, we explain how to retrieve the most recently downloaded file from a specified folder.

Action: Find File Path

Input Value: latest;C:\Users\John\Documents\Datafile_files

  • The first argument (latest) instructs the system to identify the most recently downloaded file in the specified folder.

  • The second argument (C:\Users\John\Documents\Datafile_files) specifies the folder path where the search is performed.

Output Value: {File path}

  • The file path (e.g., ['C:/Users/John/Documents/Datafile_files/New Data.xlsx']) is stored in this {File Path} dynamic variable.

  • If a second output variable is provided, the action returns the status as True or False:

    • True: If the latest file is successfully identified in the given folder.

    • False: If the latest file is not found.

  • Logical Explanation: The Find File Path action takes the value from the Input Value column (latest;C:\Users\John\Documents\Datafile_files) and scans the specified folder to identify the most recently modified or downloaded file. Once found, the action stores the full file path (C:/Users/John/Documents/Datafile_files/New Data.xlsx) in the {File path} variable.

PreviousCopy File/FolderNextGet PDF Page Count

Last updated

Was this helpful?