Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Power Assist (Preview)
Power Assist provides a wide variety of utility and data manipulation actions to accelerate and empower your Power Platform development.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Copilot Studio | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Power Assist Support |
| URL | https://elevate-digital.com/powerassistsupport/ |
| powerassistsupport@elevate-digital.com |
| Connector Metadata | |
|---|---|
| Publisher | Elevate Digital |
| Website | https://elevate-digital.com/powerassist/ |
| Privacy Policy | https://elevate-digital.com/privacy-policy/ |
| Categories | Data;Productivity |
Power Assist empowers you and your organization's citizen developers to solve business problems faster than ever with the Power Platform. Whether you need to quickly sort an Array, perform advanced filtering, make mathematical calculations, execute a Regular Expression on a string, escape HTML, check the type of a value, or do one of many more common tasks, Power Assist makes it simple. No more long, complex expressions, convoluted conditionals, and inefficient looping: Use Power Assist to make your Power Automate workflows fast and easy to build.
Prerequisites
You must first create a free RapidAPI account. This is required to be able to authenticate to the API. If you are signing up on behalf of your organization, consider creating an Organization in RapidAPI so that other users at your organization can share access to the API without sharing RapidAPI credentials. See how.
How to get credentials
- Go to the Power Assist API and ensure you are on the Pricing tab. If you are signing up on behalf of your organization, make sure your organization is selected in the dropdown above the pricing options.
- Subscribe to your desired plan. The Basic plan is FREE and offers access to all endpoints, but has a hard limit of 50 requests per month. The Pro plan is a paid subscription offering access to all endpoints, with a soft limit of 3,000 requests per month.
- Sign in or create your account. If you are signing up on behalf of your organization, consider checking the box to create an Organization in RapidAPI so that other users at your organization can share access to the API, without sharing RapidAPI credentials.
- Enter your card information, if applicable.
- Once you are subscribed, go to the Endpoints tab and locate the X-RapidAPI-Key in the Content Snippet in the right column. Copy this value, as you will need it to authenticate in Power Automate.
Get started with your connector
- In the Power Automate portal, create a new flow or edit an existing one.
- Add a new action to your flow and in the "Choose an operation" menu, search for "Power Assist" under the Premium tab.
- Select your preferred action.
- You will be prompted to supply a Connection name and API Key. Enter a memorable name of your choice for the name. For the API Key, paste the value that you copied from the X-RapidAPI-Key earlier. This Connection will be saved by Power Automate, and available for use in future flows.
- That's it! You can now use Power Assist actions in all your Power Automate flows.
Known issues and limitations
There are no known issues specific to Power Assist at this time.
If you sign up for the free Basic plan on RapidAPI, there is a hard limit of 50 requests per month using that API Key. That means if you make more than 50 requests in a given month, you will receive an HTTP Error response on subsequent requests until the first day of the next month.
Under the Pro plan, there is a soft limit of 3,000 requests per month. That means if you make more than 3,000 requests in a given month, you will be charged a small fee of $0.05 per request on each request above the 3,000 threshold, until the first day of the next month.
Common errors and remedies
HTTP 400 If you receive a 400 "Bad Request" HTTP response and a message that indicates a validation issue, it indicates that there is an issue with the parameters passed to the Action. Check that you are providing valid inputs for all required parameters.
HTTP 400 - "Bad RegEx pattern detected." If you receive a 400 HTTP response and a variation of this message, it indicates that you need to revise the RegEx Pattern value you passed in for an Action that executes a Regular Expression. Remember to begin and end your RegEx Pattern with forward slashes (/). Optionally, add flags following the last slash. Example 1: /.+/ Example 2: /.+/gi
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| RapidApi Key | securestring | The RapidApi Key. | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Array - Find First |
Get the first item in an Array that meets a specified condition. If no item matches, Null is returned. |
| Array - Group By |
Group an Array of items. Accepts an Array of any data type. Returns an Object with keys that reflect the values of the provided propertyName. Under each key are the items that reflect the value. |
| Calculate Average (Arithmetic Mean) from an Array of Numbers |
Calculates the average (mean) from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. |
| Calculate Median from an Array of Numbers |
Calculates the median from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. |
| Calculate Mode (most frequently occurring number) from an Array of Numbers |
Calculates the mode from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. If multiple instances of the same number are passed in separately as a string and a number, they will be counted as instances of the same number. |
| Capitalize String - set first character to upper case |
Sets the first character of the string to upper case, and all subsequent characters to lower case. |
| Check that a Value is a Number |
Validates that a value is a Number. Numbers inside strings, such as "999" will be evaluated to False unless the "includeNumbersInStrings" parameter is set to True. |
| Check that a Value is a String |
Validates whether a supplied value is of type String. |
| Check that a Value is an Array |
Validate whether a supplied Value is an Array. |
| Check that a Value is an Object |
Validate whether a supplied Value is an Object. Empty Objects will evaluate to True. Arrays and other data types will evaluate to False. |
| Check that a Value is Null or Empty |
Check if value is null or empty. Can be used for Strings, Arrays, or Objects. |
| Check whether Any of the Items in an Array meet a condition |
This action returns True if any of the items in an array match a specified condition; otherwise, it returns False. |
| Check whether Every item in an Array meets a condition |
This action returns True if all of the items in an array match a specified condition; otherwise, it returns False. |
| Chop a String - break a string into an array of strings of specified length |
Chop the string into an Array based on an interval, which defines the size of the pieces. |
| Clean a String - trim and replace multiple spaces with a single space |
Trim and replace multiple spaces with a single space. (This includes whitespace characters like \t and \n.) |
| Clean Diacritics from a String |
Replace all diacritic characters (letters with glyphs) in a string with the closest ASCII equivalents. |
| Count Instances of a Substring in a String |
Get the number of occurrences of a substring within a string. |
| Count Words in String by Specified Delimiter or RegEx |
Count the words in a String by a delimiter (String or RegEx pattern). The delimiter is whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern and optionally append flags. |
| Escape HTML in a String |
Convert HTML special characters, like < and >, to their entity equivalents. This action supports cent, yen, euro, pound, lt, gt, copy, reg, quote, amp, and apos. |
| Filter Array |
Filter an array of any data type based on a specified condition. |
| Generate a Random Number |
Generates a pseudo-random number between the minimum of 0 and the specified maximum (maximum must be 1, 10, 100, 1000, 10000). |
| Prepend to Array |
Given an Array and a Value, this action adds the value as the first item in the Array. If an Array is supplied as the Value, a flat array will be returned with each of the items prepended. |
| Remove First from Array |
Accepts an Array of any data type. Returns an Array with the first Item that matches the specified condition removed. If no Item matches the condition, the entire Array is returned. |
| Reverse Array |
Reverse the order of an array of any data type. |
| Round Down Number (aka Math.floor) |
Rounds a number down to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged. |
| Round Number |
Rounds a number to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged. |
| Round Up Number (aka Math.ceil) |
Rounds a number up to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged. |
| Slugify String - transform text into an ASCII slug which can be used in URLs |
Transform text into an ASCII slug which can be used in safely in URLs. Replaces whitespaces, accentuated, and special characters with a dash. Many non-ascii characters are transformed to similar versions in the ascii character set. |
| Sort Array |
Perform a simple sort on an array of any data type. |
| Sort Array of Objects by Property |
Accepts an Array of Objects and sorts it by the object Property specified. |
| Split String into Array by Delimiter or RegEx |
Split string by delimiter (String or RegEx pattern). The action splits by whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern and optionally append flags. |
| String RegEx Replace - replace values in a string using a Regular Expression |
Find and replace within a String using a RegEx pattern. Include the leading and trailing '/' in your pattern and optionally append flags. If the /g flag is used, it will replace all occurrences. Use the /i flag to make the search ignore case. |
| String Replace All - Replace all instances of a substring |
Is case sensitive. Does not accept RegEx. To use RegEx, see the "String RegEx Replace" action. |
| Strip HTML out of a String |
Remove all HTML and XML tags from a string. |
| Trim End of String |
Trim whitespace (by default) or specified characters from the end of a string. |
| Trim Start of String |
Trim whitespace (the default) or specified characters only at the start of a string. |
| Trim String - remove characters from the start and end of a string |
Trims leading and trailing whitespace (the default) or specified characters from a string. |
| Unescape HTML in a String |
Convert entity characters (such as <) to HTML equivalents. This action supports cent, yen, euro, pound, lt, gt, copy, reg, quote, amp, apos, and nbsp. |
| Validate a String based on RegEx |
Validates that a String against a supplied RegEx pattern. Include the leading and trailing '/' in your RegEx pattern and optionally append flags. |
| Validate Email - check that a String is in the common email format |
Validates that a String matches the common email format. Does NOT send an email. Returns True if it passes; otherwise, False. |
Array - Find First
- Operation ID:
- ArrayFindFirst
Get the first item in an Array that meets a specified condition. If no item matches, Null is returned.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
Use the 'this' keyword if your array consists of simple values (rather than Objects). |
|
Comparison
|
comparison | True | string |
comparison |
|
Value
|
value |
The value to compare against. |
||
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result |
Result |
Array - Group By
- Operation ID:
- ArrayGroupBy
Group an Array of items. Accepts an Array of any data type. Returns an Object with keys that reflect the values of the provided propertyName. Under each key are the items that reflect the value.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
array
|
array | True | array of |
array |
|
Property Name (optional)
|
propertyName | string |
Leave blank if your array consists of simple values (rather than Objects). |
Returns
Calculate Average (Arithmetic Mean) from an Array of Numbers
- Operation ID:
- MathAverage
Calculates the average (mean) from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
numbers
|
numbers | True | array of float |
numbers |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | float |
Result |
Calculate Median from an Array of Numbers
- Operation ID:
- MathMedian
Calculates the median from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
numbers
|
numbers | True | array of |
numbers |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | float |
Result |
Calculate Mode (most frequently occurring number) from an Array of Numbers
- Operation ID:
- MathMode
Calculates the mode from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. If multiple instances of the same number are passed in separately as a string and a number, they will be counted as instances of the same number.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
numbers
|
numbers | True | array of |
numbers |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | float |
Result |
Capitalize String - set first character to upper case
- Operation ID:
- StringCapitalize
Sets the first character of the string to upper case, and all subsequent characters to lower case.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Check that a Value is a Number
- Operation ID:
- TypesIsNumber
Validates that a value is a Number. Numbers inside strings, such as "999" will be evaluated to False unless the "includeNumbersInStrings" parameter is set to True.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value
|
value | True |
The value to check. |
|
|
Include Numbers in Strings?
|
includeNumbersInStrings | True | boolean |
includeNumbersInStrings |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check that a Value is a String
- Operation ID:
- TypesIsString
Validates whether a supplied value is of type String.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value
|
value | True |
The value to check. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check that a Value is an Array
- Operation ID:
- TypesIsArray
Validate whether a supplied Value is an Array.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value
|
value | True |
The value to check. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check that a Value is an Object
- Operation ID:
- TypesIsObject
Validate whether a supplied Value is an Object. Empty Objects will evaluate to True. Arrays and other data types will evaluate to False.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value
|
value | True |
The value to check. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check that a Value is Null or Empty
- Operation ID:
- TypesIsNullOrEmpty
Check if value is null or empty. Can be used for Strings, Arrays, or Objects.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value
|
value | True |
The value to check. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check whether Any of the Items in an Array meet a condition
- Operation ID:
- ArrayAny
This action returns True if any of the items in an array match a specified condition; otherwise, it returns False.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
Use the 'this' keyword if your array consists of simple values (rather than Objects). |
|
Comparison
|
comparison | True | string |
comparison |
|
Value
|
value |
The value to compare against. |
||
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Check whether Every item in an Array meets a condition
- Operation ID:
- ArrayEvery
This action returns True if all of the items in an array match a specified condition; otherwise, it returns False.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
Use the 'this' keyword if your array consists of simple values (rather than Objects). |
|
Comparison
|
comparison | True | string |
comparison |
|
Value
|
value |
The value to compare against. |
||
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Chop a String - break a string into an array of strings of specified length
- Operation ID:
- StringChop
Chop the string into an Array based on an interval, which defines the size of the pieces.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Interval
|
interval | True | integer |
interval |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Clean a String - trim and replace multiple spaces with a single space
- Operation ID:
- StringClean
Trim and replace multiple spaces with a single space. (This includes whitespace characters like \t and \n.)
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Clean Diacritics from a String
- Operation ID:
- StringCleanDiacritics
Replace all diacritic characters (letters with glyphs) in a string with the closest ASCII equivalents.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Count Instances of a Substring in a String
- Operation ID:
- StringCountInstances
Get the number of occurrences of a substring within a string.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Substring
|
substring | True | string |
substring |
|
Ignore Case?
|
ignoreCase | boolean |
ignoreCase |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | integer |
Result |
Count Words in String by Specified Delimiter or RegEx
- Operation ID:
- StringWordCount
Count the words in a String by a delimiter (String or RegEx pattern). The delimiter is whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern and optionally append flags.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Delimiter or RegEx
|
delimiter | string |
If left blank, whitespace is used as the default delimiter. RegEx example: /\d+/g |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | integer |
Result |
Escape HTML in a String
- Operation ID:
- StringEscapeHtml
Convert HTML special characters, like < and >, to their entity equivalents. This action supports cent, yen, euro, pound, lt, gt, copy, reg, quote, amp, and apos.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Filter Array
- Operation ID:
- ArrayFilter
Filter an array of any data type based on a specified condition.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
Use the 'this' keyword if your array consists of simple values (rather than Objects). |
|
Comparison
|
comparison | True | string |
comparison |
|
Value
|
value |
The value to compare against. |
||
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Generate a Random Number
- Operation ID:
- MathRandom
Generates a pseudo-random number between the minimum of 0 and the specified maximum (maximum must be 1, 10, 100, 1000, 10000).
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Maximum
|
maximum | True | integer |
Value must be 1, 10, 100, 1000, or 10000 |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | float |
Result |
Prepend to Array
- Operation ID:
- ArrayPrepend
Given an Array and a Value, this action adds the value as the first item in the Array. If an Array is supplied as the Value, a flat array will be returned with each of the items prepended.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Value
|
value | True |
The Value or Array to prepend |
|
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Remove First from Array
- Operation ID:
- ArrayRemoveFirst
Accepts an Array of any data type. Returns an Array with the first Item that matches the specified condition removed. If no Item matches the condition, the entire Array is returned.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
Use the 'this' keyword if your array consists of simple values (rather than Objects). |
|
Comparison
|
comparison | True | string |
comparison |
|
Value
|
value |
The value to compare against. |
||
|
Value Type
|
valueType | string |
IMPORTANT! Specify the Type of the Value provided above. If blank, the Value will be assumed to be a String. |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Reverse Array
- Operation ID:
- ArrayReverse
Reverse the order of an array of any data type.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
array
|
array | True | array of |
array |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Round Down Number (aka Math.floor)
- Operation ID:
- MathFloor
Rounds a number down to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Number
|
number | True | float |
number |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | integer |
Result |
Round Number
- Operation ID:
- Round
Rounds a number to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Number
|
number | True | float |
number |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | integer |
The rounded number as an integer. |
Round Up Number (aka Math.ceil)
- Operation ID:
- MathCeil
Rounds a number up to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in, it will be returned unchanged.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Number
|
number | True | float |
number |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | integer |
The rounded number as an integer. |
Slugify String - transform text into an ASCII slug which can be used in URLs
- Operation ID:
- StringSlugify
Transform text into an ASCII slug which can be used in safely in URLs. Replaces whitespaces, accentuated, and special characters with a dash. Many non-ascii characters are transformed to similar versions in the ascii character set.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Sort Array
- Operation ID:
- ArraySort
Perform a simple sort on an array of any data type.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
array
|
array | True | array of |
array |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Sort Array of Objects by Property
- Operation ID:
- ArraySortByProperty
Accepts an Array of Objects and sorts it by the object Property specified.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Array
|
array | True | array of |
array |
|
Property Name
|
propertyName | True | string |
propertyName |
|
Descending
|
descending | True | boolean |
Yes/No |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
Split String into Array by Delimiter or RegEx
- Operation ID:
- StringWords
Split string by delimiter (String or RegEx pattern). The action splits by whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern and optionally append flags.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Delimiter or RegEx
|
delimiter | string |
If left blank, whitespace is used as the default delimiter. RegEx example: /\d+/g |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | array of |
Result |
String RegEx Replace - replace values in a string using a Regular Expression
- Operation ID:
- StringRegexReplace
Find and replace within a String using a RegEx pattern. Include the leading and trailing '/' in your pattern and optionally append flags. If the /g flag is used, it will replace all occurrences. Use the /i flag to make the search ignore case.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Source String
|
sourceString | True | string |
sourceString |
|
RegEx Pattern
|
pattern | True | string |
Example: /\d+/gi |
|
Replace Value
|
replaceValue | True | string |
replaceValue |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
String Replace All - Replace all instances of a substring
- Operation ID:
- StringReplaceAll
Is case sensitive. Does not accept RegEx. To use RegEx, see the "String RegEx Replace" action.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Source String
|
sourceString | True | string |
sourceString |
|
Search Value
|
searchValue | True | string |
searchValue |
|
Replace Value
|
replaceValue | True | string |
replaceValue |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Strip HTML out of a String
- Operation ID:
- StringStripHtml
Remove all HTML and XML tags from a string.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Trim End of String
- Operation ID:
- StringTrimEnd
Trim whitespace (by default) or specified characters from the end of a string.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Characters
|
characters | string |
characters |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Trim Start of String
- Operation ID:
- StringTrimStart
Trim whitespace (the default) or specified characters only at the start of a string.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Characters
|
characters | string |
characters |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Trim String - remove characters from the start and end of a string
- Operation ID:
- StringTrim
Trims leading and trailing whitespace (the default) or specified characters from a string.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
Characters
|
characters | string |
characters |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Unescape HTML in a String
- Operation ID:
- StringUnescapeHtml
Convert entity characters (such as <) to HTML equivalents. This action supports cent, yen, euro, pound, lt, gt, copy, reg, quote, amp, apos, and nbsp.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | string |
Result |
Validate a String based on RegEx
- Operation ID:
- ValidateRegex
Validates that a String against a supplied RegEx pattern. Include the leading and trailing '/' in your RegEx pattern and optionally append flags.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
string | True | string |
string |
|
RegEx Pattern
|
pattern | True | string |
Example: /\d+/gi |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |
Validate Email - check that a String is in the common email format
- Operation ID:
- ValidateEmail
Validates that a String matches the common email format. Does NOT send an email. Returns True if it passes; otherwise, False.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
String
|
True | string |
|
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Result
|
Result | boolean |
Result |