cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

SOMEONE KNOWS THIS ERROR?

hours erro.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  last try:

Text(Value(Substitute(First(collTaskRow).TrabalhoRealdaTarefa;".";","));"[$-en-US]0.00")

try just copy and paste 

View solution in original post

34 REPLIES 34
Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8 not sure what you want to achieve, could you please provide more details?

The formula from the screenshot for sure can be simplified: To removed the most outer TEXT function change the input control FORMAT  property to Number 
Not sure why you are using the mix Value(Text( functions if the property retried from collection is number you can just use Round function without this extra functions.

If this is not helping please provide more info.
Regards
Dawid

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

There are showing to many zero, I try to remove then, but i cant do it

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8 I see, please try to just used the: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text 
Example:

Text( 1234.59, "####.#" )Formats the number with one decimal place."1234.6"

 

Please remember to mark answer as solution to help other community members and close this topic.

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

I know this formula, I already try it, but cant format it....

 

see:

 

print.png

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  isnt that in your formula you have the . in the incorrect place? it should be more like: ####.# and you have the opposite version #.####
Could you please attach screenshot of what value from collection you want to format?

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8 just tested it and form me it worked when I combined it with Value function when was reading data from text input control:

Text(Value(TextInput1.Text),"[$-en-US]#####.##")

Result:
 Forum10.png

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

print.png

 

Not yet, I been thinking, If I use "Round"?, but isn't work...

 

Text(Value(Round(First(collTaskRow).TrabalhoRestantedaTarefa);"[$-en-US]#####.##");1)
Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  it is starting to be funny 😛
could you please just display the value of the First(collTaskRow).TrabelhoRestantedaTarefa ? just this value

 

Also maybe try to use , insted of . in your formula - this problem might be connected with regional settings:
The language of the custom format: For makers, how should a custom format be interpreted? The separator characters (. and ,) have different meanings in different languages. If you specify a custom format, you can include a language placeholder or take the default value, which reflects the language to which your device is set. Even easier, you can use one of the predefined date/time formats, which are language agnostic.

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

Doesn't work

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,727)