Answered

Need help in powerapps formatting

(0) Share

Report

Posted on by dims12

105

Hi All,

I am pulling data from excel into powerapps gallery. I have one decimal colum with values like 0.2 , 0.02 etc

My user wants to see the decimal data in % in the gallery.
I applied below formatting on the label. Only issue is that it is showing 0.0% even when data is blank in excel. How can I fix this?

Text(Value(ThisItem.'colname')*100,"#0.0%")

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @dims12,

We can check whether the column is blank - if not we display the percentage value:

If( ThisItem.'colname' <> Blank(), Text(Value(ThisItem.'colname')*100,"#0.0%") )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
dims12 105 on at

Like (0)

Report

I tested this but it is still returning 0.0% for blank values

Was this reply helpful? Yes No
dims12 105 on at

Like (0)

Report

If(
ThisItem.'colname' <> Blank(),
Text(Value(ThisItem.'colname' )*100,"#0.0%"),Blank()
)

tried this too still showing 0.0% for blank values in excel.

Was this reply helpful? Yes No
dims12 105 on at

Like (0)

Report

@LaurensM

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
@dims12

Did an additional test and you will have to check for literal empty string values:

If( ThisItem.'colname' <> "", Text(Value(ThisItem.'colname')*100,"#0.0%") )

Could you give the code above a try?

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
dims12 105 on at

Like (0)

Report

Thank you it worked.

Was this reply helpful? Yes No