Exercise - Introduction to formulas in canvas apps The following formula is incorrect The correct formula is shown below: Text(Value(ThisItem.'Machine Price',"en-US"),"$ #,###.00") Please make the necessary corrections

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. 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.

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

Rakesh Gurram 10,545 Reputation points Microsoft Vendor

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!
Rakesh Gurram 10,545 Reputation points Microsoft Vendor

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

Rakesh Gurram 10,545 Reputation points Microsoft Vendor

2024-12-13T18:25:22.2+00:00

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.

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.
Please sign in to rate this answer.

1 person found this answer helpful.
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

Rakesh Gurram 10,545 Reputation points Microsoft Vendor

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Power Apps

1 answer

Your answer