cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rgriffiths
Level: Powered On

Format number in data card

I have added a data card from a list into a form. How do I format the number to have two decimal places and a £ symbol (ie currency) .

5 REPLIES 5
seanbrogan
Level: Powered On

Re: Format number in data card

Hi @rgriffiths

If you look at the properties panel, in the advanced tab, there should be an option to unlock the data card. Once you click this all the boxes should be free for you to change

rgriffiths
Level: Powered On

Re: Format number in data card

Thanks - strange as I thought I had done that already. But it still leads me on to the actual problem I have.

 

The Fieldname from the list is called Cost, the card item text input box is called CrdCostData and this text box initially had TextFormat.Number in the format property. I have tried each of the following in the Format property box:

 

    Text(ThisItem, "####.##")

    Text(ThisItem.Cost, "####.##")

    Text(ThisItem.CrdCostData, "####.##")

    Text(TextFormat.Number, "####.##")

 

but it doesn't format the number at all. What should I put here?

Super User
Super User

Re: Format number in data card

Hi @rgriffiths,

You don't need to format numbers that are input in data cards.  Text formatting is done on the output  when the data is retreived and displayed in labels.  

Highlighted
rgriffiths
Level: Powered On

Re: Format number in data card

Please forgive me, I am new to PowerApps and I am a little confused by this. The user is being asked to enter data - in this case a cost - and I would have thought it would be possible to set the input format - an input mask. Is this not possible in this scenerio? It means that someone could enter a non-currency value. Eg 3.333

Super User
Super User

Re: Format number in data card

Hi @rgriffiths,

The same exact issue came up in another thread and @CarlosFigueira came up with a work around and a nice gif that shows how it's done. https://powerusers.microsoft.com/t5/General-Discussion/How-do-I-format-a-field-to-look-like-currency...

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 204 members 3,963 guests
Please welcome our newest community members: