# Tips(Power Automate Desktop)

Contents

- 1. Tips
- 1.1. Text
- 1.1.1. How to use line breaks in expressions.
- 1.1.2. How to use tab characters.
- 1.1.3. How to extract only numbers from text (keep only numbers).
- 1.1.4. How to remove numbers from text.
- 1.1.5. How to remove text, from the left or right, by specifying the number of characters.
- 1.1.6. How to leave text with a specified number of characters from the left or right.
- 1.1.7. How to extract characters before, after, or between specific text.

- 1.2. Numeric
- 1.3. Conditional branch
- 1.4. Date and Time
- 1.5. Microsoft Excel
- 1.5.1. How to value paste value in Excel.
- 1.5.2. How to get the last row and last column of an Excel book.
- 1.5.3. Create a table of contents for sheet names in an Excel book.
- 1.5.4. Move to the specified cell in the Excel book.
- 1.5.5. Delete rows of Excel with specific conditions.
- 1.5.6. Insert empty rows in Excel worksheet, one row at a time.
- 1.5.7. How to open Excel in the background.
- 1.5.8. How to delete multiple rows/columns in Excel.
- 1.5.9. Excel cell format.
- 1.5.10. Excel Filter
- 1.5.11. How to read an Excel file and process it line by line in a loop.
- 1.5.12. Use Excel to perform calculations efficiently
- 1.5.13. How to rank a list of numbers.

- 1.6. File / Folder
- 1.6.1. What to do if the specified file does not exist.
- 1.6.2. How to deal with the case where the specified file already exists.
- 1.6.3. How to convert CSV files to Excel files.
- 1.6.4. How to convert Excel files to CSV files.
- 1.6.5. How to put today’s date in a folder name or file name.
- 1.6.6. How to convert Excel and PDF files to each other.
- 1.6.7. How to save the contents of a PDF to a text file.

- 1.7. Web Browser
- 1.8. E-mail
- 1.9. URL
- 1.10. Other

- 1.1. Text
- 2. For those who want to learn Power Automate Desktop effectively

## Tips

### Text

#### How to use line breaks in expressions.

#### How to use tab characters.

#### How to extract only numbers from text (keep only numbers).

#### How to remove numbers from text.

#### How to remove text, from the left or right, by specifying the number of characters.

#### How to leave text with a specified number of characters from the left or right.

#### How to extract characters before, after, or between specific text.

### Numeric

#### Obtain the number, total, average, maximum, and minimum of the numbers in the list.

#### Methods for round down, round up, and round off small number values.

#### How to judge even/odd numbers.

#### How to get absolute values.

#### How to get the quotient and remainder of a division.

### Conditional branch

#### How to set IF conditions in Or and And.

#### How to get the earlier or later date.Date and time comparison.

### Date and Time

#### How to truncate the time portion from the date and time

#### How to get the Previous day, First day of month, End of month, and Number of days in month.

#### How to get the day of the week from a date.

### Microsoft Excel

#### How to value paste value in Excel.

#### How to get the last row and last column of an Excel book.

#### Create a table of contents for sheet names in an Excel book.

#### Move to the specified cell in the Excel book.

#### Delete rows of Excel with specific conditions.

#### Insert empty rows in Excel worksheet, one row at a time.

#### How to open Excel in the background.

#### How to delete multiple rows/columns in Excel.

#### Excel cell format.

#### Excel Filter

#### How to read an Excel file and process it line by line in a loop.

#### Use Excel to perform calculations efficiently

##### Text

###### How to convert between Roman numerals and Arabic numerals.

##### Numeric

###### How to rank a list of numbers.

###### How to get the median.

###### How to get the mode.

###### How to get the deviation.

###### How to get the standard deviation.

###### How to get the least common multiple and greatest common divisor.

#### How to rank a list of numbers.

##### Date and Time

###### How to get the last business day of the specified month.

###### How to get the number of business days for a specify month.

###### How to get the number of business days within a specified period.

### File / Folder

#### What to do if the specified file does not exist.

#### How to deal with the case where the specified file already exists.

#### How to convert CSV files to Excel files.

#### How to convert Excel files to CSV files.

#### How to put today's date in a folder name or file name.

#### How to convert Excel and PDF files to each other.

#### How to save the contents of a PDF to a text file.

### Web Browser

#### Example of simple web browser auto-operation: auto-filling a web form.

#### Sending and receiving Gmail

#### Send newsletter. Email one line at a time from an Excel book.

#### How to record the contents of an incoming email line by line in an Excel book.

#### Specify date range to retrieve mail.

#### How to save email attachments to a specific folder.

### URL

#### URL encode/decode

#### How to send e-mail to multiple addressees.

#### How to leave only the GET parameter from the URL.

#### How to convert URL parameters (GET parameters) into Data table.

#### How to remove URL parameters.

### Other

#### How to use ChatGPT.

#### How to get the number of items in a List (array).

## For those who want to learn Power Automate Desktop effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.