instead of adding the connection to the list as a sharepoint library connection, we will instead add it as a XML connection, and point it to a url that will allow us to filter the list

.http://{Site}/_vti_bin/owssvr.dll?Cmd=Display&List={ListGuid}&View={ViewGuid}&XMLDATA=TRUE


  • Add a new datasource
  • Receive Data
  • XML Document
  • Paste the path we constructed above, choose “Access the data from the specified location”
  • Give the data connection a name and clear the “Automatically retrieve data when form is opened”