TECH FLOW AUTOMATION

      EXCEL TO PDF Introduction This tutorial will guide you through creating an automated workflow using Microsoft Power Automate to convert Excel files (.xlsx) uploaded to OneDrive for Business into PDF format. This workflow will monitor a specific folder in OneDrive for Business, convert any newly uploaded Excel files to PDFs, and save the converted files back into a designated folder. Create a New Flow Now, let's create a workflow that converts Excel files to PDFs. 1. Start with a Blank Flow:    - Click on "Create" from the left sidebar and choose "Automated cloud flow".    - Give your flow a name, such as "Excel to PDF Converter", and select "When a file is created (OneDrive for Business)" as the trigger. 2. Set Up the Trigger: ·    Choose the OneDrive for Business account and specify the folder where you want to monitor for new Excel files. ·    Select "When a file is created" as the trigger condition. This ensu...

Prerequisites 1. Open Your Workbook: Open the Excel workbook in which you want to list the sheet names . 2. Create a New Sheet: Insert a new worksheet where you will display the list of sheet names. For this example, name the new sheet Index. Enable Macros To use some advanced Excel functions, you need to enable macros: 1. Go to Developer Tab: If you don’t see the Developer tab, you need to enable it from Excel Options. 2. Enable Macros: Click on Developer > Macro Security and ensure macros are enabled. Use the GET.WORKBOOK Function 1. Define Name: Since GET.WORKBOOK is an old Excel 4.0 macro function, you need to define it as a named range.     Go to Formulas > Define Name.     Name it SheetNames.     In the Refers to box, enter:   =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") 2. Reference Sheet Names Dynamically with `INDEX` To keep things organized, assign serial numbers to each sheet name in cell A1 and drag it down. Use the formul...