Power Assist (Preview)

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	[email protected]

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

Array - Group By

Calculate Average (Arithmetic Mean) from an Array of Numbers

Calculate Median from an Array of Numbers

Calculate Mode (most frequently occurring number) from an Array of Numbers

Capitalize String - set first character to upper case

Check that a Value is a Number

Check that a Value is a String

Check that a Value is an Array

Check that a Value is an Object

Check that a Value is Null or Empty

Check whether Any of the Items in an Array meet a condition

Check whether Every item in an Array meets a condition

Chop a String - break a string into an array of strings of specified length

Clean a String - trim and replace multiple spaces with a single space

Clean Diacritics from a String

Count Instances of a Substring in a String

Count Words in String by Specified Delimiter or RegEx

Escape HTML in a String

Filter Array

Generate a Random Number

Prepend to Array

Remove First from Array

Reverse Array

Round Down Number (aka Math.floor)

Round Number

Round Up Number (aka Math.ceil)

Slugify String - transform text into an ASCII slug which can be used in URLs

Sort Array

Sort Array of Objects by Property

Split String into Array by Delimiter or RegEx

String RegEx Replace - replace values in a string using a Regular Expression

String Replace All - Replace all instances of a substring

Strip HTML out of a String

Trim End of String

Trim Start of String

Trim String - remove characters from the start and end of a string

Unescape HTML in a String

Validate a String based on RegEx

Validate Email - check that a String is in the common email format