Power Platform Community Forum Thread Details

I’m currently exporting data from a SharePoint list using the following URL:

https://XXXXX.sharepoint.com/teams/XXXXX/_vti_bin/owssvr.dll?XMLDATA=1&List={D14CC994-F974-41B4-890C-100B6BF661FF}&View={DDB0886F-4295-4B7A-950A-ADB75E6EC685}&RowLimit=0&RootFolder=%2fteams%2fXXXXX%2fLists%2fXXXXX&IncludeVersions=TRUE

This generates an owssvr.xml file that I then load into and report on using Power BI.

What I want to know is, is it possible to use Power Automate to send the HTTPS request and capture the output instead of doing it manually? The output will be over 150K rows and over 150 MB.

I cannot use Power Automate to hit the SharePoint list directly because I need to also capture the version history (hence the &IncludeVersions=TRUE) of each of the returned list items.

Categories:

General topics