I would like to be able to extract data from a series of XML files contained within a SharePoint library. Each of the XML files have fields like StartDate, EndDate and checkbox fields that I’d like to extract. I’ve been able to get a spreadsheet to pull data from one xml file but I’d like to capture the data from all the files in the SharePoint library so I can report on the number of forms that meet certain criteria. What I can’t figure out how to do is to read through the list and create one row of data per xml form.
![]()
Bookmarks