Power Platform

Get First Working Day of the Next Month This flow gets the current date and time and calculates the first working day of the following month. If the first day of the month falls on a Saturday or Sunday, the flow automatically selects Monday as the first working day. Step-by-Step Explanation Get the current date and time The flow starts by retrieving the current date and time and storing it in the variable Now . Add one month to the current date The flow adds one month to Now and stores the result in Nowplus1 . This step ensures we are working with the next month. Create the first day of next month The flow constructs a text value using: %Nowplus1.Month%/01/%Nowplus1.Year% This represents the 1st day of the upcoming month. It then converts this text into a DateTime variable called FirstDayOfNextMonth . Check the day of the week A mess...

Calculate Your Age in Days - Power Automate Desktop Flow This flow asks the user to select their birth date and then calculates how many days they have lived so far. Finally, it shows the result in a motivational message. Step-by-Step Explanation Show flow description The flow begins by displaying a message box explaining what the automation does: it will ask for your birth date and compute your age in total number of days. Prompt user to select their birth date A date selection dialog appears where the user picks their birthday. The selected date is saved in the variable BirthDate . Get the current date The flow retrieves today’s date (without time) and stores it in CurrentDate . Calculate the difference in days Using the DateTime.Subtract action, the flow subtracts the birth date from today's date. The result—total days alive—is stored i...

🔄 Power Automate Desktop - Date & Time Handling Flow This flow demonstrates how to work with date and time values in Power Automate Desktop. It shows multiple formatting methods for both date and time, using standard formats and custom formats. It also includes converting formatted text back into a DateTime value. Step-by-Step Explanation Get Current Date and Time The flow begins by retrieving the current system date and time using the action Get Current Date and Time , and stores it in the variable CurrentDateTime . Convert Date to Short Date Format (M/d/yyyy) The flow converts CurrentDateTime into short date format using a standard formatter. A message box displays the formatted date to the user. Convert Time to Short Time Format (h:mm tt) The time component of the same DateTime value is formatted into short time format, such as 2:54 PM , and displayed to the...

Retrieve Metadata of a Web Page using Power Automate Desktop This Power Automate Desktop flow allows the user to enter a website URL and automatically retrieves important metadata such as the page title, meta keywords, description, and the full HTML source. It uses browser automation to open the page, extract information, and optionally save the source code to a file. Step-by-step Explanation Ask the user for a website URL The flow begins with an input dialog that prompts the user to enter the website address. The entered URL is stored in the variable URL . If the user clicks Cancel , the remaining steps do not execute. Open the website in Microsoft Edge If the user clicks OK, the flow launches Edge and opens the provided webpage. The browser window is maximized, and a retry mechanism is added in case the page fails to load on the first attempt. ⚠️ The Power Automate browser extension must be inst...

Take Screenshot of a Website using Power Automate Desktop This Power Automate Desktop flow asks the user for a website URL, opens it in Microsoft Edge, takes a screenshot, saves it to the Pictures folder, renames the file with the current date and time, and finally shows the file location in a message box. Step-by-step explanation Ask the user for the website URL The flow starts with a Display input dialog action that shows a popup window titled “Take screenshot of a website” . The dialog asks: " Please provide the website address to take screenshot of.." A default URL is pre-filled: https://mspowerplatformtips.blogspot.com/ The user types or changes the URL and clicks OK or Cancel . The entered URL is stored in the variable URL , and the button clicked is stored in ButtonPressed . Check if the user canc...

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

PA Quarter Close – Review Transactions Power Automate Use Case for Finance Teams The finance department of Peters Manufacturing needs your help. At the end of each fiscal quarter, the finance team spends significant time on an important task ,ensuring that all financial obligations were invoiced on time, paid on time, and cleared within the expected period. Using Power Automate , this repetitive verification process can be automated to save time and improve accuracy when validating transaction data between the internal finance system and the Arcadia Banking application. Note: You can view the challenge at the link below. Automation Anywhere Labs - Quarter Close Challenge It will ask you to log in. Use the Community Login option and sign up for a new account if needed. Enter your Gmail or any other email address to sign in. Before running the flow, make sure you are logged in to the site. Use C...

We’ll look at how to select a UI element from a web form when its ID changes every time the form is loaded. Go to https://rpachallenge.com/ and download the Excel file. First, I’ll explain how to capture the element and make the selector dynamic. Consider that we've launched the RPA Challenge website in Power Automate Desktop (PAD). After adding the Populate text field on web page action, click Add UI element . Open this tab in Microsoft Edge. Select the First Name text box. It will be captured using its ID , but since the ID changes each time, replace it with a unique HTML attribute. For this website, the attribute ng-reflect-name is unique and can be used instead. After selecting the element, turn on the Text Editor toggle in the selector window. Then replace the existing selector with: input[ng-reflect-name="labelFirstName"] You can find this attribute value by inspecting the element in the brows...