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.
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.
- 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:
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.
This is how to format a currency field in PowerApps.
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.
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:
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:
- Power Automate Dataverse Update Multiple Rows
- Sort a Power Apps Dropdown Control
- How to Add a Time Picker in the Power Apps Canvas App?
- Highlight the Selected Item within a Power Apps Gallery
- Send formatted email using Power Apps HTML Text control
- Power Apps Barcode Reader Control
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.