cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
HillaRamo
Level: Powered On

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
HillaRamo
Level: Powered On

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

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

12 REPLIES 12
dynamicsedge
Level 10

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

@HillaRamo 

 

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.

 

HillaRamo
Level: Powered On

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

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. 

HillaRamo
Level: Powered On

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

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. 

dynamicsedge
Level 10

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

@HillaRamo 

 

  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?
HillaRamo
Level: Powered On

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

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. 

HillaRamo
Level: Powered On

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

Here are some visuals:

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

 

2.PNG

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

 

1.PNG

 

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.

dynamicsedge
Level 10

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

@HillaRamo 

 

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:

 

Value(Text(ThisItem.field))

 

or

 

Value(Text(Value(ThisItem.field)))

 

However, we think above should not be needed!

dynamicsedge
Level 10

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

@HillaRamo 

 

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:

 

 https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-round

 

Description

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.

Syntax

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.
HillaRamo
Level: Powered On

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

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

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,865)