Automating Email Notifications in SharePoint (Create & Test a Rule)
In this section, you’ll learn how to create a simple automation rule in SharePoint that sends an email whenever a new item is added to a list. This is especially useful for tracking new customers, support tickets, requests, or any important entries.
Instead of manually checking your list for updates, SharePoint can automatically notify you. 🚀
🔔 Why Use Automation Rules?
Automation rules in SharePoint help you:
📩 Receive instant email notifications
⏳ Reduce manual follow-ups
👀 Stay informed about important changes
⚙️ Turn rules on or off anytime
🛠 Manage rules easily from one place
In this example, we’ll set up a rule that sends an email whenever a new customer is added to a Customers list.
Video Explanation
🛠️ Create an Automation Rule (Item Created)
Automation rules are created directly from the list where you want the trigger to happen.
Step-by-Step Instructions
Open your SharePoint list (e.g., Customers).
At the top menu, click Automate.
Select Rules from the dropdown.
Click Create a rule.
You will see three rule options:
Rule Type
When It Triggers
🆕 Item Created
When a new item is added
✏️ Item Modified
When an existing item is changed
🗑 Item Deleted
When an item is removed
Choose Item Created.
Select who should receive the notification (e.g., yourself or another team member).
(Optional) Add a custom message.
Click Create.
✅ Your rule is now active.
You’ll see:
A short description of the rule
A toggle switch to turn it ON/OFF
The ability to manage it later via Automate → Manage Rules
This gives you full control over your notifications.
🧪 Test the Automation Rule
Now that the rule is created, let’s confirm it works.
Add a New Item
Go to your list.
Click Add New Item.
Fill out all required fields.
Click Save.
The moment you save the new entry, SharePoint triggers the rule.
📬 Verify the Email Notification
Open your Outlook (or email client).
Check your inbox.
You should receive:
A notification email
Details about the newly created item
A link to open the list item directly
🎉 If the email arrives, your automation is working perfectly.
🔄 Managing Your Rules Later
You can always:
Edit the rule
Disable it temporarily
Delete it completely
To do this:
Go to Automate → Manage Rules
This makes it easy to adjust automation as your workflow evolves.
✅ Quick Recap
Automation rules help you stay updated automatically
You can trigger notifications for created, modified, or deleted items
Rules can be enabled, disabled, or edited anytime
Testing confirms everything is working as expected
By using SharePoint automation rules, you make your lists smarter and your workflow more efficient. 🚀
Send Email Alerts When an Associate Is Assigned in SharePoint
In this section, you’ll learn how to automatically notify an employee when they are assigned to a customer in a SharePoint list. This is a practical real-world scenario where responsibility changes need to be communicated immediately.
Instead of manually informing associates when they are assigned to a customer, SharePoint can handle this automatically using built-in automation rules. 🚀
🎯 Why This Rule Is Useful
When working with a Customers list, you may have a column called Associate (Person or Group type).
If someone changes the associate assigned to a customer:
📩 The new associate needs to know immediately
⏳ You avoid delays in task ownership
🔄 Responsibility transitions smoothly
👀 No one misses important assignments
This rule ensures that whenever the Associate field changes, the new associate receives an automatic email notification.
Video Explanation
🛠️ Create a Rule for “Item Modified” (Associate Field Change)
To notify associates when they are assigned to a customer, we need to create a rule that triggers when the Associate column is modified.
Step-by-Step Instructions
Open your SharePoint list (e.g., Customers).
Click Automate in the top menu.
Select Rules.
Click Create a rule.
Choose Item Modified.
You will now configure the condition.
⚙️ Configure the Trigger Condition
After selecting Item Modified, you’ll be asked which column change should trigger the alert.
Select the Associate column from the dropdown.
Set the condition so that the rule triggers when:
The Associate value changes (to any new value).
💡 You do NOT need to specify a particular name. The goal is to notify whoever becomes the new associate.
📩 Configure the Email Notification
Next, set up who should receive the notification.
Choose to notify the Associate column value (the new assigned person).
Add a custom message if desired.
Example custom message:
“You have been reassigned to this customer.”
This makes the email clearer and more professional.
Finally:
Click Create.
✅ Your rule is now active.
🧪 Test the Rule
To confirm everything works:
Open a customer item.
Click Edit.
Change the Associate field to another user.
Click Save.
Now check the newly assigned associate’s email inbox.
📬 They should receive:
An email notification
The name of the customer
Your custom message
A link to the list item
If the email arrives, your automation is working perfectly.
🔍 What This Rule Achieves
Scenario
Result
Associate is reassigned
New associate gets notified
Responsibility changes
No manual follow-up needed
Customer ownership updates
Immediate awareness
✅ Quick Recap
Use Item Modified rules for field change notifications
Select the Associate column as the trigger
Notify the new value (the new associate)
Add a custom message for clarity
Test by editing the list item
By using this automation, you ensure that team members are instantly informed when they are assigned new responsibilities — improving accountability and workflow efficiency. 🚀
Working with Azure DevOps: Create a Project, Import Code, and Set the Default Branch 🚀
In this section, we’ll go step-by-step through the very first things you usually do after signing into Azure DevOps:
Create a new project inside your organization
Import an existing GitHub repository
Configure the correct default branch
These steps are extremely important because they set up the foundation of your DevOps workflow. If the project is not organized properly — or the wrong branch is default — pipelines, pull requests, and deployments can behave incorrectly later.
💡 Key ideas to remember:
Organization = your company or workspace container
Project = a product/app inside the organization
Repository = the source code for that project
Default branch = the branch Azure DevOps uses for PRs, builds, and releases
Video Explanation
1️⃣ Create a Project in Azure DevOps
Before you can store code or run pipelines, you need a project.
A project acts as a workspace that contains:
Boards (work items)
Repos (code)
Pipelines (CI/CD)
Test plans
Artifacts
Think of it as a folder that holds everything related to a single application.
Set visibility → Private (recommended for learning & security)
Click Create
After creation, the URL will update to include:
dev.azure.com/{organization-name}/{project-name}
📌 At this point your project is empty — no code yet — which we’ll fix in the next step.
2️⃣ Import a Public GitHub Repository into Azure DevOps 📦
Instead of starting from scratch, you can import an existing repository. Azure DevOps will copy the entire Git history — commits, branches, and files.
This is useful when:
Migrating from GitHub to Azure DevOps
Testing pipelines on a sample app
Centralizing company code
Because the repository is public, authentication is not required.
Steps
Go to Repos (left sidebar)
Click Import repository
Copy the GitHub repository HTTPS URL
Paste the URL into Azure DevOps
Click Import
⏳ Azure DevOps now clones the repository internally.
What gets imported?
Full commit history
All branches
Folder structure
README and files
⚠️ Note: Private repositories require authentication (PAT or credentials). Public repositories do not.
3️⃣ Set main as the Default Branch 🌿
After importing, Azure DevOps automatically picks the default branch alphabetically — not logically.
That means:
dev ← might become default ❌ main ← what we actually want ✅
This matters because the default branch is used for:
Pull request targets
Pipeline triggers
Release deployments
If it’s wrong, automation breaks later.
Steps
Open Repos → Branches
Find the main branch
Click the three dots (⋯) beside it
Select Set as default branch
You will now see the main branch marked as default.
✔️ What You Have Achieved
Task
Purpose
Created project
Workspace for DevOps workflow
Imported repository
Added real application code
Set default branch
Ensures correct CI/CD behavior
Create and Connect to a Linux Virtual Machine in Azure ☁️🐧
In this section, we’ll set up a Linux virtual machine inside Azure and connect to it securely using SSH. This machine will later act as a self-hosted agent for running DevOps pipelines — meaning builds and deployments will run on your own server instead of Microsoft-hosted agents.
Before starting, here’s what matters most:
🔑 Why we create this VM
Run build & deployment jobs
Install custom tools (Docker, kubectl, etc.)
Control environment versions
Practice real production-like DevOps setups
🔐 How we connect
Using SSH (secure remote login)
With a key pair (.pem file)
Over port 22
💡 Important: Always keep the downloaded key safe — losing it means losing access to the VM.
Video Explanation
1️⃣ Creating a Linux VM in Azure Portal
We’ll create an Ubuntu server that Azure DevOps can later use as an agent machine.
A virtual machine automatically comes with supporting resources:
Network interface
Public IP
Disk storage
Security rules
Azure creates these together so the VM can be accessed over the internet.
Steps
Open Azure Portal
Click Create a resource → Virtual Machine
Configure the basics:
Setting
Example Value
Resource Group
Create new (e.g., Test RG)
VM Name
Any name (e.g., my-vm-azure)
Image
Ubuntu Server 22.04
Username
azureuser
Configure Authentication 🔐
Choose SSH Public Key
Generate new key pair
Give the key a name
Azure will download a .pem file — keep it safe!
This key is your password replacement.
Networking Setup 🌐
To allow remote login:
Allow inbound port → SSH (22)
Without this, connection will fail.
Create the VM
Review settings
Click Create
Download the private key file (.pem)
After deployment completes, open the VM resource and note:
Public IP address
Resource group
Networking details
Your Linux machine is now live 🎉
2️⃣ Connecting to the Linux VM (SSH Login)
Now we log into the server remotely from your computer.
You can use:
PowerShell (Windows)
Terminal (Mac/Linux)
Windows Terminal
Step 1: Go to Key Location
Open terminal and navigate to the folder containing the .pem file.
After fixing permissions, run the SSH command again.
✔️ What You Achieved
Task
Result
Created Linux VM
Cloud server ready
Generated SSH key
Secure authentication
Opened port 22
Remote connectivity
Logged into VM
Ready for DevOps agent setup
You now have your own cloud machine ready to install tools and run CI/CD pipelines 🚀
🚀 Setting Up a Self-Hosted Linux Agent for Azure DevOps
In this section, we’ll configure a Linux Virtual Machine (VM) to act as a self-hosted agent for Azure DevOps pipelines. Instead of using Microsoft-hosted agents, your own VM will execute pipeline jobs — giving you more control, flexibility, and customization options.
Here’s what we’ll cover:
🐳 Installing and verifying Docker
🧰 Installing additional utilities (if required)
🔐 Generating a Personal Access Token (PAT)
🏗 Creating an Agent Pool
🔗 Connecting the VM to Azure DevOps
▶ Running the self-hosted agent
Video Explanation
By the end of this section, your Linux VM will be fully ready to execute CI/CD pipeline jobs 🎯
🐳 Install and Configure Docker
Docker is commonly required in DevOps pipelines, especially for container-based builds and deployments.
Since we are logged in as azureuser, we must grant this user permission to run Docker commands without sudo.
🔹 Grant Docker Permissions
Run:
sudo usermod -aG docker azureuser
This adds the user to the Docker group.
🔄 Restart Docker Service
sudo systemctl restart docker
Restarting ensures permission changes take effect.
🚪 Log Out and Log Back In
Exit the VM session:
exit
Then reconnect using your SSH command. This refreshes group membership.
✅ Verify Docker Installation
To confirm everything works correctly, pull the hello-world image:
docker pull hello-world
If the image downloads successfully:
✔ Docker is installed
✔ The service is running
✔ The user has proper permissions
Your Docker setup is now complete 🎉
🧰 Install Additional Utilities (If Required)
Because this is a self-hosted VM, we are responsible for maintaining it.
Pipelines may require additional tools such as:
unzip
wget
git
language runtimes (Node, Java, etc.)
Even if your current project doesn’t require them, it’s important to understand that future pipelines might.
📦 Example: Install unzip
sudo apt install unzip -y
💡 Tip: Only install what your pipeline needs. Self-hosted agents provide flexibility — but also require proper maintenance.
🔗 Connect the Linux VM to Azure DevOps
Now we’ll connect the VM so that it can execute pipeline jobs from:
Azure DevOps
This involves generating a Personal Access Token and configuring the VM as an agent.
🔐 Generate a Personal Access Token (PAT)
The PAT allows secure communication between Azure DevOps and your VM.
Steps:
Go to your Azure DevOps organization.
Click User Settings (top-right).
Select Personal Access Tokens.
Click New Token.
Configure:
Provide a name
Select Full Access (sufficient for learning purposes)
Click Create
Copy and securely store the token 📋
⚠ In production, always follow the Principle of Least Privilege.
🏗 Create an Agent Pool
Next, create a pool where your VM agent will be registered.
Go to Organization Settings.
Select Agent Pools.
Click Add Pool.
Choose Self-hosted.
Provide a meaningful name (e.g., My Agent Pool).
Allow access to all pipelines if required.
Click Create.
Your agent pool is now ready — but currently empty.
💻 Configure the Linux VM as an Agent
From the Agent Pool page:
Open your pool.
Click New Agent.
Select the Linux tab.
Follow the provided instructions.
Now switch to your Linux VM.
📁 Create a Working Directory
mkdir myagent cd myagent
Verify:
ls
📥 Download the Agent Package
Run the wget command shown in the Azure DevOps portal:
wget <agent-download-url>
Confirm the file exists:
ls
You should see a .tar.gz file.
📦 Extract the Package
tar zxvf <agent-file-name>.tar.gz
After extraction, you should see files including:
config.sh
run.sh
⚙ Configure the Agent
Run:
./config.sh
Follow the prompts:
Accept the license (Y)
Enter your Azure DevOps organization URL
Choose PAT authentication (press Enter)
Paste your Personal Access Token
Enter the agent pool name (My Agent Pool)
Confirm or provide agent name
If successful, the configuration will complete and return you to the terminal.
▶ Start the Agent
Run:
./run.sh
If successful, you will see:
Listening for Jobs
Now return to:
Organization Settings → Agent Pools → My Agent Pool
You should see:
✔ Your agent listed
✔ Status: Online
Your self-hosted Linux VM is now fully connected and ready to execute Azure DevOps pipeline jobs 🚀
🎯 Section Summary
In this section, we:
Installed and verified Docker 🐳
Discussed installing additional utilities 🧰
Generated a Personal Access Token 🔐
Created an Agent Pool 🏗
Configured and started a self-hosted Linux agent 💻
Your environment is now prepared to run CI/CD pipelines using your own infrastructure — giving you greater flexibility and control over your DevOps workflows.
✅ The pipeline runs only when changes are made inside the result folder.
It prevents unnecessary builds when other microservices change.
📦 Resources Section
resources: - repo: self
self refers to the current repository. This is the default behavior.
🧠 Variables Section
Instead of hardcoding values inside tasks, we defined reusable variables:
Variable
Purpose
dockerRegistryServiceConnection
Authenticates to Azure
imageRepository
Name of image in ACR
dockerfilePath
Location of Dockerfile
tag
Unique image version
We use:
tag: $(Build.BuildId)
Build.BuildId is a system-generated variable that uniquely identifies the pipeline run.
Each build gets a unique Docker image tag.
🖥 Pool Section
pool: name: myagentpool
This defines where the pipeline runs.
Both stages use the same self-hosted agent pool.
This is important because Docker images are stored locally on the agent machine.
🏗 Build Stage
Structure:
Stage → Job → Task
The Build stage:
Contains one job
That job contains one Docker task
Command used: build
What it does:
👉 Builds the Docker image using result/Dockerfile 👉 Tags it using $(Build.BuildId)
The image is created locally on the agent machine.
🚀 Push Stage
The Push stage:
Contains one job
That job contains one Docker task
Command used: push
What it does:
👉 Pushes the Docker image to Azure Container Registry 👉 Uses the same image name and tag
🔗 How Build and Push Work Together
There is no automatic transfer of images between stages.
Here’s what actually happens:
1️⃣ Build stage creates the image locally 2️⃣ Image is tagged using Build ID 3️⃣ Push stage runs on the same agent 4️⃣ Push stage pushes that image to ACR
The connection works because:
Same agent pool
Same image repository
Same tag
If the stages ran on different agents, the push would fail because the image would not exist there.
📌 Complete Workflow Summary
Here’s the full flow:
1️⃣ Developer commits code in result folder 2️⃣ Pipeline triggers automatically 3️⃣ Build stage creates Docker image 4️⃣ Image is tagged uniquely 5️⃣ Push stage uploads image to ACR 6️⃣ Image appears under ACR → Repositories
🎯 What This Pipeline Achieves
In this section, we:
Created Azure Container Registry 📦
Created a Docker-based Azure DevOps pipeline 🔧
Used service connections for secure access 🔐
Used variables for clean configuration 🧠
Built and pushed Docker images automatically 🚀
This setup forms the foundation of a container-based CI pipeline in Azure DevOps.
Most Terraform users begin with a simple workflow:
terraform init
terraform plan
terraform apply
Everything runs locally, credentials come from the local machine, and the state file is stored either locally or in a configured backend.
However, real-world teams rarely run Terraform from developer laptops. Infrastructure provisioning is executed from a controlled environment — this is where HCP Terraform (Terraform Cloud) comes in.
This article explains how Terraform Cloud works, what actually changes compared to local execution, and how to correctly authenticate and run Terraform remotely.
Terraform Cloud does not replace the Terraform CLI — it replaces the execution environment.
Instead of:
Local CLI → Cloud Provider API
the architecture becomes:
Local CLI → Terraform Cloud → Cloud Provider API
Your machine only submits configuration and receives logs. The actual Terraform runtime, state, and authentication live in Terraform Cloud.
Key Architectural Difference
Component
Local Terraform
Terraform Cloud
Execution
Runs on developer machine
Runs on HashiCorp infrastructure
State
Local or backend-configured
Always remote
Authentication
Local credentials
Workspace credentials
Audit History
Limited
Built-in
Collaboration
Manual
Native support
Understanding this distinction is essential — most confusion with Terraform Cloud comes from assuming it behaves like a remote backend only. It is actually remote execution, not just remote storage.
Creating the Organization and Workspace
After signing into:
https://app.terraform.io
Create an organization and then create a workspace using:
CLI-Driven Workflow
This workspace acts as an isolated remote Terraform runtime.
Each workspace has:
Its own state file
Its own variables
Its own credentials
Its own run history
Think of it as a remote Terraform working directory.
When learning Terraform, most tutorials start by creating new infrastructure.
But in the real world, companies already have infrastructure running in the cloud — and your job is to bring it under Terraform management without recreating or breaking anything.
Searching, Collaboration, Navigation & RSS Feeds in SharePoint
In this section, you’ll explore some everyday SharePoint features that help you find information faster, collaborate with your team, navigate easily, and stay updated automatically. These tools may look simple, but together they make SharePoint feel less like a storage system and more like a smart workspace.
💡 Why these features matter
Quickly locate files, pages, and list items
Interact with coworkers directly on content
Access all your sites and lists from one place
Receive automatic updates without manually checking
Video Explanation
🔍 Searching in SharePoint
SharePoint includes a powerful global search system available at the top of every site. It doesn’t just search file names — it searches inside files, lists, pages, images, and even metadata tags.
This means you can locate almost anything across your workspace in seconds.
What you can do with search
Find documents, lists, and pages
Locate images tagged with keywords
Jump directly to a specific list item
Filter and sort results for faster navigation
How to perform a search
Go to the search bar at the top of SharePoint.
Type your keyword or phrase.
Press Enter or click the 🔍 icon.
Refine your results
After searching, you can narrow results using:
Tabs
All – everything related to your search
Files – documents only
Sites – related SharePoint sites
News – posts and announcements
Images – pictures and media
Filters
File type
Last modified date
Sorting options
➡️ Clicking a result opens the exact item location, including breadcrumbs showing where it exists in SharePoint.
💬 Collaboration & Social Features
Modern SharePoint pages include interactive elements similar to social media platforms. Instead of emailing updates, conversations can happen directly on the content itself.
This keeps communication contextual and organized.
Collaboration tools available
👍 Like pages
💬 Comment on content
👤 Mention coworkers using @name
📊 View page analytics
How to interact with a page
Scroll to the bottom of a modern page.
Click Like or type a comment.
Use @Name to notify someone.
Click Post to share.
📢 Mentioned users receive a notification, helping teams respond quickly without separate messages.
Page insights you can view
Total views
Activity trends
Popular content
🧭 Navigating the SharePoint Home Page
The SharePoint Home page is a global dashboard — different from a site homepage. It acts as your personal starting point across all sites and content.
You can return to it anytime using the Home icon (top left).
What you’ll find here
Frequently used sites
Quick access cards
Activity summaries
Page popularity indicators
Shortcut icons
📰 News
📁 My Files
📋 My Lists
🌐 Create Site
My Lists feature
Shows every list you created across SharePoint — even from different sites.
Each list displays:
List name
Associated site
Create menu
The Create (+) button lets you quickly create:
News posts
Pages
Sites
Documents
Lists
Forms
Presentations
Notebooks
➡️ Think of this page as your SharePoint control center.
📡 Creating an RSS Feed in SharePoint
RSS feeds automatically notify you when changes occur in a list or library. Instead of checking manually, updates come to your RSS reader.
This is especially useful for tracking uploads, edits, or team activity.
Why use RSS feeds
Monitor changes automatically
Track uploads and edits
Centralize updates from multiple sources
How to get an RSS feed link
Open your SharePoint list or library.
Switch to Classic View.
Click the Library/List tab in the ribbon.
Select RSS Feed.
Copy the generated link.
What happens after subscribing
Whenever content changes:
New uploads appear in the feed
Creator name is shown
Timestamp is included
➡️ Your RSS reader collects these updates automatically, keeping you informed without opening SharePoint repeatedly.
✅ Quick Recap
Search helps you instantly find content across SharePoint
Social features enable communication directly on pages
The Home page acts as your central dashboard
RSS feeds notify you about updates automatically
Together, these features improve productivity by reducing navigation time and keeping everyone informed.
👥 Managing User Permissions in SharePoint (Visitors, Owners & Removal)
Permissions are one of the most important parts of SharePoint. They control who can view, edit, or fully manage your site. Instead of giving everyone the same access, SharePoint organizes users into groups — making security easier and safer to manage.
In this section, you’ll learn how to:
Invite users with limited access (Visitors)
Promote users to full control (Owners)
Remove users when access is no longer required
🔐 Best Practice: Always grant the least privilege first. You can increase access later, but preventing accidental edits is much harder after they happen.
Video Explanation
🔹 Invite a User as a Visitor (Read-Only Access)
Visitors are users who can view content but cannot edit anything. This is ideal for stakeholders, auditors, or team members who only need to read information.
When added to the Visitors group, the user can open pages, lists, and documents — but editing options are hidden.
What Visitors Can Do
View pages, lists, and documents
Download files
Search site content
What Visitors Cannot Do
Add or edit list items
Upload or modify files
Change site settings
Steps to Add a Visitor
Click the ⚙ Settings icon (top right)
Select Site permissions
Scroll down and click Advanced permission settings
Locate the Visitors group
Click Grant Permissions
Enter the user’s name or email
Choose the Visitors group
(Optional) Add a message
Click Share / OK
The user receives an email invitation and is automatically added after opening the link.
💡 Tip: If a user should only see information and not modify it — always use the Visitors group.
🔹 Promote a User to Site Owner (Full Control)
Owners have the highest level of access in SharePoint. They can manage permissions, edit content, and configure the site.
Only assign this role to trusted individuals responsible for maintaining the site.
Owners Can
Add, edit, and delete content
Manage permissions
Create lists and libraries
Change site settings
Control structure and navigation
Steps to Make a User an Owner
Go to ⚙ Settings → Site permissions
Open Advanced permission settings
Select the Owners group
Click New → Add users to this group
Enter the user’s name
Add a message (optional)
Click Share / OK
After accepting the email invitation, the user becomes a site owner immediately.
⚠️ Important: Owners can grant permissions to others — only assign this role when necessary.
🔹 Remove a User from a Permission Group
Sometimes access needs to be revoked — for example when a project ends or a team member changes roles. Removing a user from a group immediately updates their permissions.
If they belong to multiple groups, they will still keep access from the remaining groups.
Steps to Remove a User
Go to ⚙ Settings → Site permissions
Click Advanced permission settings
Open the group (e.g., Owners)
Select the user
Click Actions → Remove users from group
Confirm the removal
The permission change takes effect instantly after refresh.
🧠 Reminder: Removing from Owners does not remove access completely if the user still belongs to Members or Visitors.
✅ Quick Permission Overview
Group
Access Level
Typical Use
Visitors
Read-only
Stakeholders, viewers
Members
Edit content
Team contributors
Owners
Full control
Site administrators
Proper permission management keeps your SharePoint environment secure, organized, and collaborative — while preventing accidental changes or data loss.
Managing Default and Custom Permissions in SharePoint
In this section, you’ll learn how SharePoint permissions actually work — not just how to click buttons, but why they’re structured this way. SharePoint follows a security model based on permission levels → assigned to groups → groups contain users.
Understanding this flow is important because:
🔐 You should never assign permissions directly to users (hard to manage later)
👥 Permissions should be controlled through groups
🧠 Always follow the Principle of Least Privilege — give only the access required
🛠 Custom permission levels allow you to fine-tune access instead of using only built-in roles
Once you understand the default permissions, creating your own secure setup becomes much easier.
Video Explanation
1) Understanding Default Permission Levels
Before creating custom permissions, it’s important to understand how SharePoint’s built-in permissions are structured.
SharePoint comes with predefined groups and permission levels:
Default Groups
Owners → Full control
Members → Edit content
Visitors → Read-only
Each group is assigned a permission level, and that permission level is actually a collection of many smaller capabilities (view, edit, delete, manage site, etc.).
How to View Default Permission Levels
Click the Settings (⚙️) icon (top-right)
Select Site permissions
Click Advanced permission settings
In the top menu, click Permission Levels
You will see levels such as:
Full Control
Design
Edit
Contribute
Read
Example: What “Read” Permission Allows
Allowed
View lists and libraries
Open items
View pages
Not Allowed
Edit items
Delete items
Manage site settings
Change appearance
Personal permissions
👉 This is why Visitors can see content but cannot modify anything.
Key Idea: The Read permission is intentionally restrictive — it protects your data while still allowing access.
2) Creating a Custom Permission Level
Sometimes default permissions are too broad.
Example:
Read = too limited ❌
Edit = too powerful ❌
So you create a custom permission tailored exactly to your needs.
In our case: We want users to read and edit items but not fully control the site.
Steps to Create Custom Permission
Go to Permission Levels page (same place as above)
Open the Read permission level
Click Copy Permission Level
Now configure it:
Name:Read and Edit Description: Can read and edit items
Modify Permissions
Keep everything from Read AND additionally enable:
✔ Edit Items
✔ Approve Items
Then click Create
You now have a new permission level available alongside default ones.
💡 Best Practice Create permissions based on real job responsibilities, not convenience.
3) Create a Group and Assign the Custom Permission
Permissions should be assigned to groups, not directly to users. This keeps your site manageable as your team grows.
Why Use Groups?
Add/remove users without changing permissions
Cleaner security structure
Easier auditing
Scalable management
Create a New Group
Go to Advanced permission settings
Click Create Group
Fill details:
Group Name: Read and Edit Group Description: Members can read and edit
Under Give group permissions to this site ✔ Select Read and Edit
Click Create
Add a User to the Group
Now add people who should have this access.
Open the newly created group
Click New
Enter the user name
Add a message (optional)
Click Share
The user is now part of the group and automatically inherits permissions.
What the User Can Do Now
Because the user belongs to the custom group:
They CAN
View lists
Edit existing items
They CANNOT
Create new list items
Manage site settings
Change structure
This proves the custom permission works exactly as designed.
Key Takeaways
SharePoint permissions work as: Permission Level → Group → Users
Always assign permissions to groups, not individuals
Default permissions are often too broad
Custom permissions allow precise control
Follow the least privilege principle for security
Using this approach keeps your SharePoint environment secure, organized, and easy to maintain as your organization grows.
SharePoint Lists are like smart, collaborative tables where teams can store, track, and manage information. Think of them as an upgraded version of Excel—built directly into SharePoint with powerful features like filtering, automation, and integration with Microsoft 365 tools.
In this section, you’ll learn the different ways to create a list:
From Excel data
From scratch
By copying an existing list
Using ready-made templates
Video Explanation
🚀 Why Use SharePoint Lists?
Before jumping into the steps, here’s why lists are so useful:
🗂 Centralized Data – everyone works from the same source
🎛 Custom Columns – text, choice, number, date, people, and more
🤖 Automation Ready – works with Power Automate & Power Apps
📈 Scalable – perfect for small trackers or large systems
🧱 Method 1 – Create a List from Excel
If you already have data in Excel, you don’t need to retype anything.
Step-by-Step
Prepare Excel Data
Ensure your data has proper column headers
Select the range
Use Format as Table in Excel
Import to SharePoint
Click New → List → From Excel
Upload the file
Preview the table
Configure Columns
Set the correct data type for each column
Choose which column should act as Title / Primary Key
Use Choice type for fields like Department or Location
Create the List
Give it a name (e.g., Customers)
Click Create
✅ Your Excel data is now a fully functional SharePoint list!
🧱 Method 2 – Create a List from Scratch
Perfect when starting fresh.
Steps
Go to New → List → Blank List
Give your list a name
By default, you’ll get a Title column
Add custom columns:
➕ Add Column → Single line of text → Name
➕ Add Column → Choice → Department
Options: Accounting, Sales, HR, etc.
Add items using New Item
💡 Tip: You can rename the Title column to something meaningful like Employee ID.
🧱 Method 3 – Create from an Existing List
Reuse structure without rebuilding everything.
Click New → List → From Existing List
Choose a list to copy
Give the new list a name
Click Create
👉 The new list will contain the same columns and settings.
🧱 Method 4 – Use SharePoint Templates
SharePoint includes ready-made list templates like:
🐞 Issue Tracker
👥 Employee Onboarding
📦 Asset Manager
📝 Event Itinerary
Just:
Select New → List
Scroll to Templates
Pick one
Name it → Create
Instant professional structure! 🎉
🎯 What You’ve Learned
You can now create SharePoint lists:
From Excel imports
From scratch with custom columns
By copying existing lists
Using built-in templates
These lists can become the backbone of tracking customers, employees, assets, projects, and more.
✏️ Editing Lists in SharePoint
SharePoint lists aren’t just for storing data—they’re meant to be edited, updated, and customized as your team works. SharePoint gives you multiple ways to modify list items: quick single-item edits, bulk updates using grid view, and even advanced customization through content types and form layouts.
Let’s walk through the most practical ways to edit and manage your SharePoint lists.
Video Explanation
📝 Edit a Single List Item
This is the most common method when you need to update one record or attach supporting files.
How to edit an item:
Go to your list from Site Contents
Click the item you want to update
Select Edit from the top menu (or from the three dots ⋯ menu)
Update the fields in the form
(Optional) Upload files in the Attachments section
Click Save
💡 Best for: Quick corrections, adding documents, or updating one record at a time.
🔓 Enable “Allow Management of Content Types”
Sometimes you may find that certain items can’t be edited. This usually happens because content type management is turned off.
Enable it like this:
Open List Settings (gear icon → List Settings)
Go to Advanced Settings
Set Allow management of content types = Yes
Click OK
After this:
A new Content Types section appears
You can view and edit the default “Item” content type
Add extra columns from site or list columns
💡 Why this matters: It unlocks deeper control over list structure and ensures full editing flexibility.
📊 Edit in Grid View (Excel-Style Editing)
Need to update many rows fast? Grid view turns your list into a spreadsheet.
Steps:
Open the list
Click Edit in grid view
Update cells directly like Excel
Click Exit grid view to save
⚡ Best for: Bulk updates, data cleanup, and fast entry.
🧩 Powerful Features in the Edit Form
The SharePoint edit form includes more than just fields:
💬 Comments – discuss changes right on the item
🕒 Activity Log – view history of edits
✏️ Edit Columns – choose which fields appear
🎨 Configure Layout – customize header/body/footer (even with JSON)
🔗 Copy Link – share a direct link to the item
These tools help you turn a simple list into a collaborative workspace.
🎯 Key Takeaways
Use basic edit mode for quick updates & attachments
Enable content type management for advanced control
Use grid view for bulk, Excel-like editing
Customize the edit form for better user experience
With these options, SharePoint lists become flexible tools that adapt to how your team works—not the other way around. 🚀
🧩 Working with SharePoint List Features
SharePoint lists are more than simple tables—they’re interactive tools designed to help you explore, organize, and collaborate on data. In this section, we’ll look at some of the most useful built-in list features: sharing individual items, sorting and grouping, using the filter pane, and calculating column totals.
These features make large datasets easier to understand and help teams work smarter together. 🚀
Video Explanation
🔗 1. Item Page in a SharePoint List
Every list item has its own dedicated page where you can view details, track activity, and collaborate through comments.
What you can do:
📎 Copy Link – share a direct URL to a single item
💬 Comments & Activity – discuss updates in context
👥 User Presence – see when others are viewing the same item
How to share an item link:
Open your list and select an item
Click the three dots ⋯ next to it
Choose Copy Link
Share the URL with teammates
💡 Perfect for: Sending someone directly to one record instead of the whole list.
📊 2. Sort and Group Your Data
Large lists can feel overwhelming—sorting and grouping help bring order.
Benefits
Sorting organizes alphabetically or numerically
Grouping clusters similar items into collapsible sections
Try this:
Click any column header
Choose Sort A→Z or Sort Z→A
Select Group by to create categories
Use the arrows to expand or collapse groups
👉 To return to normal view, open the column menu again and uncheck Group by.
🎯 3. Use the Filter Pane
The filter pane lets you narrow results across multiple columns at once—great for big datasets.
Steps
Click the filter icon (top right)
Select values from one or more columns
Click Apply
Use Clear All to reset
Example: Filter Office = Toronto AND Brand = Mercedes to see only matching records.
💡 Ideal for: Finding exactly what you need in seconds.
➕ 4. Column Totals
Need quick calculations? SharePoint can show them directly in the list view.
Available options
🔢 Count – works on any column
➗ Sum & Average – available for numeric fields
How to enable totals:
Click a column header
Select Totals → Count / Sum / Average
View results at the bottom of the list
Combine with Group by to see subtotals per category
✅ Key Takeaways
Copy Link to share individual records instantly
Sort & Group to make long lists readable
Filter Pane to zero in on the right data
Totals for quick insights without Excel
With these features, SharePoint lists become a powerful dashboard for everyday teamwork—no technical skills required! 💪
⚙️ Working with Advanced Column Types in SharePoint Lists
SharePoint lists become truly powerful when you move beyond simple text columns. By using advanced column types, you can tag items, assign ownership, and manage dates with precision—making your data easier to organize, search, and analyze.
Let’s explore three essential column types:
🏷 Multi-select Choice columns for tagging
👤 Person or Group columns for assigning responsibility
📅 Date columns for accurate time-based data
Video Explanation
🏷 1. Multi-Select Choice Column – Smart Tagging
Tags help categorize records so you can filter and group them later. A Choice column with multi-select lets users assign multiple labels to the same item.
How to create it:
Open your list → Add Column → Choice
Name the column (e.g., Tags)
Enter options such as:
Loyal
Price Driven
Buy Zone
Enable Allow multiple selections
(Optional) Turn on Allow values to be added manually
Click Save
What users see: When editing an item, they can pick multiple tags from a dropdown—perfect for flexible categorization.
💡 Great for: Customer segmentation, project labels, priority flags.
👤 2. Person or Group Column – Assign Ownership
Need to assign a record to someone in your organization? The Person/Group column connects directly to your company directory.
Steps to add:
Click Add Column → Person or Group
Name it (e.g., Associate)
Enable Show profile photos (optional)
Click Save
How it works:
Users can search by name or email
The field pulls real profiles from Microsoft 365
Ideal for task ownership and accountability
💡 Perfect for: Assigning cases, owners, reviewers, or contacts.
📅 3. Date Column – Convert Text to Real Dates
If dates are stored as plain text, you lose sorting, filtering, and validation. Converting to a Date and Time column unlocks powerful features.
Convert an existing column:
Click the column header
Select Column Settings → Edit
Change type to Date and Time
Optional:
Enable Include Time
Turn on Friendly Format
Click Save
Result: Your dates can now be sorted chronologically, filtered by range, and used in automation.
💡 Essential for: Birthdays, deadlines, renewals, and schedules.
✅ Why These Columns Make a Difference
Column Type
Business Benefit
Multi-Select Choice
Flexible tagging & filtering
Person/Group
Clear ownership & collaboration
Date
Accurate time-based operations
🎯 Final Thoughts
Using the right column types transforms a basic SharePoint list into a smart information hub. You’ll get:
Better organization
Faster filtering
Clear accountability
Reliable date handling
Start upgrading your lists today and watch your data come to life! 🚀
🧮 Working with Calculated Columns in SharePoint
Ever wished SharePoint could do the math for you? That’s exactly what calculated columns are for! Instead of manually entering values like age, totals, or status messages, SharePoint can generate them automatically using formulas.
For example, if your list has a Date of Birth column, you can create an Age column that updates itself—no manual updates needed. Let’s dive in!
Video Explanation
✅ What Are Calculated Columns?
A calculated column generates its value using data from other columns in the same list. It’s perfect for:
🎂 Calculating age from Date of Birth
🧾 Combining First Name + Last Name into Full Name
📊 Performing math on numeric fields
🚦 Displaying status messages like Completed / Pending
🛠 How to Create a Calculated Column
Step 1 – Add a New Column
Open your SharePoint list
Click Add Column
Choose See all column types → click Next
Step 2 – Select Calculated Type
Name your column (e.g., Age)
Choose Calculated (calculation based on other columns)
Step 3 – Enter the Formula
To calculate age from Date of Birth:
=DATEDIF([Date of Birth], TODAY(), "Y")
DATEDIF finds the difference between two dates
"Y" returns the result in years
Step 4 – Set Return Type
Choose Number
Set Decimal Places = 0 (age should be a whole number)
Step 5 – Save 🎉
Click OK—your Age column will now calculate automatically!
💡 Tips for Writing Formulas
Always use column names in square brackets → [Column Name]
Calculated columns work only with data inside the same list
You can use logic like IF statements, math, and text functions
📌 Useful Calculated Column Examples
1. Create Full Name
=[First Name] & " " & [Last Name]
➡ Combines two text fields with a space.
2. Status Based on Percentage
=IF([Completion] >= 100, "Completed", "In Progress")
Calculated columns turn a simple SharePoint list into a mini application. Whether you’re calculating age, totals, statuses, or messages—SharePoint does the heavy lifting while you focus on insights.
Start experimenting with formulas and make your lists work smarter, not harder! 💪
🔗 Creating and Using Lookup Columns in SharePoint Lists
Lookup columns are one of the most powerful features in SharePoint lists. They allow you to connect two lists together, so data can be reused instead of duplicated.
For example, instead of typing the same repair shop details for every customer, you can maintain a separate Repair Shops list and simply link customers to it. Any updates to the shop details will automatically reflect in the Customers list. Smart, right? 😎
Video Explanation
✅ Why Use Lookup Columns?
🔁 Reduce Data Duplication – Enter data once, reuse everywhere
🎯 Maintain Consistency – Updates in one list reflect in others
🧭 Better Navigation – Jump easily between related records
📊 Cleaner Reports – Structured relationships between lists
1️⃣ Create a Source List (Repair Shops)
Before creating a lookup column, we need a list that will act as the data source.
🛠 Steps
Go to your SharePoint site → New → List
Choose Blank List and name it Repair Shops
Add these columns:
Shop Name – Single line of text
Email – Single line of text
City – Single line of text
Rename the Title column → Shop ID (acts as unique identifier)
🎉 This list will now be used as the lookup source.
2️⃣ Create Lookup Column in Customers List
Now we’ll connect the Customers list to Repair Shops.
🛠 Steps
Open the Customers list
Click Add Column → See all column types → Next
Configure:
Name: Repair Shop
Type: Lookup
Get information from: Repair Shops
Display column: Shop Name
Under Add additional columns, select: ✔ Shop Name ✔ Email
Click OK
🎯 Result
Your Customers list will now show:
Repair Shop (dropdown)
Shop Name (auto-filled)
Email (auto-filled)
3️⃣ Test the Lookup Relationship
🧪 Steps
Edit a customer record
In Repair Shop, choose a shop from dropdown
Click Save
✅ The related Shop Name & Email appear automatically!
🔄 What Happens When Source Data Changes?
👉 If you update the email in Repair Shops, 👉 The change instantly reflects in Customers list!
Also:
Clicking the shop name in Customers opens the Repair Shop item page
Users can view or edit details (based on permissions)
🚀 Key Benefits Recap
🧩 Builds real relationships between lists
🔁 Single source of truth
⚡ Real-time updates across lists
🗂 Cleaner, more professional data structure
💡 Pro Tip
Use lookup columns for:
Assigning vendors to orders
Linking employees to departments
Connecting projects to clients
Any scenario where the same data repeats!
Lookup columns transform SharePoint from simple lists into a mini relational database—without any coding. Start connecting your lists and make your data smarter today! 🚀
💬 Adding Comments and Tracking Version History in SharePoint Lists
SharePoint lists aren’t just for storing data—they’re built for team collaboration and accountability. Two standout features make this possible:
🗨 Comments – discuss items directly inside the list
🕓 Version History – track every change and restore older versions
Let’s see how these tools help keep communication clear and your data safe.
Video Explanation
🗨 Comments in SharePoint Lists — Collaborate in Context
Comments let your team talk about a list item right where the data lives. No more hunting through emails or chats to find updates!
🌟 Why Comments Are So Useful
Keep discussions tied to the exact item
Tag teammates with @mentions
Build a timeline of decisions and notes
Perfect for customer lists, tasks, approvals, and projects
🧭 How to Add a Comment
Open your SharePoint list
Click the item you want to discuss
Select Edit to open the item form
On the right side, find the Comments section
Type your message
Use @Name to mention a colleague
Click Send
💡 Tip: When you @mention someone, they get a notification—great for quick follow-ups!
🕓 Version History — Never Lose Track of Changes
Version History records every update made to a list item:
Who changed it
When it was changed
What the previous values were
If something goes wrong, you can easily roll back to an earlier version.
🎯 Why Use Version History?
🛡 Protect against accidental edits
📋 Meet auditing/compliance needs
👀 See exactly who modified what
⏪ Restore previous information in seconds
🧭 How to View Version History
Go to your list
Click the three dots (…) next to an item
Select Version History
You’ll see:
Version number
Modified date/time
Modified by
🔁 What You Can Do from Here
For any version, you can:
View – open details of that version
Restore – bring it back as the current version
Delete – remove that version from history
✅ Restoring doesn’t erase newer versions—it simply creates a new “latest” version based on the old one.
⚙ Pro Tip: Enable Versioning
Make sure version history is turned on:
List Settings → Versioning Settings → Enable versioning
This ensures SharePoint keeps a full timeline of edits.
🚀 Key Takeaways
Comments keep conversations organized and visible
@mentions notify the right people instantly
Version History protects your data
You can always roll back mistakes
Together, these features turn SharePoint lists into a true collaboration workspace, not just a spreadsheet replacement 👍
🧩 Working with Columns and Conditional Fields in SharePoint Lists
SharePoint lists become truly powerful when you start customizing columns and adding smart conditional logic. Instead of overwhelming users with unnecessary fields, you can show only what’s relevant—keeping forms clean, accurate, and easy to use 👍.
In this section, we’ll cover:
➕ Adding new columns to an existing list
✏ Filling values for current items
🎯 Showing fields conditionally based on user selection
Let’s build this step by step!
Video Explanation
➕ Adding Additional Columns to a List
As your business grows, your lists often need to capture more information. Adding new columns lets you expand without breaking existing data.
🧪 Example Scenario
You have a Repair Shops list with:
Shop ID
Shop Name
Email
City
Now you want to track:
Shop Type – Independent or Affiliated
Affiliation Name – Only for affiliated shops
🧭 Steps to Add New Columns
Open your SharePoint list
Click + Add column
Choose Choice
Name it Shop Type
Add choices:
Independent
Affiliated
Enable: Require that this column contains information
Click Save
Now add the second column:
Click + Add column
Select Single line of text
Name it Affiliation
Click Save
✅ Your list now includes two new structured fields!
✏ Adding Values to Existing Items
After creating columns, update current rows so they follow the new structure.
🧭 How to Update an Item
Select a row → Click Edit
For an independent shop:
Shop Type → Independent
Affiliation → NA
For an affiliated shop:
Shop Type → Affiliated
Affiliation → Mega Repairs (or real partner name)
Click Save
⚠ Problem: Even when Independent is selected, users can still type an affiliation. Let’s fix that with conditional logic!
🎯 Applying Conditional Visibility to Columns
We can make the form smarter:
👉 Show Affiliation field ONLY when Shop Type = Affiliated
🧭 Steps to Add a Condition
Click Add new item
In the form, open: Edit Form → Edit Columns
Find Affiliation column
Click ⋯ → Edit conditional formula
Enter a formula like:
=if([$ShopType] == "Affiliated", true, false)
Save all changes
🧪 Test the Behavior
Shop Type Selected
Affiliation Field
Independent
❌ Hidden
Affiliated
✅ Visible
🎉 Now your form stays clean and error-free!
🚀 Why This Matters
✔ Users see only relevant fields
✔ Data stays consistent
✔ Fewer mistakes during entry
✔ Professional, guided experience
🧠 Quick Recap
Add new columns to expand your list
Update existing rows with structured values
Use conditional formulas to show/hide fields
Keep forms simple and intuitive
✅ Ensuring Proper Form Validation in SharePoint Lists
When users enter data into a SharePoint list, there’s always a risk of missing or incorrect information. Without validation, important fields can be skipped—leading to incomplete records and messy data 😬.
Thankfully, SharePoint provides built-in validation tools that let you:
Enforce rules across multiple fields
Prevent saving invalid entries
Show friendly error messages to guide users
Let’s walk through a real-world example: 👉 If a repair shop is marked as “Affiliated,” the Affiliation name must be required.
Video Explanation
⚠ What Happens Without Validation?
Imagine your list has:
Shop Type → Independent / Affiliated
Affiliation → Name of parent company
By default, SharePoint allows this:
❌ User selects Affiliated ❌ Leaves Affiliation blank ✔ The form still saves!
This creates confusing, incomplete data—exactly what we want to avoid.
🛠 Adding Row Validation in SharePoint
Row validation lets you define rules that must be satisfied before an item can be saved.
🧭 Steps to Add Validation
Open your SharePoint list
Click the ⚙ Settings icon
Select List settings
Click Validation settings
You’ll see two fields:
Formula – where the rule logic goes
User Message – what users see if validation fails
✏ Example Validation Formula
Rule:
If Shop Type = “Affiliated”, then Affiliation must not be blank
❗ “Affiliation is required when Shop Type is set to Affiliated.”
This helps users understand exactly what to fix 👍.
🧪 Test the Validation
Try these scenarios:
Shop Type
Affiliation
Result
Affiliated
Blank
❌ Error – cannot save
Affiliated
“Mega Repairs”
✅ Saves
Independent
Blank
✅ Saves
🎯 Perfect! The rule only applies when needed.
🎯 Key Benefits of Validation
✔ Prevents incomplete records
✔ Improves data quality
✔ Guides users with clear messages
✔ Reduces admin cleanup work
🧠 Quick Recap
Use Validation Settings to enforce rules
Write formulas that depend on other fields
Show helpful error messages
Keep your lists structured and reliable
📅 Calendar View in a SharePoint List
SharePoint lists don’t have to stay as rows and columns! With Calendar View, you can transform date-based data into a visual calendar layout—making it easier to track events, deadlines, and milestones at a glance.
Instead of scrolling through long tables, you’ll see items displayed on days, weeks, or months—just like a real calendar 🗓️.
💡 Important: Calendar View only works if your list has at least one Date-type column. Without a date field, SharePoint won’t know what to plot on the calendar.
Video Explanation
🔑 Why Use Calendar View?
Calendar View is perfect when your list contains time-based information. It helps you:
👀 Visualize data instead of reading raw rows
⏱ Track deadlines, events, and schedules
📈 Spot busy days or trends quickly
🧭 Navigate items by month/week/day
Great for scenarios like:
Customer sign-up dates
Project deadlines
Training schedules
Employee leave tracking
Event management
🛠 How to Create a Calendar View
Follow these simple steps to turn your list into a calendar:
Open your SharePoint list Go to the list that contains a date column (e.g., Sign-up Date, Due Date, Event Date).
Add a New View At the top right—just above the column headings—click ➕ Add View.
Name the View In the pop-up window, give it a name like: 👉 Calendar View
Select a Date Column Choose which date field should drive the calendar. Examples:
✔ Sign-up Date
✔ Deadline
✔ Event Date
❌ Date of Birth (not ideal for real tracking)
Choose a Layout Set the default display:
Month – best for overall planning
Week – detailed short-term view
Day – focused daily schedule
Click Create 🎉 Your list now appears in a calendar format!
🖼 Practical Example
Imagine you have a Customer Sign-up Date column:
You can instantly see how many customers joined in a month
Identify peak sign-up days
Spot quiet periods for marketing focus
Much more intuitive than reading dates in a table!
🎯 Best Use Cases
Scenario
Why Calendar View Helps
Project deadlines
See upcoming tasks visually
Event planning
Avoid date clashes
Support tickets
Track SLA dates
Employee leave
View overlaps easily
✅ Key Takeaways
Calendar View = visual, time-based perspective
Requires at least one Date column
Great for planning and trend spotting
Switch anytime between table and calendar views
🔔 Working with Alerts in Microsoft SharePoint
SharePoint alerts help you stay updated without constantly checking your lists. Once configured, SharePoint automatically notifies you whenever important changes occur—whether to a single item or the entire list. This is perfect for tracking updates like status changes, new entries, or edits made by team members.
Video Explanation
📌 Create an Alert for a Specific List Item
Sometimes you only need to monitor one critical record instead of the whole list. SharePoint lets you set alerts at the item level, so you get notified only when that particular item changes.
How to create an alert:
Open your SharePoint list and locate the item.
Click the three dots (…) next to the item.
Select Alert me from the menu.
You can then configure:
Alert Title – a meaningful name
Send Alerts To – one or more email recipients
Trigger Conditions – e.g., Anything changes or Someone else changes the item
Notification Timing – immediately, daily summary, or weekly summary
Click OK to activate the alert.
✉ What Happens After an Update
Whenever that item is modified, SharePoint sends an email containing:
What was changed
Who made the change
The date and time of the update
This keeps everyone informed without manual follow-ups.
🧰 Manage or Remove Alerts
As your project grows, you may want to review or clean up alerts.
To manage alerts:
Open the list
Click Manage my alerts from the top menu
From here you can:
✏ Edit existing alerts
🗑 Delete outdated ones
➕ Create alerts for the entire list
💡 Tip: List-level alerts are great when you need to track new items or bulk changes instead of one record.
🎯 Why Use Alerts?
Saves time by automating notifications
Reduces missed updates
Improves collaboration and accountability
Works for both items and whole lists
✅ Quick Recap
Alerts notify you automatically via email
Can be set on individual items or entire lists
Fully customizable with conditions and schedules
Easy to edit or delete anytime
📤 Working with SharePoint Lists: Exporting and Deleting Data
Managing SharePoint lists isn’t just about adding data—you’ll often need to export information for reports or clean up outdated records. SharePoint makes both tasks simple with built-in tools, no extra software required.
In this section, we’ll cover:
Exporting list data to Excel, CSV, or Power BI
Deleting individual items (with restore options)
Removing an entire list safely
Video Explanation
📥 Export a SharePoint List
Need to analyze your data in Excel or build dashboards in Power BI? Exporting lets you take your SharePoint list outside the platform in seconds.
🚀 Why Export?
Create reports and summaries
Share data with external teams
Perform advanced analysis in Excel
Build visual dashboards in Power BI
✅ Export Formats Available
Excel (.xlsx) – best for analysis and formulas
CSV – perfect for importing into other systems
Power BI – ideal for interactive reports
🧭 Steps to Export
Open your SharePoint list
Click the Export dropdown at the top
Choose your preferred format
The file downloads instantly to your device
💡 Tip: Export to Excel keeps column structure intact, making it easy to continue working with the data offline.
🗑 Delete a SharePoint List Item (With Restore Option)
Cleaning up old or incorrect records keeps your list accurate and relevant. The good news? Deleted items aren’t gone forever—they go to the Recycle Bin first.
🧹 How to Delete an Item
Select the item from the list
Click Delete from the top menu
Confirm the action
The item disappears from the list—but stays recoverable.
♻ How to Restore a Deleted Item
Open the Recycle Bin (left navigation)
Find your deleted item
Click Restore
The item returns exactly to its original location 🎉
🛡 Safety Net: SharePoint’s recycle bin protects you from accidental deletions.
⚠ Delete an Entire SharePoint List
If a list is no longer needed, you can remove it completely.
Steps to Delete a List
Open the list
Click the Settings gear icon
Select List Settings
Choose Delete this list
Confirm the action
❗ Important: Deleting a list removes all items inside it—double-check before proceeding.
In SharePoint, pages are the foundation of how content is presented and shared across a site. They allow you to display documents, announcements, dashboards, and project information in a structured and visually organized way. Whether you’re building an internal knowledge base, a team portal, or a company intranet, pages determine how users experience and interact with your content.
SharePoint offers several types of pages, each designed for different scenarios and levels of customization.
Types of SharePoint Pages
Site Pages (Modern Pages)
These are the default and recommended page type in today’s SharePoint. Site pages are built using web parts, making it easy to add text, images, document libraries, news, and more without technical skills.
Best features:
Mobile-friendly and responsive
Simple drag-and-drop editing
Consistent design across the site
Works seamlessly with modern SharePoint features
Site pages are ideal for team homepages, announcements, dashboards, and general communication.
Wiki Pages (Classic)
Wiki pages provide more free-form editing, similar to a word processor. Users can add formatted text, tables, links, and images directly on the page without structured web parts.
Good for:
Informal documentation
Knowledge bases
Quick notes and internal guides
Although still supported, wiki pages belong to the classic SharePoint experience and are gradually being replaced by modern site pages.
Web Part Pages (Legacy)
Web part pages come from older versions of SharePoint and allow detailed layout control using zones and classic web parts. However, they are now considered outdated.
Limitations:
Not mobile responsive
Limited compatibility with modern tools
More complex to maintain
These pages should only be used when required for legacy systems or older integrations.
When to Use Each Page Type
Choose Site Pages when you want a modern, responsive design with easy editing and full integration with current SharePoint features.
Choose Wiki Pages if you need flexible, text-heavy layouts or are working within an older environment.
Avoid Web Part Pages unless you must support legacy content or applications.
Understanding the different SharePoint page types helps you design sites that are easy to navigate, visually appealing, and aligned with modern collaboration needs. By selecting the right page type for the right purpose, you create a better experience for everyone who uses your SharePoint site.
📄 How to Create a Wiki Page in SharePoint — Step-by-Step Guide
Wiki pages may be part of SharePoint’s classic experience, but they’re still useful when you need free-form editing similar to a Word document. They’re great for quick documentation, internal notes, or simple knowledge-base pages where structure matters less than flexibility.
Let’s walk through how to create, edit, and publish a wiki page in a clear and easy way.
Video Explanation
🛠 Step-by-Step: Creating Your Wiki Page
➤ 1. Go to the Pages Library
Open your SharePoint site.
In the left navigation, click Pages — this is where all site pages are stored.
➤ 2. Create a New Page
Click the New button at the top.
You’ll see several options:
Site Page
Wiki Page
Web Part Page
Link
Select Wiki Page.
💡 Tip: Site Pages are the modern default, but Wiki Pages are perfect when you want a simple, document-style layout.
➤ 3. Name Your Page
Enter a meaningful title, such as:
“Expense Page”
“Team Guidelines”
“Project Notes”
A good name helps users find the page easily later.
➤ 4. Add Your Content
You’ll now see an editor that feels a lot like Microsoft Word:
✏️ Use the Format Text tab to style headings, bold text, bullets, and colors.
📎 Use the Insert tab to add:
Images
Links to files
Tables
App parts
This flexibility is what makes wiki pages great for informal documentation.
➤ 5. Save & Publish
When your content is ready, click Save and Publish.
Your page is now live and visible to site users.
📂 How to Find Your Page Later
To reopen or edit the page:
Go back to Pages in the site menu.
Click the page name (for example, Expense Page).
Choose Edit if you need to make updates.
Easy and always accessible 👍
💬 When Should You Use a Wiki Page?
Scenario
Good Fit?
Quick internal documentation
✅ Yes
Knowledge base articles
✅ Yes
Modern dashboards
❌ Better with Site Pages
Mobile-friendly layouts
❌ Use Site Pages
📌 Remember: Wiki pages are classic technology. For modern, responsive designs, Site Pages are recommended—but wiki pages remain handy for simple, text-focused content.
🎯 Summary
Wiki pages offer Word-like editing inside SharePoint
Great for informal guides, notes, and documentation
Easy to create with no technical skills
Still useful even in modern SharePoint sites
📁 Embedding a Document Library into a SharePoint Page
One of the smartest ways to make SharePoint easier for users is to bring the tools to the page instead of sending users around the site. By embedding a document library directly into a page, you can combine instructions, context, and file management in a single, friendly interface.
This approach is perfect for scenarios like expense submissions, project file uploads, or team collaboration spaces.
Video Explanation
🎯 Why Embed a Document Library?
Adding a library to a page gives you several advantages:
✅ Creates a guided experience for users
📤 Allows file upload directly from the page
🧭 Reduces navigation confusion
📘 Keeps instructions and documents together
👩💻 Ideal for non-technical team members
Think of it like building a mini workspace inside a page instead of just a blank information screen.
🛠 Step-by-Step: Add a Library to a Page
1️⃣ Open the Page
Go to your SharePoint site
Click Pages in the left navigation
Open the page you want to enhance (for example, Expense Page)
2️⃣ Switch to Edit Mode
Click the Edit ✏️ icon at the top-right
The page will open in a Word-like editor
3️⃣ Choose a Layout
Click Text Layout at the top
Select Two Columns with Header
This gives you:
A header for the title
Left column → instructions
Right column → document library
4️⃣ Add Helpful Instructions
In the header and left column, add guidance such as:
💬 “Upload your expense reports using the panel on the right.” 💬 “Use this file naming format: Department_Date.pdf”
Clear instructions = fewer mistakes 👍
5️⃣ Insert the Document Library (App Part)
Now for the magic part ✨
Click inside the right column
Open the Insert tab
Select App Part
Choose your library (e.g., Expenses)
Click Add
Your live document library now appears inside the page!
6️⃣ Save & Publish
Click Save and Publish
The page is now ready for your team
🚀 What Users Can Do Now
From this single page, users can:
📂 Upload new files
📝 Create documents
👀 View recent uploads
📖 Follow on-page instructions
👉 No more jumping between Pages, Site Contents, and Libraries!
💡 Best Use Cases
Scenario
Perfect Fit?
Expense submissions
✅ Yes
Project file collection
✅ Yes
HR document uploads
✅ Yes
Simple read-only info
❌ Use normal page
🧠 Final Thought
Embedding a document library turns a simple SharePoint page into a functional workspace. It combines guidance + action in one place — exactly what end users need to stay productive without confusion.
Give it a try on your next SharePoint page and watch how much smoother your team workflows become 🚀
🔧 Customizing an Embedded Document Library (App Part) in SharePoint Pages
Embedding a document library inside a SharePoint page is powerful—but the real magic happens when you customize how that library appears and behaves. You can group files, hide unnecessary columns, or even turn the library into a read-only viewer so users can’t upload or modify content.
Let’s walk through how to fine-tune your embedded library for a cleaner and more user-friendly experience.
Video Explanation
🎯 What You Can Achieve
With App Part customization, you can:
📂 Group files by metadata (e.g., Department)
👁️ Show only the columns that matter
🚫 Disable upload/edit buttons
🧼 Create a simple, clutter-free interface
✅ Step 1: Create a Custom View in the Library
The embedded library will display whatever view you choose, so start by creating one tailored for your page.
➤ Create the View
Open your Expenses document library
Click the view dropdown (e.g., All Documents)
Select Create new view
Name it something clear like: 👉 Expense Page View
➤ Customize the View
After creating it:
Open the view dropdown again
Click Edit current view
Now configure:
❌ Uncheck columns you don’t need
Modified
Modified By
📁 Under Group By, choose:
Department
Click OK to save.
👀 This is exactly how the library will look when embedded in the page.
✅ Step 2: Apply That View to the Page
Now connect the page to this new view.
➤ Open the Page
Go to Pages from site navigation
Open your page (e.g., Expense Page)
Click Edit ✏️
➤ Configure the App Part
Click once on the embedded document library
A Web Part tab appears at the top
Select Web Part Properties
In the right panel:
Under List View, choose 👉 Expense Page View
Optional tweaks:
🖼️ Appearance – change title
🧱 Layout – adjust sizing
⚙️ Advanced – fine-tune behavior
Click Apply.
✅ Step 3: Make It Read-Only (Optional)
Want users to only view files — not upload or edit?
➤ Turn Off the Toolbar
In Web Part Properties:
Find Toolbar Type
Select 👉 No Toolbar
✨ Result:
Upload button gone
New document option removed
Library becomes a clean viewer
🧠 Final Result
Your page now:
✔ Shows only relevant columns
✔ Groups files logically
✔ Prevents unwanted changes
✔ Looks professional and focused
🚀 Why This Matters
This setup is perfect for:
Expense review dashboards
HR document viewers
Project file showcases
Read-only reference areas
You get the best of both worlds: 👉 Guided page experience + live library functionality
🎉 Summary
By customizing the embedded App Part, you transform a basic page into a purpose-built workspace that’s clear, controlled, and easy for users to navigate.
Ready to level up your SharePoint pages? This technique is a game changer 💪
📄 How to Add Images and Links in a SharePoint Wiki Page
Adding images and links to a SharePoint wiki page transforms plain text into a visual, easy-to-navigate workspace. A banner image can make your page look professional, while links guide users directly to the right documents or libraries.
Let’s walk through how to do both—step by step 👇
Video Explanation
🖼️ Insert an Image into a Wiki Page
1. Open the Page
Go to Pages from the left navigation
Open your wiki page (for example, Expense Page)
Click Edit ✏️ at the top-right
2. Add the Image
Place your cursor where the image should appear
Open the Insert tab
Click Picture → From Computer
Browse and select your image
Choose destination library (usually Site Assets)
Click OK
3. Adjust the Image
Click the image to open the Picture tab
Resize, align, or adjust layout as needed
💡 Tip: Use a wide, lightweight image for a clean banner look.
🔗 Add a Link to a Document Library
1. Insert the Link
In Edit mode, place the cursor where the link should go
Go to Insert → Link → From Address
Enter:
Link Text: e.g., Click here to access the Expenses Library
Address: paste the library URL
Click Insert
2. Open in a New Tab (Recommended)
Click the inserted link
Open the Link tab
Enable Open in a new tab
🧭 Update Site Navigation
Add the Page to Navigation
Go to the homepage
Click Edit at the bottom of the left menu
Click the + icon
Choose Link
Paste the wiki page URL and name it (e.g., Expenses Page)
Click Save
Optional Cleanup
Remove any old direct link to the document library
Keep navigation focused on the new page
🎯 Result
Your wiki page now includes:
✔ A visual image banner
✔ Clickable link to the document library
✔ Clean and simple navigation
✔ Improved user experience
This structure helps users understand the page quickly and reach the right content with minimal effort 🚀
🔄 Viewing Page History and Embedding Content in SharePoint Pages
SharePoint pages evolve over time, and it’s important to track what changes have been made and by whom. SharePoint provides a built-in Page History feature for this purpose. In addition, you can enrich your pages by embedding external content such as YouTube videos, dashboards, or other web resources using embed code.
Video Explanation
📖 Viewing Page History
Page History allows you to review previous versions of a page and compare edits.
Steps to view history:
Open the SharePoint page you want to review (for example, Expense Page).
Click Edit at the top-right corner.
From the Page tab, select Page History.
A panel will appear listing all saved versions of the page.
What you can do:
Select any version to view how the page looked at that time.
Use the compare option to see differences between versions.
Changes are color-coded:
🟢 Green – content that was added
🔴 Red – content that was removed
This feature is extremely useful for auditing edits or restoring previous content if needed.
🎥 Embedding a YouTube Video or Other Content
You can make your SharePoint pages more engaging by embedding content from external sources.
How to embed a video:
Open the YouTube video (or another service that provides embed code).
Click Share → Embed and copy the HTML code.
Return to your SharePoint page in Edit mode.
Place the cursor where you want the video to appear.
Go to the Insert tab and choose Embed Code.
Paste the copied code and click Insert.
Click Save and Publish to make the changes live.
The video will now appear directly on your page and can be played without leaving SharePoint.
✅ Benefits
Using these features together helps you:
Track and review page edits over time
Recover earlier versions when needed
Add rich media to make pages more interactive
Create more engaging and informative SharePoint sites
With Page History and embedding, SharePoint pages become powerful communication tools rather than simple static documents.
📄 How to Create a Modern Site Page in SharePoint
Modern Site Pages are the heart of today’s SharePoint experience. They let you create clean, visually appealing pages using drag-and-drop web parts—no technical skills required. Compared to older Wiki pages, Site Pages feel more like building a modern website: responsive, flexible, and easy for everyone to use.
In this section, you’ll learn how to create a Site Page from scratch and customize it to fit your team’s needs.
Video Explanation
🧭 Step-by-Step: Create Your First Site Page
Follow these simple steps to get started:
Open the Pages library
From your SharePoint site, click Pages in the left navigation.
Create a new page
Click New → Site Page at the top.
Add a page title
Click on the title area and type a meaningful name, such as “Cars Page” or “Team Resources.”
Customize the banner
Click the banner area to open its settings.
You can:
Change the banner image
Align the title (Left / Center / Right)
Add text above the title (e.g., “Welcome to our resources”)
Show or hide the published date
Add content sections
Click the ➕ plus icon below the banner to insert web parts like:
📝 Text
🖼️ Image
📁 Document Library
🎬 Video
🔗 Links and more
Publish the page
When ready, click Publish in the top-right corner.
🚀 After You Publish
SharePoint gives you helpful options right away:
➕ Add the page to site navigation so users can find it easily
📰 Post as News to announce it to your organization
🔗 Copy link to share in Teams or email
📧 Share via email with a single click
✨ Why Use Modern Site Pages?
Modern Site Pages are perfect for:
Creating internal dashboards
Building knowledge base pages
Displaying announcements and updates
Embedding document libraries and videos
Designing role-based landing pages
They combine professional design + easy editing + powerful integration with the rest of Microsoft 365.
🖌️ How to Enhance a SharePoint Site Page with Layout Edits & an Embedded Picture Library
Modern SharePoint Site Pages are designed to look clean, visual, and professional without any technical skills. With just a few clicks, you can transform a simple page into an engaging space that combines banners, structured layouts, and live image galleries.
In this section, you’ll learn how to upgrade an existing Site Page by customizing the banner, adjusting the layout, and embedding a picture library so users can view images directly from the page.
Video Explanation
✏️ Step 1 – Open the Page in Edit Mode
Go to the SharePoint page you created earlier
Click Edit in the top-right corner
The page switches to design mode where all elements become customizable
💡 Tip: Use the full-screen ↗ icon to hide navigation and focus only on the page while editing.
🖼️ Step 2 – Customize the Banner
The banner sets the mood of your page — make it informative and attractive.
Click anywhere on the banner area
Select Change Image to:
Pick a stock image
Upload your own photo
Use Set Focal Point to control which part of the image stays in focus
You can also:
Add small text above the title
Show or hide the publish date
Align the title left, center, or right
🎨 A well-designed banner gives instant context to your page visitors.
🧩 Step 3 – Add a Structured Section
To organize content neatly:
Scroll below the banner
Click the ➕ Add section icon
Choose a layout such as Two Columns
For better balance:
Open Section Properties
Change layout to One-third Right
Left side → wider for main content
Right side → perfect for images or libraries
📸 Step 4 – Embed the Picture Library
Now let’s bring images directly onto the page:
Inside the column, click ➕ Add web part
Select Document Library
Choose your Cars picture library
✨ Instantly, thumbnails from the library appear on the page — no manual uploads required!
This is ideal for:
Product galleries
Event photo collections
Team showcases
Visual knowledge bases
🚀 Step 5 – Publish the Page
When everything looks good:
Click Republish at the top right
The enhanced page becomes live for everyone 🎉
✅ What You Get
After these updates, your page now includes:
✔ A branded banner with focal control
✔ Clean multi-column layout
✔ Live picture gallery embedded
✔ Modern, professional design
This approach turns SharePoint pages into interactive visual hubs instead of plain text screens, making content easier and more enjoyable to explore.
🧑🤝🧑 How to Add People to a SharePoint Site Page
Adding people profiles to a SharePoint page is a great way to make your site feel more human and connected. Whether you’re building a team directory, highlighting project owners, or showing key contacts, the People web part lets you display names, photos, roles, and contact details in a professional layout.
In this section, you’ll learn how to insert and customize a People section so visitors can easily recognize and reach the right person.
Video Explanation
✅ Step-by-Step: Add the People Web Part
1️⃣ Open the Page in Edit Mode
Go to the SharePoint page you want to update
Click Edit in the top-right corner to start customizing
2️⃣ Choose Where to Place It
Hover over the column or section where you want the people list
Click the ➕ Add web part icon
3️⃣ Insert the People Web Part
In the toolbox, search for People
Click it to add the web part to your page
4️⃣ Add Team Members
Start typing a person’s name or email
Select them from the suggestions
Repeat to add multiple people
💡 SharePoint automatically pulls profile photos and contact info from Microsoft 365.
🎨 Customize the Look
Click on the People web part and open Properties ⚙️ to adjust:
Layout options:
🟦 Small – compact cards with name + photo
🟩 Medium – adds space for a short description
🟪 Large – more detailed, perfect for directories
Optional descriptions:
Add roles like Project Manager or HR Lead
Include department names or responsibilities
Provide quick contact notes
🚀 Publish the Changes
When everything looks good, click Republish
The updated page goes live instantly
👀 What Visitors Will See
Your page will now show:
✔ Profile photos or initials
✔ Names and job details
✔ Clickable cards that open email & contact info
This is perfect for:
Team introductions
Project contact lists
Department directories
Stakeholder pages
🌟 Why Use the People Web Part?
Makes pages more personal
Helps users find the right contact fast
No manual data entry — synced with Microsoft 365
Clean, professional presentation
🕒 How to Add a Countdown Timer to a SharePoint Site Page
A countdown timer is a simple but powerful way to grab attention on your SharePoint site. Whether you’re counting down to a product launch, company event, project deadline, or registration closing date, this web part creates urgency and keeps everyone focused on what matters next.
The best part? SharePoint includes a built-in Countdown Timer web part—no coding or third-party tools needed 👍.
In this section, you’ll learn how to add, customize, and publish a live countdown timer on any modern SharePoint page.
Video Explanation
🔧 Step-by-Step: Add the Countdown Timer
1️⃣ Open the Page in Edit Mode
Go to the SharePoint page where you want the timer
Click Edit in the top-right corner
2️⃣ Add a New Section
Hover between sections until you see the ➕ icon
Click it and choose a layout
👉 One Column works best for a full-width timer
3️⃣ Insert the Countdown Web Part
Inside the section, click the inner ➕ Add web part
Search for Countdown Timer
Select it to place it on the page
⚙️ Customize Your Timer
Click on the timer and open Properties ⚙️ on the right to configure:
🎯 Set the Basics
Add a title like:
“Event Starts In”
“Sale Ends In”
“Project Go-Live”
Choose the target date and time
⏱ Choose What to Display
Select which units to show:
Days
Hours
Minutes
Seconds
You can keep it simple (days + hours) or ultra-precise with seconds ticking away!
🔗 Add a Call to Action (Optional)
Want users to take action before time runs out?
Turn on Add a call to action
Set button text like:
“Register Now”
“Learn More”
“Submit Report”
Add a link to the relevant page or form
🖼 Make It Visually Engaging
Give your timer more impact with a background:
Upload your own image or choose a stock photo
Adjust overlay color (light/dark)
Use opacity slider for better readability
This helps the timer stand out instead of looking like plain text.
🚀 Publish the Page
When everything looks good, click Republish
The countdown goes live instantly and updates in real time
🎉 What You Get
Your SharePoint page will now feature:
✔ A live, ticking countdown
✔ Optional action button
✔ Branded background image
✔ A professional, event-focused look
💡 Great Use Cases
Company events & town halls
Training registration deadlines
Project go-live dates
Offer expirations
Sprint or milestone tracking
🧭 How to Add Navigation Elements to a SharePoint Page
Adding navigation elements like Call to Action (CTA) blocks and buttons makes your SharePoint pages easier to use and more interactive. Instead of forcing users to hunt through menus, you can guide them directly to key areas such as the Home page, Expense page, or any important resource.
These elements act like signposts on your site—helping visitors move smoothly from one section to another.
Video Explanation
🚀 Why Add Navigation Elements?
Using CTAs and buttons on your pages helps to:
✔ Guide users to important content quickly
✔ Reduce confusion for new visitors
✔ Highlight frequently used pages
✔ Improve overall user experience
🔧 Step-by-Step: Add Navigation Elements
1️⃣ Open the Page in Edit Mode
Navigate to the page you want to update
Click Edit in the top-right corner
2️⃣ Add a New Section
Hover below the banner until the ➕ icon appears
Select One Column Section to create space for your navigation
3️⃣ Insert a Call to Action (CTA)
Click the inner ➕ Add web part
Choose Call to Action
Then configure it in the properties panel:
Add a message such as: “Want to check the Expense page?”
Set button text like “Click Here”
Paste the link to the target page
Pick a background color to make it stand out
4️⃣ Add a Navigation Button
Hover above or below the CTA
Click ➕ Add web part → Button
Enter:
Label: Home
Link: your homepage URL
5️⃣ Publish and Test
Click Republish
Test each link to confirm correct navigation
💡 Tips for Better Navigation
Use clear action words like View Expenses or Go to Dashboard
Keep button labels short and simple
Avoid adding too many CTAs on one page
Match colors with your site theme for consistency
🎯 What You Achieve
With these additions your page will:
Feel more interactive and professional
Help users reach content faster
Reduce unnecessary clicks
Provide a smoother browsing experience
A few well-placed navigation elements can transform a basic SharePoint page into a user-friendly hub 👍.
🏠 How to Create and Customize a SharePoint Home Page
Your SharePoint Home Page is the front door to your site. It’s where users land first, so it should be informative, organized, and easy to navigate. With modern SharePoint, you can build a custom homepage using web parts like News, Calendar, Quick Links, and Activity — all without any coding.
In this section, you’ll learn how to design a professional homepage from scratch and set it as the default landing page for your site.
Video Explanation
✨ What Makes a Good SharePoint Home Page?
A well-designed homepage should:
✔ Highlight important updates and announcements
✔ Provide quick access to key pages and libraries
✔ Show recent activity to keep users engaged
✔ Be visually clean and easy to scan
Let’s build one step by step 👇
🛠 Step-by-Step: Build Your Custom Home Page
1️⃣ Create a New Site Page
Open Pages from the left navigation
Click New → Site Page
The modern page editor will open
2️⃣ Customize the Banner
Click on the top banner area
Open the Properties panel
Choose a layout such as Color Block, Image, or Title Only
Add a meaningful page title like “Welcome to Our Team Site”
🧩 Add Useful Web Parts
3️⃣ Add News & Calendar Section
Click the ➕ Add section button
Choose Two Column layout
In the left column:
Add the News web part to display announcements
In the right column:
Add the Group Calendar web part to show upcoming events
👉 This gives users a quick snapshot of what’s happening.
4️⃣ Add Quick Navigation Cards
Add another section with One Column layout and insert:
Call to Action web parts linking to:
Expense Page
Cars Picture Library
Any important department pages
For each CTA you can configure:
Title
Description
Button text
Link URL
Background image 🎨
These act like visual shortcuts across your site.
5️⃣ Add Site Activity Feed
At the bottom of the page:
Add a One Column section
Insert the Site Activity web part
This shows:
Recent file uploads
Page edits
User interactions
Great for keeping the homepage “alive” 🔄
🚀 Publish & Set as Home Page
When you’re happy with the design:
Click Publish
Go back to the Pages library
Find your new page
Click the three dots (…) → select Make homepage
✅ Now this page becomes the default landing page when users click the Home icon.
🎯 Final Result
Your custom homepage now includes:
📰 News updates
📅 Calendar events
🔗 Quick links to key pages
📊 Activity feed
🎨 Personalized banner and layout
This transforms SharePoint from just a file storage space into a real digital workplace hub.
🧰 Useful Menu Items on SharePoint Site Pages
SharePoint Site Pages include several built-in tools that help you understand page performance, promote content, and manage page details—all from the top menu. These features make it easy to turn a simple page into a well-managed, high-impact resource.
Let’s explore the three most useful options 👇
Video Explanation
📊 1. Page Analytics — Understand Your Audience
The Analytics option gives you valuable insights into how users interact with your page.
When you click Analytics, you can see:
👀 Page Views – how many times the page was opened
🧑 Unique Viewers – number of individual visitors
⏱ Average Time Spent – how long users stay on the page
📈 Traffic Trends – busy hours and popular days
💡 Great for: Checking whether important pages are actually being used and identifying the best time to post updates.
📣 2. Promote — Share Your Page with the Team
The Promote button helps you surface your page in different places without extra effort.
From the promote panel you can:
➕ Add to Navigation – make the page easy to find
📰 Post as News – feature it on the homepage news feed
🔗 Share Page – send directly to colleagues
📧 Copy Link / Email – quick distribution
🧩 Save as Template – reuse the design later
💡 Great for: Turning a normal page into a highlighted announcement or reusable template.
🗂 3. Page Details — Manage Metadata
The Page Details option opens a side panel with important information about the page.
Here you can:
✏ Edit title and description
🏷 Update custom metadata fields
🔍 Review page properties
📁 Keep content organized for search and filtering
💡 Great for: Keeping pages structured and searchable across your SharePoint site.
🎯 Why These Tools Matter
Using these menu features helps you:
Track engagement and improve content
Promote key information to the right audience
Keep pages organized and professional
Reuse good designs across the site
With just a few clicks, you can manage your SharePoint pages like a pro 👍.
In this hands-on tutorial, we will build a complete Azure SQL Server + SQL Database using Terraform, then securely connect to it from our local machine and run real SQL commands — without installing SSMS or Azure Data Studio.