Forum Discussion
Resetting a string pipeline variable
Hi,
inside a my pipeline I've implemented some set variable activities that operate on strings. In particular I'd like to reset the value of a string pipeline variable as a blank value.
Is the correct method to use
@''as a dynamic content?
It doesn't exist any specific espression function.
Thanks
Hi pmscorca ,
- You’re right that a dedicated reset function would be cleaner, but currently Fabric/ADF pipelines don’t support user-defined functions or setting variables to 'null'.
- The supported and recommended approach is to explicitly overwrite the variable with an empty string:
- Set Variable activity → value set to ' ' (empty string)
- Internally this is treated as a reset state, even though the run output may show "\n" due to UI serialization.
- For cleaner design, a common pattern is to encapsulate all variable resets inside a small reusable pipeline (called via Execute Pipeline), which effectively acts as a “reset function” while staying within supported features.
8 Replies
Hi pmscorca,
In Microsoft Fabric Data Factory, string pipeline variables cannot be set to null, and there is no specific function to clear or reset a string value. Since variables are strongly typed, the only way to reset a string variable is to assign it an empty string. You can do this in a Set variable activity by entering an empty string literal ('' or "") as dynamic content. This method is intentional and is the recommended way to represent a blank string value in Fabric pipelines.
Thank you.
Hi, thanks for your reply.
Therefore I need to write('')or
("")as a dynamic content, isn't it?
Hi pmscorca ,
Yes, that’s correct. Use an empty string ('' or "") in the Set variable activity to reset the string variable.
