Refer to the post for detailed overview of the context where the replace is being used. Bulk Import CSV to SharePoint with Power Automate Options to Import Large tab delimited Data to SharePoint with Power Automate Replace New lines split(trim(body(‘Get_file_content’)), decodeUriComponent(’%0A’)) /r/n Replace tab characters split(item(), decodeURIComponent(’%09’)) /r Replace carriage return split(item(), decodeURIComponent(’%09’)) /t

References https://sharepointcass.com/2020/05/14/programmatically-updating-sharepoint-list-properties-in-power-automate-without-affecting-the-version-history/

This script adds a content type from the content type hub to the “Documents” library within a SharePoint site. [string]$ClientId = "xxxxx" [string]$sitesFilesPath ="C:\Users\xx\Documents\scripts\HubSites.csv" [string]$CertPath = "C:\Users\xx\ertificates\ReshmeeCertPnP.pfx" [string]$TenantUrl = "https://contoso.sharepoint.com" $ContentTypes = @("Test Record", "Test 1 Record", "Document Set") [string]$TenantName = "contoso" $CertPassword = Read-Host "Please enter Certificate Password:" -AsSecureString [string]DocumentSetFeatureId = "3bae86a2-776d-499d-9db8-fa4cdc7884f8" #$csvPath = Join-Path $directorypath $sitesFiles $sites = Import-Csv -Path $sitesFilesPath if (-not $sites -or $sites.Count -eq 0) { write-host "No rows found in CSV: $sitesFilesPath" -BackgroundColor Red throw "Empty CSV.