Advanced excel operations in Power Automate

Advanced excel operations in Power Automate | LazyBots

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

Comments

Convert to PDF using API | Power Automate Desktop

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.

Captcha solving using Power Automate Desktop | LazyBots

In this tutorial, we are learning Captcha solving using Power Automate Desktop. This video covers: 2Captcha API Invoke web service action for accessing API Run Powershell script action to convert Captcha image to Base64 string basic web automation actions To create an account on 2captcha, click here https://2captcha.com?from=6396966 get the API key from the dashboard and start solving captchas. Happy Automation :)

Lazy Bots : Let the bots work for you.

Search This Blog