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