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...