Microsoft 365 : SharePoint Online – How to export list schema / downloading list schema

Hi All,

Greetings for the day!!!

Today small learning so sharing

Learning : How to export SharePoint online list schema

Background / Details / Use case

• We have one SharePoint online application
• Initially we have developed application as PowerApp forms
• But then some issues with external users to access Power App forms and also related to licensing issue with external users so we decided to migrate the SharePoint online application into SPFx components
• One of the data source for PowerApp forms is – SharePoint list
• We have quite good amount of fields in SharePoint List, including calculated columns as well
• Since for some reason I need to make the changes in SharePoint list I need to have SharePoint schema
• As while doing application in PowerApps we didnt have chance to documentation, we dont have all list details / schema
• To make the changes to the list and to have documentation in place, we need respective SharePoint list schema
• So the requirement is list available on UI and from there we need to get the schema of list

Steps to get the SharePoint online list schema

• To export list schema we need list GUID
• We will get list GUID from list settings
• Following is my demo list – TestPowerAppMigration

• To get the list GUID we will navigate to list setting – by clicking on “gear” icon and clicking on “List settings” – _layouts/15/listedit.aspx?List=%7Bda58dc07-62e9-4eae-bb2d-81f7e56da0d8%7D
• We will be redirected to “list edit” page – listedit.aspx – _layouts/15/listedit.aspx?List=%7Bda58dc07-62e9-4eae-bb2d-81f7e56da0d8%7D as

• If we notice the URL – _layouts/15/listedit.aspx?List=%7Bda58dc07-62e9-4eae-bb2d-81f7e56da0d8%7D, we have GUID available in query string parameter – List and in between %7B and %7D – da58dc07-62e9-4eae-bb2d-81f7e56da0d8
• Once we have GUID available, we are ready to export / download list schema
• We have SharePoint list schema export link – /_vti_bin/owssvr.dll?Cmd=ExportList&List={List GUID}

/_vti_bin/owssvr.dll?Cmd=ExportList&List={List GUID}

{mysite}/_vti_bin/owssvr.dll?Cmd=ExportList&List={List GUID}

• Downloading our list schema – prepare the URL with our list GUID and hit into browser

https://knowledgejunction1.sharepoint.com/sites/Demo//_vti_bin/owssvr.dll?Cmd=ExportList&List={da58dc07-62e9-4eae-bb2d-81f7e56da0d8}

• As we hit the above URL in browser, “owssvr.xml” file get downloaded

Thanks for reading !!! HAPPY LEARNING!!!