Skip to content

Workplace Automation

  • Home
  • Blog
    • All Posts
    • Site Management & Governance
    • Files & Document Management
    • Lists & Data Automation
    • Auth, Security & Setup
    • PowerShell Scripting Basics
    • M365 & Power Automate
  • About
  • Contact
  • LinkedIn
Workplace Automation / Home
/
  • Latest Guides 4
  • Top Playbooks 8
  • Focus Areas 4
  • Script Index 39
  • About Serkar

Streamline your Workplace Operations

Practical PowerShell scripts, Microsoft Graph API tutorials, and actionable automation strategies for IT professionals and architects driving transformation across Microsoft 365, Power Platform, and Agentic AI.

Lists & Data (10) Site Governance (8) Files & Libraries (8) Security & Auth (7) PowerShell Basics (5)
Serkar Aydin

Serkar Aydin

Engineering Manager · Architect

10+ years of IT consulting & engineering experience automating enterprise workplace operations across Microsoft 365, Azure, Power Platform, and AI Foundry.

View Profile & Tech Stack

Latest Guides

Microsoft Graph & PowerShell
Browse all 39 articles
Featured Guide Create SharePoint List Items with MS Graph API

How to Create SharePoint List Items with MS Graph API: A Step-by-Step Guide

Authenticate against Microsoft Graph and programmatically insert single and batch items into SharePoint lists.

Lists & Data Nov 26, 2024 →
MS Graph API How to create SharePoint Lists with MS Graph

How to create SharePoint Lists with MS Graph

Provision custom SharePoint libraries and structured lists automatically using Microsoft Graph REST endpoints.

Lists & Data Nov 16, 2024 →
Site Provisioning How to create SharePoint Sites using Graph

How to create SharePoint Sites using Graph

Automate modern SharePoint site creation and ownership governance directly via Graph API permissions.

Site Management Nov 2, 2024 →
PowerShell A Complete Guide For SharePoint Site Creation with PowerShell

A Complete Guide For SharePoint Site Creation with PowerShell

Streamline tenant administration by scripting end-to-end site collection provisioning and template application.

Site Management Oct 6, 2024 →

Most Popular Scripts & Playbooks

Direct Solutions
Open Blog View
Download SharePoint Library
↗

Download a SharePoint Library Using Graph API

#2967 // Files & Libraries
Upload files to SharePoint using Graph API
↗

Upload Files to SharePoint Using Graph API

#2903 // Files & Libraries
Configure Azure App Registration
↗

Configure Azure App Registration for MS Graph

#2602 // Security & Auth
Assign Sensitivity Labels
↗

Assign Sensitivity Labels in SharePoint (MSGraph)

#3252 // Security & Auth
SharePoint Site Usage
↗

Get Active SharePoint Sites for Last 6 Months

#2512 // Site Governance
LINQ in PowerShell
↗

How to Use LINQ in PowerShell to Compare Arrays

#262 // PowerShell Core
SharePoint Downloader
↗

SharePoint Downloader: File Download in 2 Steps

#2284 // Files & Libraries
Add Webparts to SharePoint Pages
↗

Easily Add Webparts to SharePoint Pages

#1783 // Site Governance

Core Focus Areas

Ecosystem Pillars
Explore Full Tech Stack
SharePoint PowerShell Scripting
37 Tutorials Live

SharePoint PowerShell Scripting

Enter the terminal and take absolute control. Access deep-dive PowerShell tutorials and advanced scripting techniques to manage IT infrastructure and maintain M365 at scale.

Browse PowerShell Scripts
Microsoft 365 & Power Automate
Cloud Workflows

Microsoft 365 & Power Automate

Unlock the hidden potential of your Microsoft ecosystem. Seamlessly connect apps, automate repetitive tasks, and construct powerful cloud-native workflows across M365.

Explore M365 & Automate
Robotic Process Automation (RPA)
Process Automation

Robotic Process Automation (RPA)

Break free from software silos. Master platforms like Power Automate Desktop and RPA to connect web services and handle complex data pipelines autonomously.

Read Process Automation Guide
(Agentic) AI
Copilot & Foundry

(Agentic) AI Solutions

Augment your workforce with artificial intelligence. Discover how we integrate Microsoft Copilot Studio, Microsoft Foundry, and ElevenLabs into enterprise operations.

View AI Stack & Architecture

Complete Scripts & Articles Index

39 of 39 Articles
Standard Blog Archive →
How to Create SharePoint List Items with MS Graph API: A Step-by-Step Guide Lists & Data Automation
Nov 26, 2024 · Article #3386

How to Create SharePoint List Items with MS Graph API: A Step-by-Step Guide

In this article I'll elaborate how to create SharePoint List Items with MS Graph API. You might have use cases, which require the automat…

Read Full Guide
How to create SharePoint Lists with MS Graph Lists & Data Automation
Nov 16, 2024 · Article #3396

How to create SharePoint Lists with MS Graph

In this post I want to showcase how to create a SharePoint Library and SharePoint List using MS Graph. You might need to create a SharePo…

Read Full Guide
How to create SharePoint Sites using Graph Site Management & Governance
Nov 2, 2024 · Article #3393

How to create SharePoint Sites using Graph

In the previous article I was showcasing how to create a SharePoint Site with PNP.PowerShell. In this article I want to elaborate how to …

Read Full Guide
A Complete Guide For SharePoint Site Creation with PowerShell Site Management & Governance
Oct 6, 2024 · Article #3337

A Complete Guide For SharePoint Site Creation with PowerShell

In this article I want to show you how you can streamline the SharePoint Site creation with PowerShell. You can save time by doing it wit…

Read Full Guide
Assign Sensitivity Labels In SharePoint with MSGraph (PowerShell) Auth, Security & Tenant Setup
Oct 9, 2023 · Article #3252

Assign Sensitivity Labels In SharePoint with MSGraph (PowerShell)

Sensitivity labels in Microsoft 365 allow organizations to classify documents into categories like public, confidential, or highly confid…

Read Full Guide
How to Get SharePoint Files with MSGraph with PowerShell Files & Document Management
Sep 17, 2023 · Article #3266

How to Get SharePoint Files with MSGraph with PowerShell

Learn how to efficiently retrieve SharePoint files using the MSGraph module in PowerShell. This comprehensive guide outlines the prerequi…

Read Full Guide
How To Download a SharePoint Library Using Graph API (PowerShell) Files & Document Management
Mar 25, 2023 · Article #2967

How To Download a SharePoint Library Using Graph API (PowerShell)

SharePoint is a powerful platform for managing and collaborating on documents, but downloading files from SharePoint libraries can be a t…

Read Full Guide
How to download files from SharePoint using Graph API (PowerShell) Files & Document Management
Feb 11, 2023 · Article #2943

How to download files from SharePoint using Graph API (PowerShell)

Downloading files from SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous article…

Read Full Guide
How to upload files to SharePoint using Graph API (PowerShell) Files & Document Management
Jan 4, 2023 · Article #2903

How to upload files to SharePoint using Graph API (PowerShell)

Uploading files to SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous articles, I…

Read Full Guide
Create SharePoint list items using Graph API (PNP.PowerShell) Lists & Data Automation
Dec 29, 2022 · Article #2879

Create SharePoint list items using Graph API (PNP.PowerShell)

SharePoint List items do represent a row of structured data in our SharePoint. Besides creating them manually, you have the opportunity t…

Read Full Guide
How to get SharePoint List Items with Graph API (PowerShell) Lists & Data Automation
Dec 18, 2022 · Article #2586

How to get SharePoint List Items with Graph API (PowerShell)

In this article I am explaining how you can get SharePoint List items with Graph API. I took PowerShell to get the items, but you could a…

Read Full Guide
How to configure Azure App registration for MS Graph Auth, Security & Tenant Setup, M365 & Power Automate
Aug 14, 2022 · Article #2602

How to configure Azure App registration for MS Graph

✔️ App registrations for MS Graph: Unleash powerful capabilities through granted requests. ✔️ What is an app registration? Learn its purp…

Read Full Guide
How to get all lists and libraries in SharePoint Online Lists & Data Automation
Jan 11, 2022 · Article #2556

How to get all lists and libraries in SharePoint Online

Learn how to get all lists and libraries with two PowerShell scripts to understand what is going on in your SharePoint tenant.

Read Full Guide
Upload documents to SharePoint (PNP.PowerShell) Files & Document Management
Oct 28, 2021 · Article #2510

Upload documents to SharePoint (PNP.PowerShell)

Learn how to upload documents to SharePoint with PowerShell. Integrating different systems to SharePoint can be achieved easily with this.

Read Full Guide
SharePoint Site Usage: Get active Sites for last 6 months with PowerShell Site Management & Governance
Oct 19, 2021 · Article #2512

SharePoint Site Usage: Get active Sites for last 6 months with PowerShell

When migrating our SharePoint to SharePoint Online, it can be really hard to separate the wheat from the chaff. SharePoint Site usage hel…

Read Full Guide
SharePoint get all sites and subsites PowerShell script Site Management & Governance
Oct 11, 2021 · Article #2477

SharePoint get all sites and subsites PowerShell script

SharePoint sites are created very fast. With a few clicks, admins and users can create dozens of sites and subsites. Since it is so easy …

Read Full Guide
SharePoint PowerShell add site collection administrator Site Management & Governance
Oct 6, 2021 · Article #2464

SharePoint PowerShell add site collection administrator

When you administer the SharePoint, you might need access to all sites. I have provided a collection of PowerShell scripts, so you can ac…

Read Full Guide
Business Process Automation: How to make customers happy M365 & Power Automate
Sep 24, 2021 · Article #2436

Business Process Automation: How to make customers happy

Business process automation can help you to design a more efficient organization. With business process automation, you can guide your us…

Read Full Guide
Run PowerShell script | a clear tutorial made for beginners PowerShell Scripting Basics
Sep 10, 2021 · Article #2392

Run PowerShell script | a clear tutorial made for beginners

Every journey starts with the first step. PowerShell is the langauge, when it comes to task and configuration automation. In this article…

Read Full Guide
SharePoint Downloader | Comfortable file download in 2 steps Files & Document Management
Sep 9, 2021 · Article #2284

SharePoint Downloader | Comfortable file download in 2 steps

In this article, you'll learn how to download SharePoint files in the GUI and with PowerShell. I also provide my tool, the "SharePoint Do…

Read Full Guide
How to restore SharePoint files with PowerShell Files & Document Management
Sep 6, 2021 · Article #2280

How to restore SharePoint files with PowerShell

It is easy to delete SharePoint files by mistake. In this article, I will how you can restore SharePoint files in the GUI and also with P…

Read Full Guide
3 of the most important SharePoint PowerShell Modules and Snappins PowerShell Scripting Basics
Aug 26, 2021 · Article #1903

3 of the most important SharePoint PowerShell Modules and Snappins

There are various ways to access SharePoint Online and SharePoint Server. Check out and learn what the main differences are. When to use …

Read Full Guide
Multi value arrays in PowerShell: How to create them really easy PowerShell Scripting Basics
Aug 24, 2021 · Article #2026

Multi value arrays in PowerShell: How to create them really easy

Multidimensional arrays are used to describe multi value objects in Powershell. ✔️ Learn how to create multidimensional arrays.

Read Full Guide
How to filter for PowerShell objects easily PowerShell Scripting Basics
Aug 22, 2021 · Article #2211

How to filter for PowerShell objects easily

If you are working interactively with PowerShell, It might be unhandy to define all the filtering options with Where-Object. I will show …

Read Full Guide
Change SharePoint site collection logo faster with PowerShell Site Management & Governance
Aug 19, 2021 · Article #2007

Change SharePoint site collection logo faster with PowerShell

The corporate design covers besides colors and fonts a logo, which is located in the upper left corner of the SharePoint site collection….

Read Full Guide
How to connect to SharePoint Online with SharePointOnlinePowerShell Auth, Security & Tenant Setup
Aug 17, 2021 · Article #1991

How to connect to SharePoint Online with SharePointOnlinePowerShell

Besides the possibility to manage your SharePoint Online in the SharePoint admin center, you have the option to do it with PowerShell. Fo…

Read Full Guide
How I easily add Webparts to SharePoint Pages by PowerShell Site Management & Governance
Aug 1, 2021 · Article #1783

How I easily add Webparts to SharePoint Pages by PowerShell

A page consists of multiple webparts. With the webparts you can refer to other lists, libraries and apps within a page. You can add webpa…

Read Full Guide
Access SharePoint via Graph API in PowerShell Auth, Security & Tenant Setup
Aug 1, 2021 · Article #1692

Access SharePoint via Graph API in PowerShell

Learn how to access SharePoint with Graph API with ready to use PowerShell Scripts

Read Full Guide
Add-PNPField: Add SharePoint columns with PowerShell Lists & Data Automation
Jul 25, 2021 · Article #1728

Add-PNPField: Add SharePoint columns with PowerShell

Cheatsheet: Learn how to add SharePoint Columns with PNP PowerShell to automate the creation of your Microsoft lists and libraries. Ensur…

Read Full Guide
Add Items to SharePoint Online lists with PowerShell Lists & Data Automation
Jul 22, 2021 · Article #1333

Add Items to SharePoint Online lists with PowerShell

When you want to integrate 3rd party systems to SharePoint, you might need to add items to SharePoint Online lists with PowerShell. In th…

Read Full Guide
How to use Word and Excel templates in SharePoint Files & Document Management
Jul 17, 2021 · Article #1282

How to use Word and Excel templates in SharePoint

Enhance the efficency of your intranet by using word and excel templates for your documents.

Read Full Guide
Use credentials in PowerShell Auth, Security & Tenant Setup
Jul 13, 2021 · Article #1405

Use credentials in PowerShell

Learn how to use credentials in PowerShell scripts and what to consider, when using Credentials in PowerShell.

Read Full Guide
How to use LINQ in PowerShell to compare arrays PowerShell Scripting Basics
Jul 8, 2021 · Article #262

How to use LINQ in PowerShell to compare arrays

Use LINQ in PowerShell to boost your filtering and comparing operations in PowerShell. Ready-to-Use Scripts provided.

Read Full Guide
Remove SharePoint Sites fastly Site Management & Governance
Jul 7, 2021 · Article #1271

Remove SharePoint Sites fastly

Howdy guys, sometimes we create ton of sites just for testing. A clean tenant is a must for an efficient management. Have you ever remove…

Read Full Guide
Term label propagation in SharePoint Online Auth, Security & Tenant Setup
Jul 4, 2021 · Article #277

Term label propagation in SharePoint Online

Rome was not build on a day so isn‘t our taxonomy. Business requirements change frequently, so we have to adapt our systems to support th…

Read Full Guide
Dealing with existing SharePoint connections Auth, Security & Tenant Setup
Jun 25, 2021 · Article #159

Dealing with existing SharePoint connections

We all can Imagine the scenario. You create sites in sharepoint and now you want to edit multiple sites afterwards with PowerShell. In or…

Read Full Guide
Filtering for SharePoint items with CAML Queries Lists & Data Automation
Jun 20, 2021 · Article #181

Filtering for SharePoint items with CAML Queries

Most of our times, we just need just a bunch of items, to export them or to change their values. This post should help you to show, how t…

Read Full Guide
Determine internal name of SharePoint Columns with GUI Lists & Data Automation
Jun 20, 2021 · Article #219

Determine internal name of SharePoint Columns with GUI

You have to determine the internal name of SharePoint columns, when you want to get the values of the items programatically or develop so…

Read Full Guide
Getting Fieldvalues of Items Lists & Data Automation
Jun 16, 2021 · Article #141

Getting Fieldvalues of Items

Getting all values of all items If you want to retrieve all fieldvalues of an item, you can use following steps. I am getting the opportu…

Read Full Guide
  • Imprint
  • Privacy Policy
  • About
  • Linkedin