Forum Discussion
Helper IVPipeline's Script activity loses HTML tags?
Thanks for the ping, Albert! They messaged me on 6/13 that the problem was fixed, but I was traveling for a stretch. I've been checking in the past few days on two test pipelines, and they seem to be retaining their tags. So I guess it's fixed! Always hard to say with these sorts of things. But promising...
Hi aseagull ,
Based on your description and the provided screenshots, the behavior you're observing (i.e., the HTML tags are displayed in the expression generator, but not in the base UI) may have something to do with the way the UI renders and displays those tags.
In the script-active UI, the SQL editor may not support direct insertion of raw HTML tags. When you paste or type these tags, they may be treated as part of the query syntax or removed during saving.
The expression builder shows the complete query, including the tags, because it may treat the entire string as a literal and not attempt to parse it into SQL syntax.
You can keep a close eye on the execution and output of the pipeline, especially after making changes to the script activity. This can help determine if and when HTML tags are missing, or if there is a specific trigger that causes this behavior.
You can refer to these documents for more information on how to solve this problem
How to use Script activity - Microsoft Fabric | Microsoft Learn
How to monitor pipeline runs - Microsoft Fabric | Microsoft Learn
Data pipelines storage event triggers in Data Factory (Preview) - Microsoft Fabric | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IVFYI, I submitted a ticket and the engineer who called me replicated the problem! No add'l info at this time.
Hi aseagull ,
Thanks for the reply, if this issue has been resolved. If so, you can provide a solution so that other users can benefit from it as well.
Best regards,
Albert He- aseagull
Thanks for the ping, Albert! They messaged me on 6/13 that the problem was fixed, but I was traveling for a stretch. I've been checking in the past few days on two test pipelines, and they seem to be retaining their tags. So I guess it's fixed! Always hard to say with these sorts of things. But promising...