共用方式為


Apptigent PowerTools LITE

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

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

Collections - Contains number

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

Collections - Contains string

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

Collections - Count collection

Count a collection of items

Parameters

Name Key Required Type Description
Collection
input True array of string

Collection of items to count

Returns

Collections - Ends with string

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

Collections - Filter collection

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

Collections - Remove duplicates from collection

Remove duplicate items from a collection

Parameters

Name Key Required Type Description
Collection
Collection object

Returns

Collections - Remove from collection

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

Collections - Replace values in collection

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

Collections - Sort collection

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

Collections - Split collection

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

Collections - Starts with string

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

DateTime - DateTime difference

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

DateTime - Format date and time

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

DateTime - Get world time

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

Math - Calculate Absolute

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

Math - Calculate Addition

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

Math - Calculate average

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

Math - Calculate Cosine

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

Math - Calculate Division

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

Math - Calculate Logarithm

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

Math - Calculate median

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

Math - Calculate minimum or maximum

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

Math - Calculate Modulo

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

Math - Calculate Multiplication

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

Math - Calculate Nth Root

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

Math - Calculate power

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

Math - Calculate Sine

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

Math - Calculate Square Root

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

Math - Calculate standard deviation

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

Math - Calculate Subtraction

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

Math - Calculate sum

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

Math - Calculate Tangent

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

Math - Calculate variance

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

Math - Convert angle

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

Math - Convert area

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

Math - Convert distance

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

Math - Convert duration

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

Math - Convert energy

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

Math - Convert power

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

Math - Convert speed

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

Math - Convert temperature

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

Math - Convert volume

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

Math - Convert weight

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

Math - Random number

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

Math - Round number

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

Text - Compare strings

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

Text - Contains string

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

Text - Convert case

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

Text - Decode string

Decode a string encoded with Base64 encoding

Parameters

Name Key Required Type Description
Source
source True string

string variable or text value

Returns

Text - Decode URL

Decode an encoded URL

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Encode string

Encode a string using Base64 encoding

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Encode URL

Generate an encoded string from a complex hyperlink

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Generate GUID

Generate a globally unique identifier

Parameters

Name Key Required Type Description
Uppercase
uppercase True string

All uppercase alpha characters

Returns

Text - Join strings

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

Text - Redact string

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

Text - Replace string

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

Text - Split string

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

Text - Trim string

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

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