Answered

Change format currency

(0) Share

Report

Posted on by rbalza

235

Hi everyone, I am new to using powerapps. Could someone help me with this, please? I have a text field where the data is coming from lists and I wanted to format it to a US currency. Here's my code on the textfield.

LookUp(
 'Source',
 JobCategory.Selected.Result in 'Job Category' && EntityType.Selected.Result in 'Entity Type' && JobType.Selected.Result in 'Job Type',
 'Min. Fee (ex GST)'
)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rbalza
Convert to US Currency

Syntax
Text(ColumnName, "[$-en-US] ##,###")

With your Data
Text(LookUp( 'Source', JobCategory.Selected.Result in 'Job Category' && EntityType.Selected.Result in 'Entity Type' && JobType.Selected.Result in 'Job Type', 'Min. Fee (ex GST)' ),"[$-en-US] ##,###")
rbalza 235 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi StalinPonnusamy, thanks for taking the time on this. I made a bit modification to it as it seems not working, not sure why. I've placed the dollar sign and it works instead of [$-en-US] I put this "$ ##,###"