cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
Kudo Kingpin
Kudo Kingpin

Currency and decimal format

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi Sajarac,

 

Here is the screenshot of my database configuration:

Number.PNGDate and Time.PNG

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:

Textbefore.PNG

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:

Textafter.PNG

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
v-yamao-msft
Community Support
Community Support

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:

Access.PNG

 

Please try if this works for you.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

Screen.png

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.

 

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

SQFT.JPGstartdate.JPG

Hi Sajarac,

 

Here is the screenshot of my database configuration:

Number.PNGDate and Time.PNG

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:

Textbefore.PNG

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:

Textafter.PNG

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

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

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. 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (100,421)