Table of Contents. Power Automate Desktop(Books)

Table of Contents.
Version … 15
Update History … 15
Features and Benefits of Utilization. … 16
Features and Advantages of Utilization … 16
Download/Install. … 25
Easy flow create and execute. … 26
Steps … 26
Save Flow and Save As (Copy). … 33
Variables and Test … 35
What is a variable. … 35
Usage Steps … 36
List … 51
Tool for Generate … 51
Create … 51
Operations on already existing List … 56
Match the two Lists … 66
Clear list … 71
Examples of Use … 72
Data table … 74
Tool for Generate … 74
Create … 74
Set variable action. … 78
Operations on already existing data table. … 83
Examples of Use … 138
Conditional Branch.If and Switch. … 139
Use of If and Switch … 139
How to use … 139
Formulas and Operators.How to specify multiple condition designations. … 146
Loop … 150
Loop Actions … 150
Loop control Actions … 156
How to deal with infinite loops … 159
Examples of Use … 159
Subflow … 162
Create … 162
Execution of subflow … 163
Exit Subflow … 166
Install extensions required for Browser automation. … 168
Recorder … 168
Comment … 173
How to use … 173
Situations where comments are effective … 174
Region … 176
How to use … 176
Error (Exception) handling. … 180
Description … 180
What to do when you get into an infinite loop. … 195
How to use line breaks in expressions. … 196
How to use … 196
Launch with administrative privileges. … 199
Steps … 199
Uninstall … 202
Simple example. … 204
Automated basic text file operations. … 204
Transcribing from one Excel book to another. … 211
Example of simple web browser auto-operation: auto-filling a web form. … 221
Variables Actions. … 235
Truncate number. Importance: High. … 235
Generate random number. Importance: Middle. … 239
Increase variable. Importance: High. … 242
Decrease variable. Importance: High. … 245
Flow control Actions. … 247
End. Importance: Middle. … 247
Wait. Importance: Middle. … 249
Stop flow. Importance: High. … 251
Get last error. Importance: Middle. … 253
Label / Go to. Importance: Low. … 256
Run flow Actions. … 261
Run desktop flow. Importance: High. … 261
System Actions. … 267
If process. Importance: Low. … 267
Wait for process. Importance: Middle. … 270
Run application. Importance: High. … 273
Terminate process. Importance: Low. … 278
Ping. Importance: Low. … 281
Set Windows environment variable. Importance: Low. … 285
Get Windows environment variable. Importance: Low. … 288
Delete Windows environment variable. Importance: Low. … 292
Workstation Actions. … 295
Print document. Importance: Low. … 295
Get default printer. Importance: Middle. … 298
Set default printer. Importance: Middle. … 301
Show desktop. Importance: High. … 303
Lock workstation. Importance: Middle. … 305
Play sound. Importance: Middle. … 307
Empty recycle bin. Importance: Middle. … 310
Take screenshot. Importance: Middle. … 312
Get screen resolution. Importance: Low. … 317
Set screen resolution. Importance: Low. … 321
Log off user. Importance: Middle. … 324
Shutdown computer. Importance: Middle. … 327
Scripting Actions. … 330
Run DOS Command. Importance: Middle. … 330
Run VBScript. Importance: Middle. … 335
Run JavaScript. Importance: Middle. … 341
Run PowerShell script. Importance: Middle. … 347
Run Python script. Importance: Middle. … 353
Run .NET script. Importance: Low. … 358
File Actions. … 365
If file exists. Importance: High. … 365
Wait for file. Importance: High. … 368
Copy file(s) . Importance: High. … 371
Move file(s) . Importance: High. … 374
Delete file(s) . Importance: High. … 377
Rename file(s) . Importance: High. … 380
Read text from file. Importance: High. … 390
Write text to file. Importance: High. … 393
Read from CSV file. Importance: High. … 397
Write to CSV file. Importance: High. … 402
Get file path part. Importance: Middle. … 406
Get temporary file. Importance: Low. … 409
Convert file to Base64. Importance: Low. … 412
Convert Base64 to file. Importance: Low. … 414
Folder Actions. … 417
If folder exists. Importance: High. … 417
Get files in folder. Importance: High. … 419
Get subfolders in folder. Importance: High. … 423
Create folder. Importance: High. … 427
Delete folder. Importance: High. … 430
Empty folder. Importance: High. … 432
Copy folder. Importance: High. … 433
Move folder. Importance: High. … 435
Rename folder. Importance: High. … 437
Get special folder. Importance: Middle. … 439
Compression Actions. … 442
Zip files. Importance: High. … 442
Unzip files. Importance: High. … 446
UI automation Actions. … 449
If window contains. Importance: Middle. … 449
Wait for window content. Importance: High. … 455
If image. Importance: Middle. … 460
Use desktop. Importance: High. … 465
Select tab in window. Importance: Middle. … 469
Wait for image. Importance: High. … 473
Hover mouse over UI element in window. Importance: Middle. … 478
Click UI element in window. Importance: High. … 482
Select menu option in window. Importance: High. … 490
Drag and drop UI element in window. Importance: Middle. … 494
Expand/collapse tree node in window. Importance: Low. … 499
If window. Importance: High. … 504
Wait for window. Importance: High. … 511
Get details of window(Data extraction) . Importance: Middle. … 518
Get details of a UI element in window(Data extraction) . Importance: High. … 527
Get selected checkboxes in window(Data extraction) . Importance: High. … 535
Get selected radio button in window(Data extraction) . Importance: High. … 540
Extract data from window(Data extraction) . Importance: High. … 545
Take screenshot of UI element(Data extraction) . Importance: Middle. … 550
Focus text field in window(Form filling) . Importance: Middle. … 555
Populate text field in window(Form filling) . Importance: High. … 558
Press button in window(Form filling) . Importance: High. … 563
Select radio button in window(Form filling) . Importance: High. … 567
Set checkbox state in window(Form filling) . Importance: High. … 571
Set drop-down list value in window(Form filling) . Importance: High. … 576
Get window(Windows) . Importance: High. … 581
Focus window(Windows) . Importance: High. … 586
Set window state(Windows) . Importance: High. … 592
Set window visibility(Windows) . Importance: High. … 598
Move window(Windows) . Importance: Middle. … 603
Resize window(Windows). Importance: Middle. … 608
Close window(Windows). Importance: High. … 613
HTTP Actions. … 618
Download from web. Importance: High. … 618
Browser automation Actions. … 625
If web page contains. Importance: Middle. … 625
Wait for web page content. Importance: Low. … 631
Launch new Internet Explorer. Importance: High. … 636
Launch new Firefox. Importance: Middle. … 642
Launch new Chrome. Importance: Middle. … 647
Launch new Microsoft Edge. Importance: Middle. … 652
Create new tab. Importance: Low. … 657
Go to web page. Importance: Middle. … 660
Click link on web page. Importance: High. … 665
Click download link on web page. Importance: High. … 673
Run JavaScript function on web page. Importance: High. … 678
Hover mouse over element on web page. Importance: Middle. … 681
Close web browser. Importance: High. … 686
Extract data from web page(Web data extraction) . Importance: High. … 688
Get details of web page(Web data extraction) . Importance: Middle. … 694
Get details of element on web page(Web data extraction) . Importance: High. … 698
Take screenshot of web page(Web data extraction) . Importance: Middle. … 704
Focus text field on web pageWeb form filling). Importance: Low. … 710
Populate text field on web page(Web form filling) . Importance: High. … 715
Set check box state on web page(Web form filling) . Importance: High. … 722
Select radio button on web page(Web form filling) . Importance: High. … 727
Set drop-down list value on web page(Web form filling) . Importance: High. … 733
Press button on web page(Web form filling) . Importance: High. … 738
Excel Actions. … 744
Basics … 744
Launch Excel. Importance: High. … 747
Attach to running Excel. Importance: Middle. … 753
Read from Excel worksheet. Importance: High. … 756
Get active cell on Excel worksheet. Importance: Middle. … 762
Save Excel. Importance: Middle. … 765
Write to Excel worksheet. Importance: High. … 769
Close Excel. Importance: High. … 773
Set active Excel worksheet. Importance: High. … 778
Add new worksheet. Importance: Middle. … 781
Get first free column/row from Excel worksheet. Importance: High. … 783
Get column name on Excel worksheet. Importance: High. … 787
Clear cells in Excel worksheet. Importance: High. … 789
Sort cells in Excel worksheet. Importance: High. … 793
Filter cells in Excel worksheet. Importance: High. … 798
Clear filters in Excel worksheet. Importance: High. … 805
Get empty cell. Importance: High. … 808
Resize columns/rows in Excel worksheet(Advanced) . Importance: Middle. … 815
Run Excel macro(Advanced) . Importance: High. … 819
Get Active Excel worksheet(Advanced) . Importance: Low. … 822
Get all Excel worksheets(Advanced) . Importance: Middle. … 824
Delete Excel worksheet(Advanced) . Importance: Middle. … 826
Rename Excel worksheet(Advanced) . Importance: Middle. … 829
Activate cell in Excel worksheet(Advanced) . Importance: Low. … 832
Select cells in Excel worksheet(Advanced) . Importance: Low. … 835
Get selected cell range from Excel worksheet(Advanced) . Importance: Low. … 840
Copy cells from Excel worksheet(Advanced) . Importance: Middle. … 843
Paste cells to Excel worksheet(Advanced) . Importance: Middle. … 846
Delete from Excel worksheet(Advanced) . Importance: High. … 848
Insert row to Excel worksheet(Advanced) . Importance: High. … 852
Delete row from Excel worksheet(Advanced) . Importance: High. … 854
Insert column to Excel worksheet(Advanced) . Importance: Middle. … 856
Delete column from Excel worksheet(Advanced) . Importance: Middle. … 859
Find and replace cells in Excel worksheet(Advanced) . Importance: High. … 862
Get first free row on column from worksheet(Advanced) . Importance: Middle. … 866
Set color of cells in Excel worksheet … 869
Word Actions. … 874
Launch Word. Importance: High. … 875
Attach to running Word. Importance: Middle. … 879
Save Word. Importance: Middle. … 882
Close Word. Importance: High. … 886
Read from Word document. Importance: High. … 890
Write to Word document. Importance: High. … 893
Insert image in Word document. Importance: Middle. … 896
Find and replace words in Word document. Importance: High. … 900
Database Actions. … 903
Open SQL connection. Importance: High. … 903
Execute SQL Statement. Importance: High. … 906
Close SQL connection. Importance: High. … 910
Email Actions. … 912
Retrieve email messages. Importance: High. … 912
Process email messages. Importance: High. … 917
Send email. Importance: High. … 920
Outlook Actions. … 925
Launch Outlook … 925
Retrieve email messages from Outlook … 927
Send email message through Outlook … 932
Process email messages in Outlook … 936
Save Outlook email messages … 939
Respond to Outlook email message … 943
Close Outlook … 946
Message boxes Actions. … 948
Display message. Importance: High. … 948
Display input dialog. Importance: High. … 954
Display select date dialog. Importance: High. … 959
Display from list dialog. Importance: High. … 967
Display select file dialog. Importance: High. … 972
Display select folder dialog. Importance: High. … 976
Mouse and Keyboard … 978
Block Input. Importance: Low. … 978
Get mouse position. Importance: Middle. … 981
Mouse move. Importance: High. … 984
Move mouse to image. Importance: Middle. … 987
Move mouse to text on screen (OCR) . Importance: High. … 994
Send Mouse Click. Importance: High. … 1004
Send Keys. Importance: High. … 1008
Press/release key. Importance: High. … 1015
Set key state. Importance: High. … 1018
Wait for mouse. Importance: Middle. … 1021
Wait for shortcut key. Importance: High. … 1025
Text Actions. … 1028
Append line to text. Importance: High. … 1028
Get subtext. Importance: High. … 1031
Pad Text. Importance: High. … 1034
Trim Text. Importance: High. … 1037
Reverse text. Importance: Middle. … 1039
Change text case. Importance: High. … 1041
Convert text to number. Importance: Low. … 1044
Convert number to text. Importance: High. … 1047
Convert text to datetime. Importance: Middle. … 1050
Convert datetime to text. Importance: High. … 1053
Create random text. Importance: Middle. … 1057
Join Text. Importance: High. … 1060
Split text. Importance: High. … 1063
Parse text. Importance: High. … 1068
Replace text. Importance: Middle. … 1072
Escape text for regular expression. Importance: Middle. … 1076
Date time Actions. … 1079
Add to datetime. Importance: High. … 1079
Subtract dates. Importance: High. … 1082
Get current date and time. Importance: High. … 1085
Create HTML content … 1089
PDF Actions. … 1095
Extract text from PDF. Importance: High. … 1095
Extract tables from PDF. Importance: High. … 1099
Extract images from PDF. Importance: Middle. … 1102
Extract PDF file pages to new PDF. Importance: Middle. … 1105
Merge PDF files. Importance: Middle. … 1108
OCR Actions. … 1111
If text on screen (OCR) . Importance: Middle. … 1111
Wait for text on screen (OCR) . Importance: High. … 1118
Extract text with OCR. Importance: Middle. … 1125
Windows services Actions. … 1131
If service. Importance: Low. … 1131
Wait for service. Importance: Low. … 1135
Start service. Importance: Low. … 1138
Stop service. Importance: Low. … 1140
Pause service. Importance: Low. … 1142
Resume service. Importance: Low. … 1144
Tips - Text … 1146
How to use line breaks in expressions. … 1146
How to use tab characters. … 1148
How to extract only numbers from text (keep only numbers). … 1150
How to remove numbers from text. … 1152
How to remove text, from the left or right, by specifying the number of characters. … 1154
How to leave text with a specified number of characters from the left or right. … 1158
How to extract characters before, after, or between specific text. … 1162
Tips - Numeric … 1171
Obtain the number, total, average, maximum, and minimum of the numbers in the list. … 1171
Methods for round down, round up, and round off small number values. … 1184
How to judge even/odd numbers. … 1186
How to get absolute values. … 1188
How to get the quotient and remainder of a division. … 1190
Tips - Conditional branch … 1192
How to set IF conditions in Or and And. … 1192
How to get the earlier or later date.Date and time comparison. … 1193
Tips - Date and Time … 1194
How to truncate the time portion from the date and time … 1194
How to get the Previous day, First day of month, End of month, and Number of days in month. … 1195
How to get the day of the week from a date. … 1202
Tips - Microsoft Excel … 1204
How to value paste value in Excel. … 1204
How to get the last row and last column of an Excel book. … 1207
Create a table of contents for sheet names in an Excel book. … 1210
Move to the specified cell in the Excel book. … 1219
Delete rows of Excel with specific conditions. … 1225
Insert empty rows in Excel worksheet, one row at a time. … 1234
How to open Excel in the background. … 1240
How to delete multiple rows/columns in Excel. … 1241
Excel cell format. … 1254
Excel Filter … 1258
How to read an Excel file and process it line by line in a loop. … 1267
Tips - Microsoft Excel - Use Excel to perform calculations efficiently – Text … 1272
How to convert between Roman numerals and Arabic numerals. … 1272
Tips - Microsoft Excel - Use Excel to perform calculations efficiently – Numeric … 1277
How to rank a list of numbers. … 1277
How to get the median. … 1287
How to get the mode. … 1294
How to get the deviation. … 1301
How to get the standard deviation. … 1311
How to get the least common multiple and greatest common divisor. … 1318
Tips - Microsoft Excel - Use Excel to perform calculations efficiently - Date and Time … 1329
How to get the last business day of the specified month. … 1329
How to get the number of business days for a specify month. … 1335
How to get the number of business days within a specified period. … 1340
Tips - File / Folder … 1347
What to do if the specified file does not exist. … 1347
How to deal with the case where the specified file already exists. … 1352
How to convert CSV files to Excel files. … 1358
How to convert Excel files to CSV files. … 1362
How to put today’s date in a folder name or file name. … 1369
How to save the contents of a PDF to a text file. … 1373
How to convert Excel and PDF files to each other. … 1374
Tips – E-mail … 1383
Sending and receiving Gmail … 1383
Send newsletter. Email one line at a time from an Excel book. … 1388
How to record the contents of an incoming email line by line in an Excel book. … 1394
Specify date range to retrieve mail. … 1400
How to save email attachments to a specific folder. … 1404
Tips – URL … 1416
URL encode/decode. … 1416
How to send e-mail to multiple addressees. … 1419
How to leave only the GET parameter from the URL. … 1420
How to convert URL parameters (GET parameters) into Data table. … 1429
How to remove URL parameters. … 1443
Tips - Other … 1447
How to use ChatGPT. … 1447
How to get the number of items in a List (array). … 1452
Data type … 1453
Data type:Datatime … 1453
Data type:Mail Message … 1455
Data type:Outlook Mail Message … 1456
Data type:File … 1456
Data type:Folder … 1459
Others … 1461
How to get an API key (secret key) for ChatGPT. … 1461
General URL rules. … 1465