Skip to content

Rui Qiu's Blog

  • SCCM
  • Casper
  • Powershell
  • Mac
  • Shell Script
  • Tools
  • Synology
  • Shopping

How to Automate SharePoint Site Requests — Part 4: The Form and Lessons Learned

July 14, 2026 by me

Build a Power Apps intake form with live validation for SharePoint provisioning. Plus 7 hard-won lessons including the newline bug & permission tricks.

Categories Microsoft365 Tags canvas app, Citizen Developer, Form Validation, Lessons Learned, Low-Code, Microsoft 365, Patch Function, Power Apps, Power Platform, PowerFx, Self-Service Form, SharePoint

How to Automate SharePoint Site Requests — Part 3: The Creation Engine

July 14, 2026 by me

Create SharePoint sites with an Azure Automation runbook using PnP.PowerShell & certificate auth. Includes a bank-grade permission model tutorial.

Categories Microsoft365 Tags App-Only Authentication, Azure Automation, Certificate Authentication, Cloud Automation, Microsoft 365, New-PnPSite, PnP PowerShell, powershell, runbook, SharePoint, SharePoint Permissions, Webhook

Power Automate Approval Workflows for SharePoint Provisioning (Part 2)

July 14, 2026 by me

Build multi-stage Power Automate approval flows for SharePoint provisioning. Includes manager + admin approvals and the SharePoint newline bug fix.

Categories Microsoft365 Tags Approval Workflow, automation, Flow, Microsoft Graph, Power Automate, Power Platform, SharePoint

How to Automate SharePoint Site Provisioning with Power Platform (Part 1: Setup)

July 14, 2026 by me

Learn to build a self-service SharePoint site provisioning platform with Power Platform & Azure. Part 1 covers setup, app registration & list config.

Categories Microsoft365 Tags automation, Azure Automation, governance, Microsoft 365, PnP PowerShell, Power Automate, Power Platform, SharePoint

Building a Self-Service SharePoint Permission Checker

July 14, 2026 by me

Build a self-service Power Apps tool that checks SharePoint & OneDrive permissions in under a minute — async runbooks, app-only auth, and a full audit trail.

Categories Microsoft365
conditional access policy for unmanaged devices

Unmanaged devices in Entra Conditional Access Policy

May 4, 2026 by me

In a recent task, I was asked to target unmanaged devices in the environment, which means excluding Intune-enrolled mobile devices, on-prem AD-joined servers (not Entra-joined), … Read more

Categories Entra

Automated Intune Devices Report via Azure Automation with Managed Identity

May 12, 2023April 26, 2023 by me

Before I was using Niel’s guide to set up the monthly Intune devices report via Azure Automation. Since Microsoft is retiring “run as ” account … Read more

Categories SCCM

Use Microsoft Graph API to upload files to Sharepoint

February 27, 2023 by me

I am trying to get autopilot 4k hardware hash info from each machine and manually upload to Intune, thus I use some online scripts and … Read more

Categories Powershell Tags automation, azure

Some Simple Shell Scripts to Install Mac Apps for Intune

February 2, 2023 by me

Here are some typical shell script codes for mac application installation

Categories Mac, Shell Script

Shell Script to Install Cisco Anyconnect VPN via Intune

February 2, 2023 by me

There is an excellent article talks about how to deploy the Cisco Anyconnect VPN client via Intune: https://maclovin.org/blog-native/2021/cge1p5lkn8xdyxz8bgcumg61u7davp Basically : Here is my shell script … Read more

Categories Shell Script Tags intune, shell
Older posts
Page1 Page2 … Page19 Next →
+ More

Things I like

Amazon Echo
Philips Hue
Ergonomic Chair

Categories

  • Active Directory
  • AutoIt
  • Casper
  • Entra
  • Links
  • Mac
  • Microsoft365
  • Powershell
  • Ruby on Rails
  • SCCM
  • Shell Script
  • Shopping
  • Synology
  • Tools
© 2026 Dispatch a GeneratePress Site by Flint Skin
Next Page »
  • SCCM
  • Casper
  • Powershell
  • Mac
  • Shell Script
  • Tools
  • Synology
  • Shopping