Table of Contents. Power Automate Desktop(Books)

09/18/2024

Amazon Kindle.

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