Microsoft Power Platform Integration​

PowerTools integrates with Microsoft’s Power Platform to deliver a complete workflow utility solution. Users can integrate over 90 pre-built functions into their flows or apps to effortlessly create their own process-automation solutions – without needing specialist coding knowledge or experience.

Build automations that convert currency, perform advanced calculations, translate languages, generate map images, display stock quotes, redact sensitive information and much, much more – with simple drag and drop component tools.

Microsoft Power Platform

What is Microsoft Power Platform?

Microsoft Power Platform is a group of business application development services available within the Microsoft 365 suite.

Organisations of all sizes using Microsoft 365 can access the Power Platform to build better ways to use their business data. They can do this by creating their own flows, apps and reports that take data from different sources and sort, retrieve or transform it in the way they need.

Microsoft developed Power Platform to give businesses of all sizes the ability to build more efficient and valuable ways of using their data, drive better business decisions and outperform their competitors.

What is included in Microsoft Power Platform?​

Microsoft Power Platform is comprised of four separate applications – Power Automate, Power Apps, Power BI, and Power Virtual Agents.

These applications can be used individually or combined to build custom business solutions. Microsoft provides a number of add-ons or “plugins” to enhance the native capabilities of Power Platform, including connections to other Microsoft 365 services such as SharePoint, OneDrive and Teams, along with external connections to services such as Salesforce and SAP.

The entire platform is extensible and open to partner solutions, supporting custom plugins that provide additional functionality beyond what is available “out of the box”. There are hundreds of such connectors, including PowerTools LITE and PowerTools PRO.

How does PowerTools integrate with Microsoft Power Platform?​

The PowerTools plugin integrates with the Power Automate and Power Apps components of Power Platform using the certified connector framework provided by Microsoft.

You can find the PowerTools LITE and PowerTools PRO plugins in the official list of available connectors – https://flow.microsoft.com/en-us/connectors/

What is Power Automate?​

Formerly Microsoft Flow, Power Automate is a tool found within the Microsoft 365 application suite that can be used by everyday users to create automated workflows that connect and process data between different apps and platform services.

You can use Power Automate in a number of ways to boost productivity and save time – like automatically synchronizing files to cloud storage providers, prompt notifications on deliverable actions, and even automatically monitor social media accounts for brand mentions.

What is Power Apps?

Power Apps lets users create custom business apps within their Microsoft 365 interface. These apps or widgets can be purposefully designed to simplify and transform everyday business processes – being utilised again and again to time-saving effect.

Using a drag and drop interface, even non-developer users can build their app without writing a single line of code – all they need is an idea of how to make something better.

The apps can then be shared and accessed on desktop or mobile devices with team members throughout your organisation.

Easy to use

PowerTools eliminates the need for complex expression syntax and formulas when designing workflows or apps.

Because the functions available are pre-built, utilising them is as simple as dragging and dropping them from a selected menu.

PowerTools has been designed to put the power of process-automation in the hands of the everyday, non-developer, user.

No code, no headaches. 

You just need an idea of how to automate a business process and PowerTools will have a function to help.

90+ pre-built functions

Redact a sensitive document, localize currencies and dates, translate text into multiple languages, perform advanced calculations, convert text to speech, validate email addresses, shorten hyperlinks, transform data and more with only a few clicks.

Pay as you grow

PowerTools grows with your business, automatically scaling from just a few users to hundreds of thousands.

Easily add it to your tenant from the Power Platform Connector Gallery and pay only for the number of API calls you use, with no long-term commitments or contracts.

Pricing plans begin at only $49/mo.

Choose From Two Licenses

PowerTools LITE is a free to use version – with a limited number of functions available for you to try (see what is included in the functions table below). Visit our Shop to sign up and get a license key. Then install the PowerTools LITE connector on your Microsoft platform.

When you’re ready for more power, add a PRO subscription to unlock all functions available in PowerTools including on-the-fly text translation, text-to-speech, currency conversion, image resizing etc. Pricing is charged on the number of daily API calls you make – so you can scale as you grow.

Available Functions

Compare the feature functions available in PowerTools LITE and PowerTools PRO in the table below. Click on the icons against each function to learn more and view tutorials for integrating it in an example workflow or app.

Type
Features

LITE
Edition
PRO
Edition
CollectionsAdd to Collection
Add one or more items to an array
CollectionsRemove from Collection
Remove one or more items from an array
CollectionsFilter Collection
Search array of strings based on keywords
CollectionsCount Collection
Count the number of items in an array
CollectionsSort Collection
Sort array of items in ascending or descending order
CollectionsSplit Collection
Split a single array into multiple arrays
CollectionsReplace Items
Replace matching items in array with new value
CollectionsContains String
Any item in array contains specified string
CollectionsContains Number
Any item in array contains specified number
CollectionsStarts with String
First item in array equals specified string
CollectionsEnds with String
Last item in array equals specified string
CollectionsConvert to JSON
Convert a collection to a named JSON object
CollectionsConvert to XML
Convert a collection to an XML object
CollectionsRemove duplicates
Remove duplicate items from a collection
CollectionsJoin Collection
Join an array of strings into a single string with optional separator
FinanceConvert Currency
Convert decimal value from source to target currency
FinanceFormat Currency
Prepend decimal value with currency symbol
FinanceStock Prices
Get current and historical stock price information
FinanceMarket Index
Get current and historical market index information
DateTimeFormat Date Time
Display date and time string in specified format
DateTimeWorld Time
Convert date and time value to specified time zone
DateTimeDate Information
Get information about a date, including day of year, day of week, week of year, seconds in day, minutes in day and ticks
MathCalculate Average
Compute average value from an array of numbers
MathCalculate Median
Compute median value from an array of numbers
MathCalculate Min/Max
Determine minimum or maximum value in an array of numbers
MathCalculate Sum
Compute sum from an array of numbers
MathCalculate Power
Compute result of a number raised to a specific value
MathCalculate Variance
Compute mean of the squares of the deviations from the arithmetic mean of an array of numbers
MathRandom Number
Calculate a random number between specified minimum and maximum values
MathRound Number
Round a number to the specified number of decimal places
MathStandard Deviation
Calculate amount of variation in an array of numbers
MathConvert Angle
Convert value from one unit of angle measurement to another
MathConvert Area
Convert value from one unit of area measurement to another
MathConvert Duration
Convert value from one unit of time measurement to another
MathConvert Distance
Convert value from one unit of distance measurement to another
MathConvert Energy
Convert value from one unit of energy measurement to another
MathConvert Power
Convert value from one unit of power measurement to another
MathConvert Speed
Convert value from one unit of speed measurement to another
MathConvert Temperature
Convert value from one unit of temperature measurement to another
MathConvert Volume
Convert value from one unit of volume measurement to another
MathConvert Weight
Convert value from one unit of weight measurement to another
MathCalculate Addition
Calculate the sum of two numbers
MathCalculate Subtraction
Calculate the difference between two numbers
MathCalculate Multiplication
Calculate the product of two numbers
MathCalculate Division
Calculate the quotient of two numbers
MathCalculate Modulo
Calculate the remainder of dividing two numbers
MathCalculate Nth Root
Calculate the n-th root of a number
MathCalculate Square Root
Calculate the square root of a number
MathCalculate Logarithm
Calculate the logarithm of a number
MathCalculate Sine
Calculate the sine value of an angle
MathCalculate Cosine
Calculate the cosine value of an angle
TextCompare Strings
Perform a comparison of two strings
TextContains String
Determine if a string contains another string
TextConvert Case
Convert string to upper, lower or title case
TextDecode String
Decode a string encoded with Base64 encoding
TextEncode String
Encode a string using Base64 encoding
TextGenerate GUID
Generate a globally unique identifier
TextJoin Strings
Join a collection of strings
TextGenerate Hash
Generate a hash value from a string
TextVerify Hash
Verify a hashed value against the original source string
TextRedact String
Redact a strng containing sensitive content
  
  
TextReplace String
Replace one value with another in a string
TextSplit String
Split a string based upon one or more characters
TextTrim String
Trim leading or trailing whitespace from a string
TextURL Decode
Decode an encoded URL
TextURL Encode
Encode a URL
TextShorten Link
Generate a simple, short URL from a complex URL
TextTranslate String
Translate a string into a different language
TextText to Speech
Convert plain text or SSML into speech
TextSpeech to Text
Convert audio file to text
TextSpeech to Text V2
Convert audio file to text with optional timestamps (1MB compressed, 10MB uncompressed limit)
TextValidate Email
Determine if an email address is valid
TextString to File
Convert text string to file
TextAuto Correct (Beta)
Automatically correct text (1024 char max)
TextParse String
Extract values from a string of text using Regular Expressions
TextModerate Content (Beta)
Scan text for explicit, suggestive or obscene content (English only)
TextDetect Personal Data (Beta)
Detect personal information (PII) in text (1024 char max)
DataJSON to HTML
Convert a JSON array to an HTML table
DataJSON to CSV
Convert a JSON array to CSV string
DataJSON to XML
Convert a JSON object to an XML string
DataCSV to JSON
Convert a CSV string to a JSON array
DataXML to JSON
Convert an XML string to a JSON object
DataXML to JSON
Convert an XML string to a JSON object
DataQuery JSON
Query a JSON object using a JSONPath expression
DataQuery XML
Query an XML string using an XPath expression
DataFilter CSV
Filter a comma-delimited string using field names and/or regular expressions
DataValidate JSON
Determine if a JSON string represents a valid data object
DataFormat JSON
Format a string of JSON data
DataCSV to XML
Convert a CSV string to an XML string
FilesConvert Image
Convert an image to a different format – PNG, GIF, JPG or BMP
FilesResize Image
Resize an image using a variety of resampling algorithms
FilesRotate Image
Rotate an image by specified number of degrees
FilesFlip Image
Flip an image (horizontal or vertical)
FilesWatermark Image
Add watermark text to an image
FilesCrop Image
Crop an image
FilesGenerate QR Code
Generate a QR code image
FilesFile to String
Convert a file to a Base64 string
FilesComposite Image
Insert a foreground image in front of a background image
FilesReduce Image Quality
Reduce the quality of an image to produce a smaller file size
FilesRemove Image Metadata
Remove the EXIF and IPTC profile data from an image
FilesImage Moderation (Beta)
Scan image for adult or obscene content
FilesCompress File
Compress a file (20MB max)
PowerTools PRO Pricing

The pricing table below relates to the premium PowerTools PRO license - which includes access to all available PowerTools functions. Start with a free trial for testing or an affordable Basic plan and scale up as your needs grow.

If you would like to assess PowerTools first before subscribing to the PRO license, consider installing the free PowerTools LITE version.

Not sure which is right for you? Contact us for a free evaluation.

TRIAL

Give it a try

FREE
  • 500 total requests for testing and evaluation
  • 90+ essential actions
  • Upgrade on-demand
Subscribe

BASIC

$19 / mo
  • 1,000 monthly requests
  • 100+ essential actions
  • 99.95% uptime SLA
  • Individual and micro business
Subscribe
Popular

INTERMEDIATE

$29 / mo
  • 2,500 monthly requests
  • 100+ essential actions
  • 99.95% uptime SLA
  • Small business
Subscribe

PRO 5K

$49 / mo
  • 5000 monthly requests
  • 100+ essential actions
  • 99.95% uptime SLA
  • Medium business
Subscribe

PRO 10K

$79 / mo
  • 10,000 monthly requests
  • 100+ essential actions
  • 99.95% uptime SLA
  • Large business
Subscribe

PRO 25K

$99 / mo
  • 25,000 monthly requests
  • 100+ essential actions
  • 99.95% uptime SLA
  • Enterprise
Subscribe