Compare 2 CSV files and store result in 3rd CSV file using PowerShell

Below script is to compare 2 CSV files and store result in 3rd CSV file using PowerShell,

$file1 = Import-CSV -Path "C:\A.CSV"

$file2 = Import-CSV -Path "C:\B.CSV"

$result = Compare-Object -ReferenceObject $file2 -DifferenceObject $file1 -Property List_URL -PassThru

If ($result) {

$result | Export-CSV C:\C.csv -NoTypeInformation

}

Comments

Permission audit report for site and all sub sites using PowerShell

Use below script to get Permission audit report for site and all sub sites using PowerShell, Add-PSSnapin "Microsoft.SharePoint.PowerShell" $URL="https://intranet.contoso.com/sales/mysite/" $site = Get-SPSite $URL #Write the Header to "Tab Separated Text File" "Site Name`t URL `t Group Name `t User Account `t User Name `t E-Mail" | out-file "E:\Ulhas\UsersandGroupsRpt.txt" #Iterate through all Webs foreach ($web in $site.AllWebs) { #Write the Header to "Tab Separated Text File" "$($web.title) `t $($web.URL) `t `t `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append #Get all Groups and Iterate through foreach ($group in $Web.groups) ...

The instance has exceeded the outbound http request quota for a 1.00:00:00 time period. The 5000 request limit was reached in

This happens when you have so many REST calls from O365 SharePoint designer workflow, below is the KB article for details. https://support.microsoft.com/en-us/help/3076399/sharepoint-2013-workflow-throttling-and-performance-in-sharepoint-online-and-project-online

Populate people picker field with logged in user in SharePoint using JS

Please use below code to populate people picker in SharePoint online, <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(function () { setTimeout(function () { SetUserFieldValue('AuthorName'); }, 1000); }, 'clientpeoplepicker.js'); //Set PeoplePicker Value function SetUserFieldValue(fieldName) { try{ var userAccountName = _spPageContextInfo.userLoginName; //PeoplePicker Object var peoplePicker = $("div[title='" + fieldName + "']"); //PeoplePicker ID var peoplePickerTopId = peoplePicker.attr('id'); //People PickerEditor var peoplePickerEditor = $("input[title='" + fieldName + "']"); //Set Value to Editor peoplePickerEditor.val(userAccountName); //Get Client PeoplePicker Dict var peoplePickerObject = SPClientPeoplePicke...

My SharePoint Technical Experience

Search This Blog