cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  again could you please provide screenshot of the INITIAL number from collection? before any attempt to format it?

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

I dont get you, sorry

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  you have in your formula:

First (collTaskRow).TrabalhoRealdaTarefa 


Could you please show this value from collection?

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

See the zeros:

 

error_00.png

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  ^^ please go to the View => Collections and collTaskRow and property TrabalhoReladaTarefa not the formula where you are adding formatting - want to see collection / raw data

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

sorry about that... 

 

here the screen:

 

cololection_trabalhorealdatrefa.png

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  no worries, just checked and please try something similar:

Text(Value("27.000000"),"##.00")

Result:

Forum11.png

When I tried:

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

Result was:

27.26

 

hope it will resolve this issue if yes, please mark it as solution 🙂

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

language not suported.png

Highlighted
Resolver I
Resolver I

Re: SOMEONE KNOWS THIS ERROR?

@Gorilla_8  place of the close ) for value function you have in wrong place, try:

Text(Value(First(Collection).Property);"[$-en-Us]##.00")

 

Highlighted
Post Prodigy
Post Prodigy

Re: SOMEONE KNOWS THIS ERROR?

cololection_trabalhorealdatrefa.png

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

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

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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