Currency and decimal format

(1) Share

Report

Posted on by Sajarac

3,293

Hello there,

I have a table exported from Microsoft Access in excel, that table has all of the info that I request for my power app, in that table I have two fields which is I would like to show as it is, the first one has a decimal format and the second one has a currency format, in my excel file I can see properly, but in my power app I only see just the number wtihout any format.

Any idea?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sajarac,

You could use Text function to format a number on PowerApps. For more details, please see this article for a reference:
https://powerapps.microsoft.com/en-us/tutorials/function-text/

I have a table exported from Microsoft Access in Excel, then I save the Excel file in OneDrive, create an app with this Excel file. In the app, I use Text function to format the number.
>About the Currency field, I set its Text property to: Text(Field1,"[$-en-US]$,###,##.##")
>About the Number field, I set its Text property to: Text(Field2,"[$-en-US]###,##.##")

On the app, it shown as below:

Please try if this works for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Sajarac 3,293 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much, it works for the currency, but no for the decimal field, also I've tried to change the date format to remove the time but didn't work.

Was this reply helpful? Yes No
AndyPennell Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I would take a guess that the type of your Start_Date column is text, not datetime. You need to convert that string into a PowerApps date, then format it, with something like

Text(DateValue(Start_x0020_Date), ShortDate)

I don't have enough information to try and assist with the decimal issue.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sajarac,

Thanks for your reply. Could you show us your data source configuration? How is the decimal field and data and time field configured in the Access?

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Sajarac 3,293 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your reply, here are some screen shots:

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(7)

Report
Copy link

Link copied!

Hi Sajarac,

Here is the screenshot of my database configuration:

Then I export the data from Access in Excel, format the data as a table, save it in OneDrive, create an app from data with this Excel file. In the app, Number and Data and Time fields are shown as below:

Then I configure the Text property of Date and Time field as: Text(Date_x0020_and_x0020_Time,ShortDate), the Text property of Number field as: Text(Number,"[$-en-US]###,###.##"), then the Currency field as: Text(Currency,"[$-en-US]$###,###"). The screenshot after configuration:

Here is the steps, hope it can be a reference for you. please feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
jcollins 149 on at

Like
a
(1)

Report
Copy link

Link copied!

what if your field doesn't have the "Text" property?
it is a Number field in the sharepoint list but I don't see a "Text" property for it nor my "single line text" column fields. ugh...

Was this reply helpful? Yes No
Chicko29 38 on at

Like
a
(0)

Report
Copy link

Link copied!

How you accomplish the same with a euro sign? I tried changing the dollar sign to a euro sign but it generated an error

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Does the Text('Total Spend',"[$-en-US]$###,###") go in the Role section under Data Menu from the Advanced Tab? Or where does it go?

It let's me submit it there without errors, but it is not updating the number to display it as currency.

Was this reply helpful? Yes No
Sajarac 3,293 on at

Like
a
(4)

Report
Copy link

Link copied!

Try this one isntead:

Text(Value(Total Spend),"[$-en-US]$#,##0.00#")

Was this reply helpful? Yes No