XML with Namespace - extract sibling value or default value when element is empty or missing

[ppr (Peter Preuss)]

Similar to

How to extract value from element xml if other element has a especific value

Maybe the following will work or provide complete XML data for cross checks xmlDes.Root.Descendants(dicNamespaces(“n4”) + "AdditionalProperty").Where(Function (x) x.Element(dicNamespaces("n2") + "Name").Value.Trim.Equals("@@FamiliaProducto")).Select(Function (x) x.Element(dicNamespaces("n2") + "Value").Value).FirstOrDefault() But with Query Syntax we can organize it more readable used within an assign activity strValue = (From xe In xmlDes.Root.Descendants(dicNamespaces("n4") + "AdditionalPr…

give a try:

(From xe In xmlDes.Root.Descendants(dicNamespaces("n4") + "AdditionalProperty")
Where xe.Element(dicNamespaces("n2") + "Name").Value.Trim.Equals("@@FechaPago")
Select v=  xe.Element(dicNamespaces("n2") + "Value").Value).DefaultIfEmpty("N/A").First()