Compartilhar via


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
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   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)
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)
Contact
Name Power Assist Support
URL https://elevate-digital.com/powerassistsupport/
Email 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

  1. 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.
  2. 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.
  3. 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.
  4. Enter your card information, if applicable.
  5. 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

  1. In the Power Automate portal, create a new flow or edit an existing one.
  2. Add a new action to your flow and in the "Choose an operation" menu, search for "Power Assist" under the Premium tab.
  3. Select your preferred action.
  4. 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.
  5. 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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
email True string

email

Returns

Name Path Type Description
Result
Result boolean

Result