Power Platform

Power Automate Desktop - Consolidated Excel Automation (Complete Flow Explanation) This desktop flow consolidates multiple Excel files into one master Excel file and emails the final report to a chosen recipient. The flow consists of three major blocks: User Input Collection , Main Consolidation Loop , and Read & Write Subflow . Below is the clear explanation of each block. 🔹 Block 1 - Main Flow Controller This block initializes the flow, prepares the environment, loops through all Excel files, consolidates the content, and finally sends the output by email. Create New List : A blank list variable is created to store Excel file paths. Get Excel Files Details : A subflow populates the list based on user input. Get Documents Folder Path : Determines where the consolidated report will be saved. Launch Master Excel : Opens a blank Excel instance that acts a...

Power Automate Desktop - Excel Find & Replace Automation This desktop flow allows the user to select an Excel file and perform a Find & Replace operation on the contents of the worksheet. The user can choose whether to replace all occurrences of a value or only the first occurrence . 1. Display Custom Form The flow begins by opening a custom Adaptive Card form. The form contains fields where the user can: Enter the text to find Enter the replacement text Select an Excel file ( xls , xlsx , csv ) Choose the replace mode: Find & replace all or Find & replace first 2. Check for Cancel If the user presses Cancel , the flow stops immediately. Otherwise, it continues with the replacement process. 3. Launch Excel The selected Excel file is opened in editable mode using the Launch Excel Under Existing Process action. This ensures the file is opened inside a...

📄 Power Automate Desktop - Excel Automation Explanation This PAD flow allows the user to select an Excel file, extract all table values automatically, and display them in a popup message. Below is the detailed step-by-step process: 1️⃣ Select Excel File A file dialog appears prompting the user to select an Excel file ( *.xls* ). If the user clicks Cancel , the flow stops. 2️⃣ Launch Excel The flow launches the selected Excel file in visible and editable mode. Error handling ensures the file opens correctly. 3️⃣ Detect Data Range PAD automatically determines the first free row and first free column in the Excel sheet. This allows the flow to dynamically calculate the exact data range. 4️⃣ Read Data Using the detected boundaries, PAD reads the entire data table starting from column A row 1 , up to the last used row and column. The extrac...

PAD Overall Goal You are automating a process to: Collect all Excel files ( .xlsx ) from a folder (including subfolders). Combine their data into one master table. Calculate total and average sales by region ( North, South, East, West ). Save everything in a new consolidated Excel file with two sheets: One sheet with all raw data Another sheet with summarized regional totals and averages Download the sample files from the below link Power-Automate-Desktop Samples Power Automate Desktop – Pseudo Code Explanation This Power Automate Desktop (PAD) pseudo code automates the process of consolidating Excel files and calculating total and average sales by region. Below is the plain English explanation of each step and why it’s performed: 1. Get all Excel files: The flow searches through the folder E:\Power Platform\PAD\Samples (including subfolders) to collect every Excel file with the extension .x...