Partager via

Apptigent PowerTools LITE

  • Reference

Apptigent PowerTools LITE (Community Edition) is a FREE suite of essential utilities for enterprise workflow, forms and cloud applications. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, and more. PowerTools is the ultimate power user toolkit - FREE!

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 Customer Support
URL https://www.apptigent.com/help/
Email support@apptigent.com
Connector Metadata
Publisher Apptigent Limited
Website https://www.apptigent.com
Privacy policy https://www.apptigent.com/help/privacy-policy/
Categories Productivity;Business Management

Create user-driven solutions that solve everyday business problems in a fraction of the time with the ultimate FREE power user toolkit. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, and more in just a few clicks. No need to learn complex formulas or expression syntax, PowerTools takes care of all the heavy lifting so users can be instantly more productive. With a powerful toolkit of advanced capabilities at their disposal, every user in the organization will have the ability to deliver outstanding results.

Prerequisites

Create an account and subscribe to PowerTools Community Edition. It's completely free! Learn more at https://portal.apptigent.com/start.

How to get credentials

Generate an API key by following these simple steps:

  1. Open https://portal.apptigent.com in your browser, click "Create an account" and follow the prompts.
  2. Login with your new credentials and select the "Apps" link from the main menu.
  3. Click the "Create new App" button.
  4. Enter a Title and optional description (such as "Power Automate App") then click "Submit".
  5. On successful submission, the App details page will be shown with your new credentials. Click the "Show" checkbox next to the Client ID field and copy the value - this is the key you will use in the "API Key" field to authorize a new connector.
  6. Browse to "API Products", select "PowerTools LITE (Community Edition)", then click Subscribe under the Default plan.
  7. Select the app name created in Step 4 and click "Subscribe" to finish.

Known issues and limitations

The Community Edition plan includes 50 free action calls per day. Visit our Subscriptions page at https://www.apptigent.com/solutions/power-tools/subscription-plans/ to learn more about plans with higher limits and advanced capabilities.

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
API Key securestring PowerTools LITE (Community Edition) License Key True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Collections - Add to collection

Add an item to a collection
Collections - Contains number

Determine if a collection contains a specific number
Collections - Contains string

Determine if any items in a collection contain a specific string
Collections - Count collection

Count a collection of items
Collections - Ends with string

Determine if any items in a collection end with a specific string
Collections - Filter collection

Filter a collection of strings by keyword
Collections - Remove duplicates from collection

Remove duplicate items from a collection
Collections - Remove from collection

Remove an item from a collection
Collections - Replace values in collection

Replace whole or partial strings in a collection
Collections - Sort collection

Sort a collection of strings
Collections - Split collection

Split a collection of items by matching value or index
Collections - Starts with string

Determine if any items in a collection start with a specific string
DateTime - DateTime difference

Calculate the difference between two dates
DateTime - Format date and time

Create a date/time string in a specific format
DateTime - Get world time

Convert date and time from one time zone to another
Math - Calculate Absolute

Calculate the absolute value of a number
Math - Calculate Addition

Calculate the sum of two numbers
Math - Calculate average

Calculate the average of two or more numbers
Math - Calculate Cosine

Calculate the cosine value of an angle
Math - Calculate Division

Calculate the quotient of two numbers
Math - Calculate Logarithm

Calculate the logarithm of a number
Math - Calculate median

Calculate the median of two or more numbers
Math - Calculate minimum or maximum

Calculate the minimum or maximum value in a sequence of numbers
Math - Calculate Modulo

Calculate the remainder of dividing two numbers
Math - Calculate Multiplication

Calculate the product of two numbers
Math - Calculate Nth Root

Calculate the n-th root of a number
Math - Calculate power

Raise number to a specified power
Math - Calculate Sine

Calculate the sine value of an angle
Math - Calculate Square Root

Calculate the square root of a number
Math - Calculate standard deviation

Calculate the standard deviation of two or more numbers
Math - Calculate Subtraction

Calculate the difference between two numbers
Math - Calculate sum

Calculate the sum of two or more numbers
Math - Calculate Tangent

Calculate the tangent value of an angle
Math - Calculate variance

Calculate the statistical variance of two or more numbers
Math - Convert angle

Convert value from one angle measurement to another
Math - Convert area

Convert value from one area measurement to another
Math - Convert distance

Convert value from one distance measurement to another
Math - Convert duration

Convert value from one duration measurement to another
Math - Convert energy

Convert value from one energy measurement to another
Math - Convert power

Convert value from one power measurement to another
Math - Convert speed

Convert value from one speed measurement to another
Math - Convert temperature

Convert value from one temperature measurement to another
Math - Convert volume

Convert value from one volume measurement to another
Math - Convert weight

Convert value from one weight measurement to another
Math - Random number

Generate a random number within a specified range
Math - Round number

Round a numeric value up or down
Text - Compare strings

Perform a comparison of two strings
Text - Contains string

Determine if a string contains another string
Text - Convert case

Convert string to upper, lower or title case
Text - Decode string

Decode a string encoded with Base64 encoding
Text - Decode URL

Decode an encoded URL
Text - Encode string

Encode a string using Base64 encoding
Text - Encode URL

Generate an encoded string from a complex hyperlink
Text - Generate GUID

Generate a globally unique identifier
Text - Join strings

Join a collection of strings
Text - Redact string

Redact a strng containing sensitive content
Text - Replace string

Replace one value with another in a string
Text - Split string

Split a string based upon one or more characters
Text - Trim string

Trim leading or trailing whitespace from a string

Collections - Add to collection

Operation ID:
AddToCollection

Add an item to a collection

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of values or objects to modify
Item
 item string

Item (for multiple items, leave blank and use Items)
Items
 items array of string

Items (Collection, for a single item leave blank and use Item)
Index
 index string

Index position for operation (leave blank to specify end of collection)

Returns

Body
outputCollectionResult

Collections - Contains number

Operation ID:
CollectionContainsNumber

Determine if a collection contains a specific number

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of strings to search
Number
 match True number

Number to match
Number Type
 type string

Type of number - integer or decimal

Returns

Body
outputCollectionNumber

Collections - Contains string

Operation ID:
CollectionContainsString

Determine if any items in a collection contain a specific string

Parameters

Name Key Required Type Description
Values
 input True array of string

Collection of strings to search
Text
 match True string

Text to match
Trim
 trim string

Trim white space from comparison string
Ignore Case
 ignorecase string

Ignore case when performing comparison

Returns

Body
outputCollectionString

Collections - Count collection

Operation ID:
CountCollection

Count a collection of items

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of items to count

Returns

Body
outputNumber

Collections - Ends with string

Operation ID:
CollectionEndsWithString

Determine if any items in a collection end with a specific string

Parameters

Name Key Required Type Description
Values
 input True array of string

Collection of strings to search
Text
 match True string

Text to match
Trim
 trim string

Trim white space from comparison string
Ignore Case
 ignorecase string

Ignore case when performing comparison

Returns

Body
outputCollectionString

Collections - Filter collection

Operation ID:
FilterCollection

Filter a collection of strings by keyword

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of strings to filter
Match
 match True string

Match type
Keywords
 keywords True string

Keywords (separate multiple values with commas)

Returns

Body
outputCollectionResult

Collections - Remove duplicates from collection

Operation ID:
RemoveDuplicates

Remove duplicate items from a collection

Parameters

Name Key Required Type Description
Collection
 Collection object

Returns

Body
outputCollectionResult

Collections - Remove from collection

Operation ID:
RemoveFromCollection

Remove an item from a collection

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of values or objects to modify
Item
 item string

Item (for multiple items, leave blank and use Items)
Items
 items array of string

Items (Collection, for a single item leave blank and use Item)
Index
 index string

Index position for operation (leave blank to specify end of collection)

Returns

Body
outputCollectionResult

Collections - Replace values in collection

Operation ID:
ReplaceValuesInCollection

Replace whole or partial strings in a collection

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of strings
Match value
 match True string

Match value
Replacement value
 replacement True string

Replacement value
Ignore case
 ignoreCase True string

Ignore case

Returns

Body
outputCollectionResult

Collections - Sort collection

Operation ID:
SortCollection

Sort a collection of strings

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of strings to sort
Order
 order True string

Sort order

Returns

Body
outputCollectionResult

Collections - Split collection

Operation ID:
SplitCollection

Split a collection of items by matching value or index

Parameters

Name Key Required Type Description
Collection
 input True array of string

Collection of items to split
Match Value
 match string

String to match (explicit, case-insensitive, leave empty to use Index)
Index
 index string

Index location to split (leave empty to use Match value)

Returns

Body
outputMultiCollection

Collections - Starts with string

Operation ID:
CollectionStartsWithString

Determine if any items in a collection start with a specific string

Parameters

Name Key Required Type Description
Values
 input True array of string

Collection of strings to search
Text
 match True string

Text to match
Trim
 trim string

Trim white space from comparison string
Ignore Case
 ignorecase string

Ignore case when performing comparison

Returns

Body
outputCollectionString

DateTime - DateTime difference

Operation ID:
DateTimeDifference

Calculate the difference between two dates

Parameters

Name Key Required Type Description
First date/time value
 dateTime1 True string

First date/time value
Second date/time value
 dateTime2 True string

Second date/time value

Returns

Body
outputDateDifference

DateTime - Format date and time

Operation ID:
FormatDateTime

Create a date/time string in a specific format

Parameters

Name Key Required Type Description
Value
 input True string

Source date and time
Culture
 culture True string

Language culture
Format
 format True string

Output format

Returns

Body
outputString

DateTime - Get world time

Operation ID:
WorldTime

Convert date and time from one time zone to another

Parameters

Name Key Required Type Description
Value
 input True string

Source date and time
Source Time Zone
 source True string
Target Time Zone
 target True string
Format
 format string

Display format (defaults to 'yyyy-MM-dd HH:mm:ss')

Returns

Body
outputString

Math - Calculate Absolute

Operation ID:
CalculateAbsolute

Calculate the absolute value of a number

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Addition

Operation ID:
CalculateAddition

Calculate the sum of two numbers

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate average

Operation ID:
CalculateAverage

Calculate the average of two or more numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Cosine

Operation ID:
CalculateCosine

Calculate the cosine value of an angle

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Division

Operation ID:
CalculateDivision

Calculate the quotient of two numbers

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Logarithm

Operation ID:
CalculateLogarithm

Calculate the logarithm of a number

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate median

Operation ID:
CalculateMedian

Calculate the median of two or more numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate minimum or maximum

Operation ID:
CalculateMinMax

Calculate the minimum or maximum value in a sequence of numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Min or Max
 type True string

Minimum or Maximum

Returns

Body
outputNumber

Math - Calculate Modulo

Operation ID:
CalculateModulo

Calculate the remainder of dividing two numbers

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Multiplication

Operation ID:
CalculateMultiplication

Calculate the product of two numbers

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Nth Root

Operation ID:
CalculateNthRoot

Calculate the n-th root of a number

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate power

Operation ID:
CalculatePower

Raise number to a specified power

Parameters

Name Key Required Type Description
Number
 input True number

Number to raise
Power
 power True number

Power
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Sine

Operation ID:
CalculateSine

Calculate the sine value of an angle

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Square Root

Operation ID:
CalculateSquareRoot

Calculate the square root of a number

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate standard deviation

Operation ID:
StandardDeviation

Calculate the standard deviation of two or more numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Subtraction

Operation ID:
CalculateSubtraction

Calculate the difference between two numbers

Parameters

Name Key Required Type Description
Primary Value
 input True number

Numeric value
Secondary Value
 value True number

Addend, subtrahend, factor, divisor or radicand
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate sum

Operation ID:
CalculateSum

Calculate the sum of two or more numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate Tangent

Operation ID:
CalculateTangent

Calculate the tangent value of an angle

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Calculate variance

Operation ID:
CalculateVariance

Calculate the statistical variance of two or more numbers

Parameters

Name Key Required Type Description
Values
 input True array of number

Collection of values to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Math - Convert angle

Operation ID:
ConvertAngle

Convert value from one angle measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert area

Operation ID:
ConvertArea

Convert value from one area measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert distance

Operation ID:
ConvertDistance

Convert value from one distance measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert duration

Operation ID:
ConvertDuration

Convert value from one duration measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert energy

Operation ID:
ConvertEnergy

Convert value from one energy measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert power

Operation ID:
ConvertPower

Convert value from one power measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert speed

Operation ID:
ConvertSpeed

Convert value from one speed measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert temperature

Operation ID:
ConvertTemperature

Convert value from one temperature measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert volume

Operation ID:
ConvertVolume

Convert value from one volume measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Convert weight

Operation ID:
ConvertWeight

Convert value from one weight measurement to another

Parameters

Name Key Required Type Description
Measurement value
 input True number
Source measurement
 source True string
Target measurement
 target True string

Returns

Body
outputNumber

Math - Random number

Operation ID:
RandomNumber

Generate a random number within a specified range

Parameters

Name Key Required Type Description
Start
 start True number

Start of range
End
 end True number

End of range

Returns

Body
outputNumber

Math - Round number

Operation ID:
RoundNumber

Round a numeric value up or down

Parameters

Name Key Required Type Description
Value
 input True number

Numeric value to calculate
Decimal Places
 decimals True number

Round to number of decimal places

Returns

Body
outputNumber

Text - Compare strings

Operation ID:
CompareStrings

Perform a comparison of two strings

Parameters

Name Key Required Type Description
Source
 input True string

Original string
Target
 compare True string

Comparison string
Lowercase
 lower True string

Convert strings to lowercase before comparison
Trim
 trim True string

Trim strings before comparison

Returns

Body
outputString

Text - Contains string

Operation ID:
ContainsString

Determine if a string contains another string

Parameters

Name Key Required Type Description
Value
 find True string

Text to match
Target
 input True string

Text to search
Lowercase
 lower True string

Convert strings to lowercase

Returns

Body
outputString

Text - Convert case

Operation ID:
ConvertCase

Convert string to upper, lower or title case

Parameters

Name Key Required Type Description
Value
 input True string

String containing the text to convert
Case
 alphacase True string

Case of conversion result

Returns

Body
outputString

Text - Decode string

Operation ID:
DecodeString

Decode a string encoded with Base64 encoding

Parameters

Name Key Required Type Description
Source
 source True string

string variable or text value

Returns

Body
outputString

Text - Decode URL

Operation ID:
UrlDecode

Decode an encoded URL

Parameters

Name Key Required Type Description
Source
 source True string

String variable or text value

Returns

Body
outputString

Text - Encode string

Operation ID:
EncodeString

Encode a string using Base64 encoding

Parameters

Name Key Required Type Description
Source
 source True string

String variable or text value

Returns

Body
outputString

Text - Encode URL

Operation ID:
UrlEncode

Generate an encoded string from a complex hyperlink

Parameters

Name Key Required Type Description
Source
 source True string

String variable or text value

Returns

Body
outputString

Text - Generate GUID

Operation ID:
GenerateGuid

Generate a globally unique identifier

Parameters

Name Key Required Type Description
Uppercase
 uppercase True string

All uppercase alpha characters

Returns

Body
outputString

Text - Join strings

Operation ID:
JoinStrings

Join a collection of strings

Parameters

Name Key Required Type Description
Values
 input True array of string

Collection of strings to be joined
Separator
 separator True string

Separator character
Lowercase
 lower True string

Convert strings in collection to lowercase
Trim
 trim True string

Trim strings in collection

Returns

Body
outputString

Text - Redact string

Operation ID:
RedactString

Redact a strng containing sensitive content

Parameters

Name Key Required Type Description
Source String
 source True string

String containing the complete text
Value
 value string

Individual string to redact
-OR- Values Collection
 values array of string

Collection of strings to redact
-OR- Regular Expression
 regex string

Regular expression pattern for matching strings

Returns

Body
outputString

Text - Replace string

Operation ID:
ReplaceString

Replace one value with another in a string

Parameters

Name Key Required Type Description
Source
 source True string

String containing the text to be replaced
Value
 value True string

Text to replace
Replacement
 replacement True string

Replacement text

Returns

Body
outputString

Text - Split string

Operation ID:
SplitString

Split a string based upon one or more characters

Parameters

Name Key Required Type Description
Value
 input True string

Text to split
Character(s)
 characters True string

One or more characters that will be used to split the text

Returns

Body
outputStringArray

Text - Trim string

Operation ID:
TrimString

Trim leading or trailing whitespace from a string

Parameters

Name Key Required Type Description
Source
 source True string

String containing the text to be trimmed
Type
 type True string

Type of white space to remove

Returns

Body
outputString

Definitions

outputStringArray

Name Path Type Description
data
 data array of string

data

outputDateDifference

Name Path Type Description
Years
 years number

Years
Months
 months number

Months
Days
 days number

Days
Hours
 hours number

Hours
Minutes
 minutes number

Minutes
Milliseconds
 milliseconds number

Milliseconds
Total Years
 totalYears double

Total Years
Total Months
 totalMonths double

Total Months
Total Days
 totalDays double

Total Days
Total Hours
 totalHours double

Total Hours
Total Minutes
 totalMinutes double

Total Minutes
Total Seconds
 totalSeconds double

Total Seconds
Total Milliseconds
 totalMilliseconds double

Total Milliseconds
Ticks
 ticks number

Ticks

outputCollectionNumber

Name Path Type Description
Success
 status boolean

Success
First Value
 item number

First Value
All Values
 items array of number

All Values

outputCollectionResult

Name Path Type Description
Modified collection result
 result array of string

Modified collection result

outputCollectionString

Name Path Type Description
Success
 status boolean

Success
First Value
 item string

First Value
All Values
 items array of string

All Values

outputMultiCollection

Name Path Type Description
First collection result
 result1 array of string

First collection result
Second collection result
 result2 array of string

Second collection result

outputString

Name Path Type Description
Result
 result string

Result

outputNumber

Name Path Type Description
Result
 result number

Result