Hi All, I have a column Name of which I am extracting only rows that contain words like "Additive" using conditional column , I have attached the M-Query code for the same. The issue I am facing is that Null are getting transformed as Errors.Please may I have help know where I am wrong.

if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null

Issue Treating nulls in Conditional Column of Type Any

wdx223_Daniel
Community Champion
1 year ago
if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null
Akash_Varuna
Super User
1 year ago
Hi han_rj , I think Text.Contains function expects a non-null value, and when it encounters a null , it throws an error Could You please try this
Table.AddColumn(
#"Changed Type",
"Custom",
each if [Names] <> null and Text.Contains([Names], "Additive") then [Names] else null
)
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Anonymous
Not applicable
1 year ago
Hi han_rj,

Thanks Akash_Varuna and wdx223_Daniel for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu