Share via

Pipelines Failing when using trim function

Evan Morgoch 1 Reputation point
2025-10-22T17:41:27.35+00:00

Starting this morning, our main pipeline that processes our data running across 3 environments started failing with the following error:

The provided parameters for function 'trim' are not valid

There were no changes with our pipeline, and it was working fine yesterday. We use the trim function inside a dynamic content expression on the Condition in a Filter action. It's working on another pipeline that also uses Trim in a Filter Condition in a near identical fashion, so I'm not sure what the issue is. Anyone else seeing changed behavior this morning?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kalyani Kondavaradala 3,145 Reputation points Microsoft External Staff Moderator
    2025-10-22T17:59:32.57+00:00

    Hi Evan Morgoch,

    Thank you for reaching on Microsoft Q&A!

    Can you please consider checking the below points:

    1. Parameter Validity: Make sure that the parameters you are passing to the trim function are valid. If any of the parameters are NULL or contain unexpected data types, it could lead to the error you are seeing.
    2. Dynamic Content Expression: Since you mentioned using the trim function in a dynamic content expression within a Filter action, double-check the expression to ensure it's correctly constructed. If you’ve copied it from another pipeline, ensure that the context and parameters are accurate.
    3. External Changes: While you noted that there were no changes to your pipeline, sometimes external factors can affect dependencies. Check if there were any updates or maintenance on Azure services that could be impacting this specific function.

    Could you please clarify the below questions, so that we can guide accordingly

    • Can you please let us know what type of data you passing to the trim function?
    • Can you provide an example of the exact dynamic expression you're using with the trim function?

    Thanks!

    Kalyani

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.