I was able to try out the "create list" functionality today and here is what I noticed:
- This does NOT seem to work across BPOS and Non-BPOS site collections. For example, I have an old site collection that has XXXX-portal1...at the beginning of the URL. These are the original site collections from the initial launch of Microsoft's online services...way before Office 365 existed. These URL's used to have XXX.microsoftonline.com...in the URL until MS renamed all of them around 2016/2017. Nevertheless, you can't use this method to create a new list in another site collection that doesn't match the source URL. So If I want to copy a list from XXXX-portal1.sharepoint.com....to XXXX.sharepoint.com....It says something went wrong. Ultimately we have 2 root sites. One with portal1 in the URL and one without....if we try to copy a list between another site that is doesn't match the beginning of the URL...it won't show any lists available
- I was only able to see the "from lists" option. I did not see the "from excel" option