Salaudeen Rajack's SharePoint Experiences!
CSV files offer simple and easy ways for data manipulation, automation and analysis. Discover how to work with CSV files in SharePoint using PowerShell. Get started today!
Scenario: My requirement is to import data from a CSV file to the SharePoint Online list from a local drive every day! Create a List in SharePoint Online, matching columns from the CSV file, before running the script! The column names in the CSV should match the Internal Names of the columns…
Read more
Do you need to export user profile properties from SharePoint for reporting or other purposes? It’s a common requirement in SharePoint to prepare reports from user profile properties. Here are my PowerShell scripts to get user profile properties in SharePoint. Important: Make sure User Profile Service Application is created, up and running…
Read more
Requirement: Generate a report to get the Inventory of all web parts in use, in a SharePoint site collection. PowerShell script to generate web parts in use in a site collection: This script gets all web parts in a site collection and generates a report in CSV format. How to find a…
Read more
Requirement: Resource throttling feature in SharePoint controls the resource usage on SharePoint Farm for optimum usage. My requirement was to find all lists exceeding the configured list view lookup threshold limit in SharePoint. PowerShell script to find All Lists which are Exceeding List View Lookup threshold: This script scans all lists in…
Read more
Requirement: Export users and group permissions to Excel in SharePoint. Here is the shortcut to export SharePoint users and groups permission to Excel: Open your SharePoint site in Internet Explorer. Navigate to either site permissions or any User group. Right-click on the users list page, choose the “Export to Excel” item. You…
Read more
At one point in time, I needed to export all users of a site collection to Excel, and my trick to export user information list to Excel as follows: How to Export user information list to excel in SharePoint? Follow these steps to export the user information list. Navigate to Site Settings…
Read more
Requirement: Got a bunch of users and want to add them to SharePoint? Use the script below to bulk add users to the SharePoint group programmatically using PowerShell. This script imports a list of users from Excel. CSV file to SharePoint and add them into appropriate groups. Solution: Let’s import users from…
Read more
Requirement: Find all lists exceeding the list view threshold limit configured on Web Application’s resource throttling settings. PowerShell Script to find all Large Lists that exceeds the configured threshold limit: Larger lists in SharePoint consume more resources and performance killers. We wanted to find all larger lists and libraries in the SharePoint…
Read more
Requirement: We have a SharePoint list with several fields to capture organization-wide people Expertise. This list has a particular field called “Team” and is to be updated from a CSV file of 100+ rows. Yes, the Datasheet view can help, but the problem is: The Team field value to be updated on…
Read more
Analyzing SharePoint permissions for a particular user is often a common task in SharePoint administration. Generally, How do we check what permissions a user has on SharePoint content? By getting into the site or list settings page and checking permissions for the particular user, isn’t it? Well, You may want to analyze…
Read more