Skip to content

Text.RemoveHtmlTags returns error if input HTML is null  #2

@Mike-Honey

Description

@Mike-Honey

Text.RemoveHtmlTags returns an error if the input HTML is null.

Expression.Error: We cannot convert the value null to type Text.
Details:
    Value=
    Type=Type

The best workaround I could come up with is to call the function wrapped in an if statement, e.g. for a Calculated Column:

if [myHTML] = null then null else fnTextRemoveHtmlTags ( [myHTML] )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions