Power of Automation

Add a Real “Email User” Button for a SharePoint List using Power Automate —  Overview This guide shows how to send server-side emails from a SharePoint list item using Power Automate . It includes two options: Option 2A — “For a selected item” flow : runs from the list’s Automate menu. Option 2B — Real in-row button : a column-format button that opens the flow’s run panel (uses executeFlow ). Everything here is generic —replace the placeholders with your own values (no tenant domains or personal addresses exposed). Prerequisites A SharePoint list (call it anything, e.g., Email Requests ). A Person column (single or multi). In steps below, use its internal name : <PersonColumnInternalName> . (Optional) Column Title for the email subject. Power Automate access and an Outlook mailbox (personal or a shared mailbox ). Placeholders you’ll see <SiteUrl> — your SharePoint site URL (e.g., https://<yourtenant>.sharepoint.com/sites/<...

🚀 Build Your Own “Copilot Prompt Hub” with SharePoint + Power Apps Tired of keeping your Outlook Copilot prompts in scattered notes or emails? Here’s a simple way to store, share, and copy prompts across your team using just SharePoint Online + Power Apps . This no-code solution takes less than an hour to set up and gives your team a central hub for all their best prompts. 🗂 Step 1 – Create a SharePoint List for Prompts We’ll use SharePoint as our prompt library . Go to your SharePoint site → New → List → Blank list . Name it: CopilotPrompts . Add these columns: Title → Single line of text (prompt name). PromptText → Multiple lines of text (plain text). Category → Choice (Email, Meeting, Follow-Up, Action). 👉 Now you’ve got a central place to store all prompts. 📱 Step 2 – Build a Power Apps “Prompt Hub” Let’s turn this list into a user-friendly app your team can use on desktop, Teams, or mobile. Go to make.powerapps.com → Apps → New ...

  Inventory Azure AI Foundry Like a Boss (Projects, Endpoints, Creators + CSV) If you’re the Azure admin everyone pings when “where did that AI project go?”—this one’s for you. The script below scans every subscription you can see, finds all Azure AI Foundry projects , captures who created them (from ARM systemData ), builds the project endpoint , pulls account keys (masked on screen, full in CSV), prints a clean colored table , and exports a ready-to-filter CSV . What you’ll get Console table (keys masked): Account, Project, Location, CreatedBy, CreatedAt (UTC), Endpoint, Key1/Key2 (masked) CSV saved to C:\scripts\ai-foundry-projects-createdby-<timestamp>.csv with full values: Project , ProjectEndpoint CreatedBy , CreatedByType , CreatedAt , LastModifiedBy , LastModifiedAt AccountKey1 , AccountKey2 Prerequisites PowerShell : 7.x recommended (Windows PowerShell 5.1 works too) Azure permissions : To discover projects: Reader or higher on...

  Keep Excel in Sync with a SharePoint List (Beginner-Friendly, No Filter Query) This post shows you—step by step—how to sync a SharePoint list to an Excel table without using the Excel “Filter Query.” We’ll use Filter array + Condition instead, which is more reliable for beginners. SharePoint list : tjmax Columns: vendorspo (single line of text), summary (single line of text) Excel : worksheet Clients , table tblClients Columns: clientname , details 👉 Grab the ready-to-use Excel file (already formatted as a table): Download: tjmax_clients.xlsx What you’ll build Whenever an item is created/edited in the tjmax list, the flow checks if that item’s vendorspo already exists in the Excel table’s clientname column. If not found , it adds a new row to Excel with: clientname = SharePoint vendorspo details = SharePoint summary You’ll also see an optional scheduled version that loops all SharePoint items daily/weekly. Prerequisites (5 minu...

  Super-Simple OneDrive “Auto-Rescue” 🚀 How I auto-find low-storage users and boost their OneDrive space—hands-free Running out of OneDrive space is a tiny alert that can snowball into tickets, delays, and very cranky teammates. This post gives you a drop-in automation that: Scans your tenant for users with < 5 GB free , and Auto-bumps their OneDrive quota by +5 GB —safely, repeatably, auditable. It’s clean, modular, and designed for beginners to succeed on Day 1 and for admins to trust in prod. What you’ll build Script 1 → Exports a CSV of users who have less than 5 GB free (name, UPN, OneDrive URL, usage %). Script 2 → Reads that CSV and raises each user’s quota by 5 GB . Pro tip: Drop these into a scheduled job and you’ve got “always-green” OneDrive capacity 🌿. Prerequisites (no secrets in code!) Microsoft 365 admin perms for OneDrive/SharePoint management PowerShell (latest) App-only access via Microsoft Graph + PnP.PowerShell G...

🚀 Building an AI Agent in Copilot Studio: Your Power Automate Expression Expert (Powered by Microsoft Learn) Struggling to remember the exact syntax for substring() , split() , or formatDateTime() in Power Automate? You’re not alone. Expressions are powerful, but they can be tricky—even for experienced makers. That’s where Copilot Studio comes in. In this post, we’ll build an AI Agent in Copilot Studio that serves as your Power Automate Expression Expert —and the best part? It’s connected directly to Microsoft Learn (MCP) , so users get instant help plus official documentation. ✨ Why Microsoft Learn (MCP)? Microsoft Learn is the official learning platform for Microsoft technologies. It includes: ✅ Verified syntax and expression references ✅ Step-by-step tutorials for Power Automate ✅ Always up-to-date documentation By connecting your Copilot Studio agent to MCP, you’re giving users not just an answer—but a trusted learning resource . 🛠 Step 1 – Create Your Ag...