Power of Automation

📘 Power Automate Blog Post: Extract Library Name and Library ID from "When a file is created (properties only)" Trigger In this guide, we’ll walk through building a robust Power Automate flow that: Works with the “When a file is created (properties only)” trigger. Dynamically extracts both Library Name and Library ID (GUID) . Avoids unreliable URL parsing. Uses SharePoint REST API for accurate library details. 🎯 Scenario You want a flow that triggers automatically when a new file is uploaded to any SharePoint document library and retrieves: The correct Library Name . The accurate Library ID (GUID) . 🔹 Full Step-by-Step Solution 1️⃣ Trigger: "When a file is created (properties only)" Configure: Site Address: Your SharePoint site. Library Name: Specify a library or leave blank for all libraries. This trigger provides metadata such as: {Link} (file URL) {Path} (relative path) 2️⃣ Compose: File URL Name: Com...

  ✅ Overview This guide walks you through every step needed to add an “Open Attachment” button inside your Canvas app gallery. It fetches the first attachment from SharePoint (list visio2 ) via Power Automate and opens it directly in the browser in preview mode. 🔸 Step 1: Configure SharePoint for Attachments Go to your visio2 SharePoint list. Select List Settings → Advanced Settings . Ensure Attachments are set to Yes . Save changes. 🔄 Step 2: Create Power Automate Flow – GetVisio2AttachmentUrl In Power Automate, click Create → Instant cloud flow . Name it GetVisio2AttachmentUrl and select Power Apps (V2) trigger. Click + Add an input , select Number , and rename it to itemID . Get item Action: Site: your SharePoint site List: visio2 ID: choose itemID from trigger inputs Get attachments Action: Site: same as above List: visio2 ID: still itemID Compose Action: Expression: text Copy Edit first(body('Get_attachm...

  🎯 Power Apps Tip: Disable Choice Field Based on Text Field Value in SharePoint Custom Form Author: powerapps fargo Scenario: You’re customizing a SharePoint list form using Power Apps. You want the form behavior to be dynamic — if one field is empty, another should reset and become unselectable. Let’s look at a real-world example to implement this. 🔧 Use Case You have a SharePoint list called codewarrior with the following two columns: openai – Single line of text gpt – Choice column (dropdown) 🧠 Business Rule If the openai field is blank , the gpt dropdown should: Be cleared Be disabled (grayed out) If openai has text, the gpt field becomes active again. 🛠️ Step-by-Step Guide Let’s walk through how to achieve this in a Power Apps customized SharePoint form. ✅ Step 1: Open the Power Apps Form Customization Navigate to your SharePoint list codewarrior From the top ribbon, click: Integrate → Power Apps → Customize forms P...

 Absolutely! Below is your final solution rewritten as a professional blog post , with Azure OpenAI URL and API key omitted or hidden for security. 🔍 Automatically Summarize Microsoft Teams Meetings with Azure OpenAI + Power Automate Author: Kirolos – Power Platform & AI Automation Engineer Published: [Insert Date] 🚀 Overview Tired of manually documenting meeting notes from Microsoft Teams? In this post, I’ll walk you through a real-world solution to automatically summarize Teams meetings using the transcript (.vtt) file , Azure OpenAI (GPT-4.1) , and Power Automate . This solution will: Monitor for uploaded .vtt transcript files from Teams Clean and prepare the content using Power Automate Send it to Azure OpenAI for summarization Deliver a clean, actionable meeting summary via email 🔧 Use Case Environment : Microsoft 365, SharePoint, Azure OpenAI, Power Automate Goal : Summarize Teams meeting transcript files automatically and send summari...