cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RvdHeijden
Post Partisan
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
CNT
Super User
Super User

@RvdHeijden 

Please try the following,

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.

 

 

View solution in original post

@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

View solution in original post

4 REPLIES 4
CNT
Super User
Super User

@RvdHeijden 

Please try the following,

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.

 

 

@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 🙂

@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")

@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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

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

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 Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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