Power Apps

Question

Power Apps

Padmaja Krishnaswamy 5

Exercise - Introduction to formulas in canvas apps

The following formula is incorrect

User's image

The correct formula is shown below:

Text(Value(ThisItem.'Machine Price',"en-US"),"$ #,###.00")

Please make the necessary corrections

Anonymous

2024-12-16T04:13:41.9566667+00:00

Hi Padmaja Krishnaswamy,

Just following up to see if you had a chance to review my previous response. Please let me know if it was helpful, and don't hesitate to reach out if you have any further questions. If your issues have been resolved, kindly accept the answer by clicking the Accept Answer and Upvote buttons on the post.

Thank you!
Anonymous

2024-12-18T04:26:58.95+00:00

Hi Padmaja Krishnaswamy,

Just following up to see if you had a chance to review my previous response. Please let me know if it was helpful, and don't hesitate to reach out if you have any further questions.

1 answer

Your answer

Anonymous

2024-12-16T04:13:41.9566667+00:00

Hi Padmaja Krishnaswamy,

Just following up to see if you had a chance to review my previous response. Please let me know if it was helpful, and don't hesitate to reach out if you have any further questions. If your issues have been resolved, kindly accept the answer by clicking the Accept Answer and Upvote buttons on the post.

Thank you!
Anonymous

2024-12-18T04:26:58.95+00:00

Hi Padmaja Krishnaswamy,

Just following up to see if you had a chance to review my previous response. Please let me know if it was helpful, and don't hesitate to reach out if you have any further questions.

Answer 1

Anonymous

Hi Padmaja Krishnaswamy,

Thank you for reaching out to us on the Microsoft Q&A forum.

After reviewing the formula you provided, we can confirm that the correct version for formatting the Machine Price in a currency format is Text(Value(ThisItem.'Machine Price'), "$ ##.00")

We have tested this on our end as well, and it functions as expected, accurately displaying the price with a dollar sign and two decimal places. For your reference, please see the attached screenshot confirming the results.

User's image

Please reach out to us if you have any other queries.

If the information is helpful, please Accept Answer & Upvote so that it would be helpful to other community members.

Padmaja Krishnaswamy 5 Reputation points

2024-12-16T14:39:06.3366667+00:00

Hello Rakesh,

Thanks for getting back. I presume that it works for you because your default currency in your Windows Region Settings is US Dollar. If the currency is different, it does not work and gives an error. Please check whether this is true and if so, you may qualify the remarks
Anonymous

2024-12-17T05:04:08.8366667+00:00

Hi Padmaja Krishnaswamy,

The issue stems from regional language settings in Power Apps, which impact the use of decimal and argument separators. To address this, ensure the formula is adapted to the locale by using either a comma or semicolon as required by the region's settings.

If the information is helpful, please Accept Answer & Upvote so that it would be helpful to other community members.

Share via

Power Apps

1 answer

Your answer