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 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.
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.
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/
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.
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.
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.
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.
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.
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.
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.
|Collections||Add to Collection|
Add one or more items to an array
|Collections||Remove from Collection|
Remove one or more items from an array
Search array of strings based on keywords
Count the number of items in an array
Sort array of items in ascending or descending order
Split a single array into multiple arrays
Replace matching items in array with new value
Any item in array contains specified string
Any item in array contains specified number
|Collections||Starts with String|
First item in array equals specified string
|Collections||Ends with String|
Last item in array equals specified string
|Collections||Convert to JSON|
Convert a collection to a named JSON object
|Collections||Convert to XML|
Convert a collection to an XML object
Remove duplicate items from a collection
Join an array of strings into a single string with optional separator
Convert decimal value from source to target currency
Prepend decimal value with currency symbol
Get current and historical stock price information
Get current and historical market index information
|DateTime||Format Date Time|
Display date and time string in specified format
Convert date and time value to specified time zone
Get information about a date, including day of year, day of week, week of year, seconds in day, minutes in day and ticks
Compute average value from an array of numbers
Compute median value from an array of numbers
Determine minimum or maximum value in an array of numbers
Compute sum from an array of numbers
Compute result of a number raised to a specific value
Compute mean of the squares of the deviations from the arithmetic mean of an array of numbers
Calculate a random number between specified minimum and maximum values
Round a number to the specified number of decimal places
Calculate amount of variation in an array of numbers
Convert value from one unit of angle measurement to another
Convert value from one unit of area measurement to another
Convert value from one unit of time measurement to another
Convert value from one unit of distance measurement to another
Convert value from one unit of energy measurement to another
Convert value from one unit of power measurement to another
Convert value from one unit of speed measurement to another
Convert value from one unit of temperature measurement to another
Convert value from one unit of volume measurement to another
Convert value from one unit of weight measurement to another
Calculate the sum of two numbers
Calculate the difference between two numbers
Calculate the product of two numbers
Calculate the quotient of two numbers
Calculate the remainder of dividing two numbers
|Math||Calculate Nth Root|
Calculate the n-th root of a number
|Math||Calculate Square Root|
Calculate the square root of a number
Calculate the logarithm of a number
Calculate the sine value of an angle
Calculate the cosine value of an angle
Perform a comparison of two strings
Determine if a string contains another string
Convert string to upper, lower or title case
Decode a string encoded with Base64 encoding
Encode a string using Base64 encoding
Generate a globally unique identifier
Join a collection of strings
Generate a hash value from a string
Verify a hashed value against the original source string
Redact a strng containing sensitive content
Replace one value with another in a string
Split a string based upon one or more characters
Trim leading or trailing whitespace from a string
Decode an encoded URL
Encode a URL
Generate a simple, short URL from a complex URL
Translate a string into a different language
|Text||Text to Speech|
Convert plain text or SSML into speech
|Text||Speech to Text|
Convert audio file to text
|Text||Speech to Text V2|
Convert audio file to text with optional timestamps (1MB compressed, 10MB uncompressed limit)
Determine if an email address is valid
|Text||String to File|
Convert text string to file
|Text||Auto Correct (Beta)|
Automatically correct text (1024 char max)
Extract values from a string of text using Regular Expressions
|Text||Moderate Content (Beta)|
Scan text for explicit, suggestive or obscene content (English only)
|Text||Detect Personal Data (Beta)|
Detect personal information (PII) in text (1024 char max)
|Data||JSON to HTML|
Convert a JSON array to an HTML table
|Data||JSON to CSV|
Convert a JSON array to CSV string
|Data||JSON to XML|
Convert a JSON object to an XML string
|Data||CSV to JSON|
Convert a CSV string to a JSON array
|Data||XML to JSON|
Convert an XML string to a JSON object
|Data||XML to JSON|
Convert an XML string to a JSON object
Query a JSON object using a JSONPath expression
Query an XML string using an XPath expression
Filter a comma-delimited string using field names and/or regular expressions
Determine if a JSON string represents a valid data object
Format a string of JSON data
|Data||CSV to XML|
Convert a CSV string to an XML string
Convert an image to a different format – PNG, GIF, JPG or BMP
Resize an image using a variety of resampling algorithms
Rotate an image by specified number of degrees
Flip an image (horizontal or vertical)
Add watermark text to an image
Crop an image
|Files||Generate QR Code|
Generate a QR code image
|Files||File to String|
Convert a file to a Base64 string
Insert a foreground image in front of a background image
|Files||Reduce Image Quality|
Reduce the quality of an image to produce a smaller file size
|Files||Remove Image Metadata|
Remove the EXIF and IPTC profile data from an image
|Files||Image Moderation (Beta)|
Scan image for adult or obscene content
Compress a file (20MB max)
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.
Give it a try