Power Platform

DT Merge Data Tables vs Join Data Tables in Power Automate Desktop Quick reference for action selection, behavior, and constraints Merge Data Tables Purpose: append rows from one data table into another. Use when two tables share a common structure or when stacking rows is the goal. Inputs: primary table variable, secondary table variable, merge mode option. Merge mode handles schema differences: add extra columns, ignore extra columns, or error on extra columns. Behavior: rows from the second table are added to the first table variable. Limits: no relational matching, memory usage for large tables, result is in-memory only. Join Data Tables Purpose: perform relational-style joins using key-based rules. Use when rows must be matched between tables and fields from both tables are needed in the output. Inputs: first table, second table, join type (Inner, Left, F...

PA Power Automate Desktop - Data Table Concise reference - what it is, where to use, when to use, limitations 1. What it is A Data Table is an in-memory tabular structure with named columns and rows, implemented on the .NET DataTable model. Use it to hold structured records inside a flow for manipulation, iteration, and transformation before exporting or persisting. 2. Where you can use it Read Excel or CSV data and process rows without opening Excel UI Aggregate results from web scraping or API responses into a structured form Prepare datasets for export to SharePoint, databases, or files Combine multiple sources - append, merge, or join data before output Drive decision logic by iterating rows and applying conditional operations 3. When to use it When automation must process multiple records in memory during runtime When you need temporary structured storage between extraction and output step...

Power Automate Desktop – Variables and Operations In Power Automate Desktop, you can create different types of variables using the UI and assign values to them. For example: Text variable → value: sunil Number variable → value: 10 Boolean variable → value: True List 1 → add items: sunil, anil, zeshan, nithesh List 2 → add items: sunil, sachin, 20 Once variables are created, you can perform actions to modify and manage their values. Variable Operations Overview Number operations: Increase or decrease numeric values and round decimal numbers to a specific number of digits. Boolean variable: Holds True or False values for conditional checks. List operations: Perform advanced operations on lists of data. List Operations Explanation Sort List: Arranges items in alphabetical or numeric order. Shuffle List: Randomly changes the order of list items. Reverse List: Flips the list order from last to...

Power Automate Desktop Variables: Types and Usage In Power Automate Desktop (PAD), variables store data that flows through your automation. They can be referenced in actions using %VariableName% format. 1. Text Stores string values like names, messages, or file paths. Example: Set Variable: UserName = John Doe Display Message: Hello, %UserName% 2. Number Stores numeric values for calculations. Example: Set Variable: Age = 30 Display Message: You are %Age% years old 3. Boolean Stores True or False flags. Example: Set Variable: IsApproved = %true% Display Message: Approval status: %IsApproved% 4. List Stores multiple values in a collection. Access items by index. Example: Set Variable: EmployeeNames = [John, Mary, Steve] Display Message: First Employee: %EmployeeNames[0]% 5. Custom Object Stores key-value pairs. Access properties using dot notation. ...

Power Automate Desktop (PAD) is Microsoft’s robotic process automation tool that enables users to automate repetitive desktop and web-based tasks without any coding. It belongs to the Power Automate family, allowing seamless connection between desktop automation and cloud-based workflows. What Power Automate Desktop Does PAD records and replays user actions such as mouse clicks, keyboard input, file operations, and navigation to create automated flows. Through a drag-and-drop interface, users can build flows to handle daily work like generating reports, reading Excel data, sending emails, or interacting with web pages. It works well with Excel, Outlook, SharePoint, browsers, and even legacy systems without APIs. Integration with Cloud Flows PAD connects with Power Automate cloud flows to enable hybrid automation. For example, when a file is added to SharePoint, a PAD flow can run on your desktop to process it locally. This approach combines local and cloud automation for a complete wor...

This blog explains how you can clone my GitHub repository , install dependencies, and run the SPFx React web part for: ✅ CRUD operations on SharePoint list items ✅ Searching list items ✅ Selecting list name from the property pane 👉 GitHub Repo: ReactSPFx 📌 Step 1 – Prerequisites Before you start, make sure you have: Office 365 / M365 tenant with SharePoint Online Node.js (LTS) compatible with SPFx version in the project npm (comes with Node.js) Yeoman and gulp installed globally Access to App Catalog if you want to deploy 📌 Step 2 – Clone Repository Open your terminal and run: install git to run below command git clone https://github.com/sunilshetty07/ReactSPFx.git  cd ReactSPFx 📌 Step 3 – Install Dependencies Run the following inside the folder: npm install This installs React, SPFx controls, PnP libraries, Fluent UI, etc. 📌 Step 4 – Run in Local Workbench Start the local dev server: gulp serve Now open the SharePoint Workbench : Local: https://l...

 Step1 : Add the SharePoint Online list connection to your Code App using the following command: pac code add-data-source -a <connection name> -c <API ID> -d <SharePoint Site(encoded)> -t <list id> The process of retrieving the connection name and API ID has already been explained in Part 1 and Part 2 of the blog. Please refer to those sections if you are not familiar with how to obtain them. For the SharePoint site , you must provide the encoded URL . The required format is double URL encoding (also known as percent-encoding applied twice). How it works Normal characters in a URL are encoded once using percent-encoding (RFC 3986) : : → %3A / → %2F If you encode that result again , the % character itself becomes %25 : %3A → %253A %2F → %252F So: https: // → https% 3 A% 2 F%2F (once encoded) https% 3 A% 2 F%2F → https%253A%252F%252F In simple terms, you need to encode the SharePoint site URL twice. First, encode the Sha...

Please refer to the following blog for a step-by-step guide on creating Code Apps :  https://mspowerplatformtips.blogspot.com/2025/08/creating-code-apps-in-power-apps-step.html Setting up connection to connector for code apps. Create and set up connections in Maker Portal  You will need to start by creating and configuring connections at https://make.powerapps.com and you’ll need to copy connection metadata from there for use in later steps. 1. Launch the Maker Portal Connections page Go to  https://make.powerapps.com  and navigate to the Connections page from the left-hand navigation. 2. Create an Office 365 Users connection Click “+ New connection” and select Office 365 Users. Click “Create”. Then open the connection in Url you can see connection ID Get connection metadata for all created connections  You can use the Power Apps CLI to list your available connections and retrieve their IDs: pac connection list This command will display a table of all your ...

Intro In this post I’ll walk you through how I set up a code-based app for Power Apps (React/Vite front-end + Power Platform CLI for packaging/deployment), the exact errors I ran into, and how I solved them. If you want a hands-on, copy-paste able guide that covers Node versions, pac auth, environment issues, and packaging tips, this is for you. Prerequisites Microsoft 365 account with access to a Power Platform environment Node.js ( 20.19+  recommended LTS) VS Code Install power platform tools extension in VS Code. Steps: Step 1 : Open Visual Studio Code and launch the integrated terminal. Step 2: In the terminal, run the following commands one by one.   mkdir D:\CodeApps - Force cd D:\CodeApps npm create vite @latest myfirstapp -- -- template react - ts cd D:\CodeApps\myfirstapp npm install Initially, I ran the command: npm create vite@latest MyFirstApp -- --template react-ts This gave the error: Invalid package.json name The issue was caused because package...

When working with Microsoft Graph API inside Power Automate or Power Apps, many developers face this error: /me request is only valid with delegated authentication flow.   This happens because the HTTP connector with client credentials only works with application permissions , which do not provide a user context. If you need to call Graph API endpoints like /me , /me/messages , or /me/events , you must use delegated authentication . The best way to achieve this in Power Platform is by creating a Custom Connector with OAuth2 delegated flow . Step 1: Register an App in Azure AD  (Refer for more details: https://mspowerplatformtips.blogspot.com/2025/04/step-by-step-guide-power-automate.html ) Go to Azure Portal → Azure Active Directory → App registrations → New registration . Give your app a name (eg: Graph API Power Automate). Save the app and note down: Application (client) ID Directory (tenant) ID Step 2: Configure API Permissions In your register...