cancel
Showing results for
Did you mean:
Post Partisan

## Changing values for a DataCardValue

Goodmorning, I've been working on an App based on a SP list.

When using an Edit form with different DataCardValues i've noticed that the columns in SP dat consist of a formula doesn't display the right value (there where in the SP list it does show the correct value)

Basically I now have values such as -80.00000000000000, 5168.000000000000 or 0.139240506329114

I need a formula (or another solution) to change the first to -80 the second one to € 5.168,00 and the third to 13,9xxx %

Is there a formula to do so or should I hide this DataCardValue and use a label with a formula or .... ?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

Text(-80.00000000000000) will give you -80

Text(5168.000000000000, "[\$-fr-FR]#.###,00 €", "fr-FR") will give you 5.168,00 €

Text(Value(0.139240506329114)*100, "00.0000000000 %") will give you 13,9xxx %

Please remember to give a 👍 and accept my solution as it will help others in the future.

Post Partisan

@CNT I'm afraid it still doesnt return the correct value when I use the formula, however I did manage to fix one formula:

Text(-80.00000000000000) will give you -80

Round(Substitute(Parent.Default;".";",");2)

The other 2 formula's still don't provide the correct outcome

Substitute(Parent.Default;".";",");Text(Value(Parent.Default);"[\$-nl-NL]#,###,00 €";"nl-NL")

Parent.Default value is 5073.00000000000

I've subsituted the . with a , but when I use the rest of the formula somehow it returns a red line under the ;

Edit: I've managed to fix the formula in a format that I wanted using the formula:

"€ " & Text(Value(Round(Substitute(Parent.Default;".";",");2));"[\$-nl-NL]#.###,00";"nl-NL")

the third formula (based on %) returns the same fault as the formula above

Substitute(Parent.Default;".";",") ; Text(Value(Parent.Default)*100;"00,0 %")

Edit: I've managed to fix the formula in a format that I wanted using the formula:

Text(Value(Substitute(Parent.Default;".";",")*100);"##.## %")

Ive already tried to replay the ; with a ;; or a & but that doesn't work

4 REPLIES 4
Super User

Text(-80.00000000000000) will give you -80

Text(5168.000000000000, "[\$-fr-FR]#.###,00 €", "fr-FR") will give you 5.168,00 €

Text(Value(0.139240506329114)*100, "00.0000000000 %") will give you 13,9xxx %

Please remember to give a 👍 and accept my solution as it will help others in the future.

Post Partisan

@CNT im afraid this isn't working just yet.

Ive tried to use your formula but it returns an error

Text(Value(Parent.Default;"€-nl-NL]#.###,00 €";"nl-NL")

When I select the DataCardValue it sets the TEXT value to Parent.Default and then when I try to incorporate your formula it returns an Error. Basically I need this formula to be variable and in your example you used the fixed values I provided so does the Parent.Default work in this formula ?

When I use your formula to fix the % it returns a Value that is wrong
Text(Value(Parent.Default)*100;"00,000000000%")

The value now reads 13.989.637.305.699.500% so that's not what Im looking for 🙂

Super User

@RvdHeijden You can replace the fixed part with whatever you want. In your formula some brackets are missing and also don't change the first \$ symbol. That's the placeholder for the currency.

Text(Value(Parent.Default);"[\$-nl-NL]#.###,00 €";"nl-NL")

Post Partisan

@CNT I'm afraid it still doesnt return the correct value when I use the formula, however I did manage to fix one formula:

Text(-80.00000000000000) will give you -80

Round(Substitute(Parent.Default;".";",");2)

The other 2 formula's still don't provide the correct outcome

Substitute(Parent.Default;".";",");Text(Value(Parent.Default);"[\$-nl-NL]#,###,00 €";"nl-NL")

Parent.Default value is 5073.00000000000

I've subsituted the . with a , but when I use the rest of the formula somehow it returns a red line under the ;

Edit: I've managed to fix the formula in a format that I wanted using the formula:

"€ " & Text(Value(Round(Substitute(Parent.Default;".";",");2));"[\$-nl-NL]#.###,00";"nl-NL")

the third formula (based on %) returns the same fault as the formula above

Substitute(Parent.Default;".";",") ; Text(Value(Parent.Default)*100;"00,0 %")

Edit: I've managed to fix the formula in a format that I wanted using the formula:

Text(Value(Substitute(Parent.Default;".";",")*100);"##.## %")

Ive already tried to replay the ; with a ;; or a & but that doesn't work

Announcements

#### Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

#### Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

#### Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,011)