Entering the TAB key for a parameter in Power Automate Desktop is treated as an invalid value and cannot be entered.
This article shows you how to work around it.
Steps
How to use Replace text Action
Set up Replace text and set the parameters as follows
| Parameter | Set value. | Remarks |
|---|---|---|
| Text to parse | A | Specify the same characters as "Text to find". |
| Text to find | A | Specify the same characters as "Text to parse". |
| Replase with | \t | |
| Activate escape sequences | ON |
Robin(for copy and paste). It can be copied and pasted into Power Automate Desktop.
Text.Replace Text: $'''A''' TextToFind: $'''A''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''\\t''' ActivateEscapeSequences: True Result=> Replaced
Executing this action will set the tab character to %Replaced% in the Variables produced.
It is recommended to rename this variable to something like %Tab% for clarity.
By using this variable as a parameter, the tab character can be used.
How to read from a file
Prepare a file with only one tab character, Read the file with Read text from file.
Executing this action will set the tab character to %FileContents% in the Variables produced.
It is recommended to rename this variable to something like %Tab% for clarity.
By using this variable as a parameter, the tab character can be used.
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.