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

[ppr (Peter Preuss)]

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") + "AdditionalProperty")
Where xe.Element(dicNamespaces("n2") + "Name").Value.Trim.Equals("@@FamiliaProducto")
Select v=  xe.Element(dicNamespaces("n2") + "Value").Value).FirstOrDefault()

Also good to know is to using XPath with a Namespacemanager, when xPath is known and filter predicates can be managed

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …