Step 10 — Detecting the Most Frequent Multi-Word Phrases (N-grams) in Text with Python Introduction You’ve explored word co-occurrence with bigrams and visualized word-pair networks. Now it’s time to deepen your analysis by identifying the most common multi-word phrases (also… Continue reading

Step 8 — Exploring Word Co-occurrence: Counting Word Pairs Appearing Together in Python Introduction You’ve learned to compare word frequencies in different texts. Now, it’s time to look deeper into how words relate to each other within the same text.… Continue reading

Step 7 — Comparing Word Frequencies Between Two Texts in Python Introduction By now, you can read, clean, tokenize, filter, and visualize word frequencies in a single text. But in real NLP projects, comparison is as important as analysis. How… Continue reading

Step 5 — Filtering Out Stop Words in Your Python NLP Pipeline Introduction Welcome to Step 5 of our practical NLP journey in Python! In previous steps, you learned how to normalize text, tokenize it, and count word frequencies. Now,… Continue reading

Step 4 — Sorting and Displaying the Most Common Words in Text (with Python) Introduction In the previous step, you learned how to count word frequencies and store the results in a dictionary. Now, you’ll tackle a new and practical… Continue reading

Step 3 — Counting Word Frequencies in Text with Python Introduction After learning how to normalize text and break it down into reliable tokens, the next essential milestone on your NLP journey is counting the frequency of each word. Counting… Continue reading

Step 2 — Basic Text Normalization and Reliable Token Lists in Python Introduction After creating a safe Python environment and running our first basic script, it’s time to address the heart of many NLP tasks: breaking raw text into usable… Continue reading

Step 01 — First Contact with Text in Python (Strings) + Repository Scaffold (pyproject.toml) Introduction This 50-step project is a practical, beginner-friendly path to learning Natural Language Processing (NLP) in Python by building one small app per step. In Step… Continue reading

Building SharePoint-Based Agents with World Bank GDP and Football Data From structured list queries to PDF knowledge bases and SPFx visualization A very strong pattern for Microsoft 365 AI solutions is to begin with structured data in SharePoint lists, then… Continue reading

Read-Only Fields in SharePoint Forms with Power Automate Auto-Population Modern SharePoint list forms are excellent for collecting business data, but they are not always the best place to let users type every value manually. In many real projects, some fields… Continue reading

SharePoint List Forms: How to Keep Fields Read-Only and Use Power Automate to Fill Them A very practical pattern in SharePoint Online is this one: This works well for columns such as: It also matches the actual behavior of modern… Continue reading

Building Better SharePoint List Forms with JSON Sections, Static Read-Only Fields, and Conditional Visibility A SharePoint list form becomes much easier to use when it is organized into clear sections instead of one long stream of fields. Native form configuration… Continue reading

Designing SharePoint List Forms with JSON Sections, Static Read-Only Fields, and Conditional Visibility When a SharePoint list form starts growing, the first pain point is usually readability. A flat form with dozens of fields quickly becomes hard to scan, hard… Continue reading

Building a Brazil Capitals Weather App in Power Apps: Step-by-Step with Power Automate, Open-Meteo, Current Conditions, and Forecast Charts This article walks through how to build a phone-layout Canvas App in Power Apps that lets a user select a Brazilian… Continue reading

Building App 1: A Minimal Power Apps Canvas App That Calls Power Automate and Shows São Paulo Weather In this first version, the goal was deliberately small: build a simple Canvas App that calls a Power Automate flow, reads weather… Continue reading

How to Use an HTTP Request Result from an API Inside a Power Apps Canvas App When people start working with Power Apps and APIs, one of the first assumptions is usually this: “I will call an HTTP endpoint from… Continue reading

Understanding MCP Servers (Model Context Protocol) — A Deep, Practical Guide (with Microsoft Learn as the backbone) If you’re building AI agents that need to search documentation, query enterprise data, or run actions (create tickets, call APIs, read SharePoint, etc.),… Continue reading

SharePoint “Quick Charts” Bar Chart in a Column (PnP Sample) Render a live bar chart per list item using Column Formatting JSON + QuickChart.io (with 3 useful variations). The PnP sample generic-quick-charts-bar-chart is a clever pattern: it uses SharePoint Column… Continue reading

SharePoint Approval Status Badges with Column Formatting JSON Turn the built-in moderation status into a clean icon + color “pill” (plus 3 variations you can reuse). When you enable Content Approval on a SharePoint list or library, SharePoint exposes an… Continue reading

SharePoint Approval Status Hover Card (PnP Pattern) — A Publish-Ready Guide + Variations This article shows how to implement the PnP “generic-approval-status-hover-card” pattern to transform SharePoint’s built-in Approval Status into a clean icon + label with a rich hover card… Continue reading

Building a 0–10 “Rating Bar” in SharePoint Column Formatting (and 3 Similar Variations) If you’ve ever wanted a compact 0–10 score UI inside a SharePoint list view (or Microsoft Lists), the PnP sample “number-zero-to-ten-rating” is a clean pattern to learn:… Continue reading

Building a Consistent SharePoint List “Design System” with PnP Column Formatting Samples The PnP List Formatting gallery is not just a collection of cool JSON snippets—it’s a pattern library you can standardize into a reusable UI design system for SharePoint/Microsoft… Continue reading

Custom Fields in SharePoint Framework (SPFx): Provisioning, Rendering, Editing, and Property Pane Controls (with PnP Examples) When you say “custom fields in SPFx”, you usually mean all of these: Below is a single, publish-ready technical article with practical examples for… Continue reading

OLAP Deep Dive for Microsoft 365: Cubes (Multidimensional), Tabular Models, and Power BI Semantic Models — and How to Use Them with SharePoint, Power Automate, Power BI, and Power Apps OLAP (Online Analytical Processing) is the discipline of building analysis-optimized… Continue reading

OLAP in the Microsoft Ecosystem (and how to actually use it with SharePoint, Power Automate, Power BI, and Power Apps) OLAP (Online Analytical Processing) is the “analytics side” of data: it’s designed for fast slicing/dicing, aggregations, and business-friendly analysis across… Continue reading

Adaptive Cards “for everything”: one mental model, multiple hosts (Teams, Power Automate, Copilot Studio, SharePoint/Viva) Adaptive Cards are authored in JSON and rendered by a host (Teams, Bot Framework, Copilot Studio, etc.). The host controls feature support and final UI,… Continue reading

Adaptive Cards: an extensive introduction (with practical mental models) Adaptive Cards are a platform-agnostic UI snippet format authored in JSON that a host app (for example, Microsoft Teams, Bot Framework channels, Copilot experiences, or your own app) can render into… Continue reading

Step-by-step guide to build a Power Automate workflow that sends Microsoft Teams messages. I’ll cover the 3 most common patterns (chat, channel, and “post as Flow bot”), plus typical pitfalls and how to test. Context: In Power Automate, sending Teams… Continue reading

Building a Daily Football Matches Ingestion Flow (REST API → Power Automate → SharePoint) In this post, I’m documenting a real, working pattern for ingesting daily football matches from a REST endpoint (example: /v4/matches) and persisting them into a SharePoint… Continue reading

This article argues that modern AI systems behave not as amortizable capital assets but as perpetual operating cost systems, where capital investment does not converge toward payoff but instead enforces continuous reinvestment. The misclassification of AI economics is the primary… Continue reading

Sorting an Array Variable by a Date Field in Power Automate (Step-by-step) In Power Automate, an array variable doesn’t have a native “Sort” action. The standard pattern is: Below are the most reliable approaches (with copy/paste expressions). Approach A (Best):… Continue reading

Power Automate → “Pretty” HTML Email Table (Header Row + Grid) for Daily SharePoint Comment Capture Right now your flow is producing valid HTML, but it’s unstyled, so Outlook renders it as plain text-like lines with minimal spacing. The fix… Continue reading

Interaction 1 (Baseline v1.0.0): Build a Generic Copilot Prompt Hub SPFx Web Part for SharePoint Why this exists Most organizations try Copilot in SharePoint and quickly hit the same issue: Before you build agents, connect to business lists, or automate… Continue reading

Webhooks, End-to-End: Power Automate, Power Apps, Power BI, Azure Functions, and SharePoint (Microsoft 365) A webhook is a lightweight, event-driven integration pattern where System A notifies System B by sending an HTTP request (usually POST) to a pre-registered URL whenever… Continue reading

Counting Document Library Items in Power Automate (and fixing “Folder Not Found” 404) — the right way When you need to compare the number of items in a document library across two SharePoint sites, you have two common options: In… Continue reading

Using a SharePoint Choice Column as the “Workflow Engine” for a Modern List (SharePoint Online + Power Automate + Power Apps + Azure DevOps) In SharePoint Online (Microsoft Lists), a Choice column is one of the simplest—and most powerful—ways to… Continue reading

SharePoint + Power Automate + Power BI + Power Apps The corporate integration suite for transactional and non-transactional systems Modern organizations don’t win just by running “systems of record” (ERP/CRM/HRIS). They win by connecting them to the day-to-day reality of… Continue reading

Flow Blueprint: “Sync Site Pages” (Copy pages from Source site to Target site) — list-driven with Power Automate Below is a ready-to-build blueprint you can reproduce in Power Automate. The flow is triggered by one specific SharePoint list item (a… Continue reading

Copying SharePoint Online Pages Between Sites with Power Automate (List-Driven “Sync Pages” Pattern) This article shows a repeatable, list-driven way to copy pages from one SharePoint Online site to another using Power Automate. The key idea is simple: To cover… Continue reading

Building a “Comments Created Today” Digest for SharePoint Online with Power Automate (REST) — Including Clickable Item Links This article documents a mature, production-ready pattern to collect SharePoint item comments created today, format them into a clean HTML email, and… Continue reading