Skip to main content

zero Filling and blank filling

Power Automate Desktop, which allows you to do a lot of things you want to do just by dragging and dropping actions, but if you want to process a little data you get, you may not be able to go as expected.

This time, I will explain how to fill the text data and fill the blanks.

Implemented with copy and paste

Copy the following code and paste it on the edit screen of Power Automate Desktop to add the target action.

The first line is a case where the first line fills the top of the numerical data, and the second line fills the end of the string.

Text.Pad Text: 103 PadPosition: Text.PadPosition.Left PaddingText: 0 TotalLength: 10 PaddedText=> PaddedNumber
Text.Pad Text: $'''%'Apple'%''' PadPosition: Text.PadPosition.Right PaddingText: $''' ''' TotalLength: 10 PaddedText=> PaddedText

Operate and implement Power Automate Desktop

  1. From "Search for Action", enter "Pudding text" and set the property as follows.The parameters with exactly the same name are the first and the third of her, but the first data, the third character filled with the third ("0").

    Parameter namevalue
    Padding textTarget strings and variables
    PaddlingSelect the top or the end of the end
    Padding textCharacters that fill the missing number of characters
    Total lengthNumber of characters to fill
  2. When executed, the text that fills the number of characters is returned under the specified conditions.