Showing results for 
Search instead for 
Did you mean: 
Not applicable

SharePoint Calculated field value not showing to all users if wrapped with Value().

I have a weird Power App problem that I have never encountered before, and I am really struggling to find the root cause of it. I have done some troubleshooting and in the simplest form the problem is this:

I have a calculated field in SharePoint. The value in the field is a number and I need to do some comparisons against it in the app. But since it's a calculated field, Power App doesn't understand it's a number unless I put Value() around it. 


All good, right? Well. No.


Half of my users see the value in the app. Half of them don't. They all use the app via Chrome browser and have the same user rights to the SharePoint list.


If I use ThisItem.field, all users see the value in the app but I get errors because it's not a number.


If I use  Value(ThisItem.field), no errors but half of the users don't see the value at all. 


What am I missing here? I was hoping this problem would resolve itself but it's been a month now and time is running out. Either I solve this problem or take the time to build the functionality in a completely different way. 


Accepted Solutions
Not applicable

The feature in the app that this problem is affecting is not a label, it's a progress bar that is based on a slider and some of the colors and icons change depending on the slider value. I used the labels only for troubleshooting, figuring out what I see differently than the users with the problem. I used the sliders there as well.


I think this remains a mystery, since I had to create a workaround. I just do the calculation directly in the app instead of SharePoint. Everything else works like a charm, it just needed, you know, a value that actually exists 😅

View solution in original post

Super User II
Super User II



Unsure about this as we did not get this issue when using it this way.


A quick thing we can think of is, do some calculation on PowerApps side that doesn't change the number.


For example, divide the number by 1 e.g. Value(ThisItem.field/1) and see if this helps in any way.


Not applicable

It's the weirdest thing really. I have tried to find something in common with the users that don't see the value, but there is nothing. It's not completely random either since it only affects certain users, and it affects them every time. And the rest of the group always see the value. 


But I try this dividing in my next round of troubleshooting. I'm not awfully positive though. 

Not applicable

Okay, the result from the troubleshoot round #83748378743


They can see a number if I use Value(ThisItem.field/1). However, the number is always zero and that is incorrect. 



  1. Is the number a decimal?
  2. You can try this instead as well: Value(ThisItem.field + 0).
  3. What are some examples of the exact data that can be in ThisItem.field e.g. is 123.45678 a possible value? Is 123 a possible value?
Not applicable

The value in the calculated field is always a number between 0 and 6. So the only possible values are 0, 1, 2, 3, 4, 5 and 6.


ThisItem.field shows the value in the app as 1.00000000000000 (etc)

Value(ThisItem.field) shows the value as 1. (etc)


And while zero is a possible value in the field, items with the value of zero are not shown in the app. 

Not applicable

Here are some visuals:

This is what I see in the app, both  values are visible.



Here is a screenshot provided by a user who is affected by this problem. There is nothing to see.




And obviously short number is Value(ThisItem.field) and the long number is ThisItem.field. Just made it more friendly to the poor user who has to help me troubleshoot this.



Wow, not sure why affect some users and not others,


The affected users can try clear cache and cookies, but unsure this will help.


Can try this workaround as well, but really unsure why you have the issue, you should not have it:








However, we think above should not be needed!



You can also try arbitrarily rounding the calculated value to see if for some reason it helps in your specific case:



Round(Value(ThisItem.TheCalculatedField), 0)




Further details about Round functions:



The Round, RoundDown, and RoundUp functions round a number to the specified number of decimal places:

  • Round rounds up if the next digit is a 5 or higher. Otherwise, this function rounds down.
  • RoundDown always rounds down to the previous lower number.
  • RoundUp always rounds up to the next higher number.

If you pass a single number, the return value is the rounded version of that number. If you pass a single-column table that contains numbers, the return value is a single-column table of rounded numbers. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.


Round( Number, DecimalPlaces )
RoundDown( Number, DecimalPlaces )
RoundUp( Number, DecimalPlaces )

  • Number - Required. The number to round.
  • DecimalPlaces - Required. The number of places to the right of the decimal point to round to. Use 0 to round to a whole number.
Not applicable

I think none of those work, because the value does not exist. You cannot divide, round etc something that does not exist 😅

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (63,182)