REPT
Use the REPT function to generate a text value containing a specified number of repetitions of a given text.
Use
REPT( text, number_times )
Repeats text a given number of times.
| Parameter | Required | Description |
|---|---|---|
| text | Yes | the text to repeat |
| number_times | Yes | the number of times to repeat text |
| Returns | Text |
Examples
Visual Progress or Priority Indicators
You can use REPT in an Input Mapping formula to convert a numeric priority level into a visual indicator that is easier for an approver to recognize in their Inbox.
- Scenario: A "Help Desk" trigger form captures a "Urgency" level as a number from 1 to 5. You want to display this to the technician as a series of red exclamation marks.
- Formula:
REPT("!", @Trigger.out.UrgencyLevel) - Logic:
"!": The text to be repeated.@Trigger.out.UrgencyLevel: The numeric value provided by the user.
- Outcome: If the user selects an urgency of 4, the technician will see "!!!!" on their review form. This provides immediate visual context without the technician having to interpret a raw number.
Standardizing Data for Reports
You can use REPT in a Variable Update formula or a Reporting Connector to create consistent visual separators or padding for exported data.
- Scenario: You are using a Reporting Connector to export a "Summary Log" variable to Excel. You want each log entry to be clearly separated by a dashed line of a fixed length.
- Formula:
CONCAT($CurrentLog, REPT("-", 20), @Activity.out.NewEntry) - Logic:
REPT("-", 20): This generates exactly 20 dashes ("--------------------").CONCAT(...): This joins the existing log, the repeated dashes, and the new entry into one continuous text string.
- Outcome: Every time a new entry is added, a perfectly uniform separator is added, ensuring the final report is professional and easy to read.