Number to Words PCF Control

Hello and Welcome!

Today, I’m excited to share with you a PCF Control that I recently created. This control is designed to help businesses display currency values in words, and it might just be the solution you’re looking for!

What inspired me creating this PCF?

I was working with a global client that operates not only in India, but in 12 other countries as well. They had a unique requirement: they wanted to display currency values in words on invoices, not just in numbers. But there was a twist—they needed this functionality to work for multiple currencies depending on the customer’s region.

The request came from their finance team, who wanted to print the invoice value both as a number and in words. For example, they wanted invoices to show something like this:

Example:

If the customer is Reliance or Tata, the invoice should read:

Invoice Value: ₹25,035,000.00
(TWO CRORE FIFTY LAKH THIRTY-FIVE THOUSAND RUPEES ONLY)

If the customer is Microsoft or Apple, the invoice should read:

Invoice Value: $25,035,000.00
(TWENTY-FIVE MILLION THIRTY-FIVE THOUSAND DOLLARS ONLY)

Now, in standard PowerApps, there isn’t a built-in option to convert an amount (number) into words. So, I decided to search for a solution. I looked around on the PCF Gallery and GitHub, but I couldn’t find a pre-existing PCF control that solved this problem.

There are dozens of JavaScript solutions available, but in an era of low-code rapid development, I wanted to create something that could help others—without requiring them to write custom code every time.

The Solution: A Currency to Words PCF Control

I decided to build a PCF Control that would take two inputs:

  1. Amount (in numeric format, e.g., ₹25,035,000.00)
  2. Currency Lookup (the currency type, such as INR, USD, etc.)

The control will convert the numeric value into words based on the provided currency. For example:

  • If the currency is INR, the amount will be converted into words as Rupees and Paise.
  • If the currency is USD, the amount will be converted into words as Dollars and Cents, and so on.

This PCF Control aims to provide an easy way for businesses to automate the conversion of currency values into words, without needing to rely on custom coding or complex solutions.

Step-by-Step Guide to Install and Use the PCF Control

I’ve uploaded the Currency to Words PCF Control to both GitHub and the PCF Gallery for easy access. Here’s a simple guide to help you get started:

  1. Go to the GitHub Repository:
    You can download the solution from my GitHub repository or the PCF Gallery. [Link to GitHub Repository] (insert link here).
  2. Download the Solution:
    Follow the instructions in the repository to download the Managed Solution.
  3. Import the Solution into PowerApps:
    Import the downloaded solution into your PowerApps environment as you would with any other solution.
  4. Add the Control to a Form:
    Once the solution is imported, navigate to any entity form where you want to use this control. Add a Single Line of Text field (to display the amount in words) and select the Currency and Amount fields.
  5. Configure the Control:
    After adding the fields, go to the Component section, click +Component, and search for the Currency in Words Control. Configure the control to take the Currency Lookup and Amount fields as inputs.
  6. Publish and Test:
    Save and publish your changes. Then, test the form by entering values into the Amount field. You should see the currency value converted into words, displayed in the selected currency format (e.g., INR, USD, etc.).

For Detailed Steps – Please Visit my blog here

Leave a comment