Lazy Bots : Let the bots work for you.

  In this Power Automate Desktop learning series video, we are learning how to convert any kind of documents to PDF using Muhimbi API for document conversion. This video covers: ------------------------------------------------------ 00:00 - Introduction 03:00 - File to base64 string conversion using Powershell script 05:00 - Invoke web service (API call) 09:20 - Create file from Base64 string 10:30 - Output Actions used: Get files in folder Foreach Run Powershell script Trim Get File Path part Invoke web service Convert Json to custom object How to get Muhimbi API Key: Visit Muhimbi website Fill in your details You'll get the API key and other details in your email How to convert file to Base64 string: Visit official microsoft documentation on power shell script. Happy Automation.

  In this Power Automate Learning series post, we are going to access microsoft excel as a database and perform SQL operations. Actions Covered in this session: Open SQL Connection Used to connect to various kind of data sources Execute SQL Statements Used to specify which SQL statements to be executed in the data source the Sheet name will be the table name in Query, and don't forget to add a $ at the end of table name. for eg: If sheet name is Employees, then the query will look like SELECT * FROM [Employees$] Cose connection Used to close connection After every operation, don't forget to close the SQL connection. In this session, in Open SQL Connection action, we have to provide a connection string. A connection string will look like this: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\shank\Music\test.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";Persist Security Info=False For more information about connection strings, and options Visit Microsoft off...

  In this tutorial, we are covering advanced excel actions available in power automate desktop Actions covered are: Run Macro Add/delete worksheets Add/delete columns Add/delete rows Copy and paste cells Select cells in an excel The macro used in the is given below, Sub SetMessage() ' ' SetMessage Macro ' ' Keyboard Shortcut: Ctrl+Shift+M '     Range("D2").Select     ActiveCell.FormulaR1C1 = "Success"     Selection.AutoFill Destination:=Range("D2:D6")     Range("D2:D6").Select End Sub  

  As we all know, excel is an amazing software for managing so many types of data in an organized way. and we can generate reports, filtered data, various data representation etc... In this Post, we are demonstrating how we can automate excel using Power automate. this contains the following operations Create an excel Launch excel Read from excel Write data to excel Append data to excel Create and Activate new sheets Find first free column/row from the worksheet Save and close excel

  In this demonstration, We are covering the Basic power automate text extraction from a windows application. we can learn how to start an application using power automate desktop how to get text from windows application basic ui element selection