Move or Copy SharePoint Lists connected to Power Apps Canvas apps
Soooo frustrating trying to figure out how to easily copy or move a list from one SharePoint site to another or even to a customer's tenant.
Here is the script I promised and READ CAREFULLY to replace both YourSiteName AND YourName placeholders with your details related to your SharePoint environment.
#Install the Sharepoint Management Shell OPTIONAL UNCOMMENT IF YOU GET "Connect-SPOService' is not recognized"
#Install-Module Microsoft.Online.SharePoint.PowerShell
#Variables for Admin Center and Site Collection URL
$AdminCenterURL = "https://YourSiteName-admin.sharepoint..."
$SiteURL="https://YourSiteName.sharepoint.com/s..."
#Connect to SharePoint Online
Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential)
#Disable DenyAddAndCustomizePages Flag
Set-SPOSite $SiteURL -DenyAddAndCustomizePages $False