Skip to main content

Query Data – Filter by Folder Path in Document Library

Learn how to use Query Data with Path filters to query files or folders in a specific folder of a document library.

Updated yesterday

Introduction

The Query Data function in Yeeflow enables retrieving records from a selected data source during a workflow or form action. When you choose a Document Library as the data source (see Document Library overview), you can apply a Path filter to query files or folders within a specific directory.

This capability works in both Query Data actions in workflows (see Query Data Action guide) and Query Data steps in forms (see Query Data Step guide).


When to Use

You can use Path filters with Document Libraries in scenarios like:

  • Supplier approval workflows: Check whether necessary certificates exist under a specific supplier folder before approval continues.

  • Business travel requests: Display required travel documents stored in a specific folder for review on a form.

  • Contract management: Verify files under contract folders to ensure compliance before progressing in the process.


How to Configure Query Data with Path Filter

A. Configure in Query Data Action (Workflow)

1️⃣ Add Query Data Action:

  • In the workflow designer, drag and drop the Query Data action.

  • Select your Application (e.g., Purchase Management_AD) and set the Data source to a Document Library (e.g., Supplier Library).

2️⃣ Set Data Filter (Path Filter):

  • Click the Condition button next to Data filter.

  • In the Data filters popup:

    • Where: Path

    • Condition: Equals

    • Value: Select your folder (e.g., New Supplier Folder)

3️⃣ Add Optional Conditions:

  • You can click Add Condition to further refine your query results. Common examples:

    • Type = file → Only query files

    • Extension = pdf → Only query PDF files

    • Created By = user1 → Only query files created by a specific user


B. Configure in Query Data Step (Form Action)

1️⃣ Add Query Data Step:

  • In the form’s Actions panel, select Query Data.

  • Choose the Application and set the Data source to a Document Library.

2️⃣ Set Data Filter:

  • Click Condition to configure the filter.

  • In the filter popup:

    • Where: Path

    • Condition: Equals

    • Value: Select your folder (e.g., Approved Suppliers)

3️⃣ Optional Conditions

  • Add additional conditions if needed for precise filtering. Examples:

    • Type = file → Only query files.

    • Extension = pdf → Only query PDF files.

    • Name Contains draft → Only query files whose name contains draft.


Example Condition Setups

Goal

Example Condition Setup

Query all files in a folder

Path = New Supplier Folder AND Type = file

Query PDF files only

Path = New Supplier Folder AND Type = file AND Extension = pdf

Query files created by user1

Path = New Supplier Folder AND Type = file AND Created By = user1


Example Use Case

💼 Business Travel Request Form:
Query and display uploaded supporting documents (e.g., travel insurance, tickets) stored in a designated folder so approvers can review them during approval.

💼 Supplier Approval Workflow:
Automatically check if compliance documents exist in a supplier’s folder. If missing, stop the workflow or trigger a notification.


Summary

✅ The Query Data action (see Query Data Action guide) and Query Data step (see Query Data Step guide) now support Path filtering for Document Library data sources (see Document Library).

By using Path filters, you can:

  • Accurately query files/folders under a specific folder

  • Combine with additional conditions (Type, Extension, Creator, etc.)

  • Make your workflows and forms smarter and more controlled

Did this answer your question?