web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Show blank Text label ...

Power Apps

Unanswered

Show blank Text label instead of Zero

(0) Share

Report

Report

Posted on by Appsforourlife

67

Hi,

I use Text Label to present Result in perecentage (2 Decimal) in vertical Gallery I use the following function:

Default: Text(Value(ThisItem.'Result'*100),"[$-en-US]0.00%")

It works prety well, but I want this function to don't return any value if Result is empty or equal to zero.

BR

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
You could try something like:
If(Value(ThisItem.'Result' = 0), Text(Value(ThisItem.'Result'*100),"[$-en-US]0.00%"), "")

Hope this helps!

Was this reply helpful? Yes No
Appsforourlife 67 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Almost, I just changed it as following:
If(Value(ThisItem.'Result'=""), "",Text(Value(ThisItem.'Result'*100),"[$-en-US]0.00%"))
.... and it worked well 🙂

Thank you again
Cheers!

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
Just so you know your options in future, can also write like

If(IsBlank(ThisItem.'Result'), "", Text(Value(ThisItem.'Result'*100),"[$-en-US]0.00%"))

Was this reply helpful? Yes No

Join the conversation