Problem I need to migrate a SPWeb with custom SPList form (PowerApps) within the same SPSite collection. Solution Run the following PnP PowerShell command from Windows PowerShell ISE $TemplateFilePath = "C:\temp\ PnPSiteTemplate_ YourSourceFormSubsiteName .xml " $SourceSiteConnection = Connect-PnPOnline https:// YourTenancy .sharepoint.com/sites/ SharePointForms/PROD/YourSourceFormSubsiteName -Interactive Get-PnPSiteTemplate -Connection $SourceSiteConnection -PersistBrandingFiles -IncludeAllPages -Verbose -Out $TemplateFilePath $TargetSiteConnection = Connect-PnPOnline https:// YourTenancy .sharepoint.com/sites/ SharePointForms/PROD/YourTargetFormSubsiteName -Interactive Invoke-PnPSiteTemplate -Connection $TargetSiteConnection -Path $TemplateFilePath -ClearNavigation Disconnect-PnPOnline Ensure the target copied list is unmodified. Do not rename it or change it until the PowerApps are imported and republished to prevent Data Source confusion after import. Navigate to List s...
Download Raspberry Pi Imager . Install Raspberry Pi OS Lite on 16GB microSD card. Remember to click the Setting icon to enter your Wifi SSID and password as well as enabling SSH and default username: pi and password: raspberry Insert the microSD card onto the Raspberry Pi and power it up via USB power supply. Get the IP address of the Raspberry Pi (via HDMI or wifi-router web-console) then configure port forwarding on the router WAN interface for TCP 443 to the IP address of the Raspberry Pi. Download PuTTY and run it to connect to Raspbian via SSH ( Host Name: IP Address of the Raspberry Pi then click Open and if prompted by Putty alert, click Yes ) then login as: pi and password: raspberry . To change default password and timezone use the following command: sudo raspi-config Run curl -L https://install.pivpn.io | bash and follow the wizard to install OpenVPN server. When prompted: Protocol , select TCP 443 then Ok C...
A few weeks ago I was researching for ways to extract Management Log | View Details on Infinity Intelledox Version 9 and Version 10 to analyse failed actions (CRM, BPOINT, REST) and finally found the following SQL statement that saved my day. Hopefully it will save yours too... Cheers... SELECT datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[1]','varchar(max)') as Message FROM dbo.template_log tl join dbo.Intelledox_User iu on tl.User_ID = iu.User_ID join dbo.Template_Group tg on tl.Template_Group_ID = tg.Template_Group_ID join dbo.Template t on tg.Template_Guid=t.Template_Guid WHERE messages.value('(Messages/Message/@Description)[1]','varchar(max)') is not null UNION SELECT datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[2]','varchar(m...
Comments