Create XML file from Datatable

I have a Datatable with employees and documents like this:

And I would like to create XML file with this structure:

RPA Report ID 2022-03-29 08:00:00 Employee1 Document1 Document2 …… DocumentN Employee2 Document1 Document2 …… DocumentN ………… Employee3 Document1 Document2 …… DocumentN

Can you help me please?
Thank you!

Sorry, here is a structure of XML file:

we can construct a XML Document with XML API and/or with the Help of JSON-ToXML Methods from Newtonsoft

Keep the following in mind: A XML document requires a root element

Sample data:

Result XML:

Find starter help here:
DT_GroupBy-1Col_ToXML.xaml (12.8 KB)

Awesome! Thank you very much!! :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.