Applying a conditional formatting inside out list view will show our number field with fractions .00000000

john john 946 Reputation points

We have a calculated column of type number and we applied a conditional formatting on this field, but after applying the conditional formatting the field will show .0000000 fractions as follow:-


so can we fix this?

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,863 questions
0 comments No comments
{count} votes

Accepted answer
  1. Li Zhang_MSFT 1,566 Reputation points

    Hi @john john ,

    Currently this seems to be a known issue. Please click Advanced mode on the bottom of Conditional formatting, find the property "txtContent": "[$FieldName.displayValue]" as shown below:


    Then update the property value from [$FieldName.displayValue] to [$FieldName] or @CurrentField.


    Result for your reference:



    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful