How to format a currency column in Power Apps?

In this Power Apps Tutorial, we will discuss how to format the Power Apps currency.

Recently, we have been asked by our client to format a SharePoint currency column within the Power Apps while working with the Canvas app.

The following step-by-step guide will show you how to format the currency column within the Power Apps.

Power Apps currency format

In this section, we’ll look at how to format a currency column in Power Apps. As a result, when a user retrieves data from the SharePoint list currency column and imports it into Power Apps, the column will display the data with the relevant currency format.

Power Apps format currency column
Power Apps format currency column

How to format a currency column in Power Apps with Dollar

Here, we will see how to format a SharePoint currency column in Power Apps with a step-by-step guide.

We have a SharePoint list named ‘Product list‘ having a currency type column named Price.

Format currency column in PowerApps
Format currency column in PowerApps
  • Let’s build a Power Apps DataTable control by using the above SharePoint list. On the Power Apps screen, click on Insert tab > DataTable > Select.
  • Add the above SharePoint list to the Power Apps canvas app and connect that list to the Power Apps Data table control. We can see the data table will retrieve all the fields including the data from the SharePoint list to Power Apps as shown below:
How to format SharePoint currency column in power apps
How to format SharePoint currency column in power apps

On the above Power Apps data table control, we can see that the data in the price column is represented numerically rather than in currency. To format the column data in currency, the following steps are:

  • On the Power Apps data table control, select the Price column.
  • Insert the below expression on the Price column’s Text property.
Text = "$" & Text(ThisItem.Price,"0.00")

Once the formula is applied, we can see the price column will be formatted as currency within the Power Apps data table control.

Format a currency field in PowerApps
Format a currency field in PowerApps

This is how to format a currency field in PowerApps.

See also  Create a SharePoint Online Communication Site using Power Automate [Download Complete Package]

Also, we can use the below formula to format the SharePoint currency column within the Power Apps. Select the Price column and insert the expression on the column’s Text property.

Text = Text(ThisItem.Price, "$ ##.00")

Now, we can see that the price will come with the dollar symbol including decimal places.

how to format sharepoint currency column in power apps with dollar symbol
how to format SharePoint currency column in power apps with a dollar symbol

This is how to format the SharePoint currency column in power apps with a dollar symbol.

How to format a currency column in Power Apps with Rand

Similarly, we’ll look at how to format a currency column in Power Apps using the South African currency format, Rand.

For that, insert the below expression on the price column’s Text property.

Text = Text(ThisItem.Price, "[$-en-US]R ###.00")

Once the formula is added to the data table’s price column, the data will appear with the Rand symbol as shown below:

Power Apps format currency field with rand symbol
Power Apps format currency field with rand symbol

This is how to format a currency field with the rand symbol inside the PowerApps.

Conclusion

From this Power Apps Tutorial, we learned how to format a SharePoint currency field using the dollar symbol as well as the rand within the Power Apps.

You may like the following Power Apps tutorials:

>