Skip to main content

Notifications

Community site session details

Community site session details

Session Id : FnFodqe/62GF8Jy3IygAfu
Power Apps - Microsoft Dataverse
Answered

Values for a column not shown in Views - Model-driven App

Like (1) ShareShare
ReportReport
Posted on 18 Jan 2024 13:34:00 by 180

A user had created a number of views and shared these across the organisation.

 

One particular field, a Whole Number data type (formatted as a duration), showed up as blank. When the user opened a specific record, the duration field would then show up for that record and any other records that had been opened. When the user disconnected from the internet and reconnected, the column was empty again. This effected other users across different browsers, devices and OS (Mac and Windows).

 

The duration field is a simple type (not calculated or rollup) but is populated by a simple Javascript web resource from a start date/time and end date/time field.

 

We looked at the FetchXML of the affected views and the duration field was missing. We asked the user to remove and add the duration column again, and all values showed up in the view (and in the FetchXML). This appeared to resolve the issue for everyone.

Approximately a week later, the duration column was empty again. However, this time the FetchXML looks OK as do the network logs. Again, this is happening to different users, across different devices and browsers - it is also happening across different environments (dev/test/prod). When adding the duration field to an existing view it also shows up as blank. If you export the view to Excel, the values are displayed.

A browser refresh looks to have resolved the issue for each user. 

 

Does anyone have any clues as to what may have caused this? And how to resolve it for good?

Categories:
  • Verified answer
    Mattb-Motive Profile Picture
    180 on 19 Feb 2025 at 22:47:30
    Values for a column not shown in Views - Model-driven App
    Update: This was finally recognised by Microsoft as a bug, with an update rolled out in January 2025.
  • Christine Fuentes Profile Picture
    2 on 11 Nov 2024 at 19:47:34
    Values for a column not shown in Views - Model-driven App
    We are having the same problem with a Field showing in a View.
    I used Mattb-Motive suggestion below from Feb 9, 2024 and that temporarily solves the problem.
     
     
  • FrankvdS Profile Picture
    3 on 12 Jun 2024 at 07:54:02
    Re: Values for a column not shown in Views - Model-driven App

    I am seeing the exact same thing with views that users created on the Account table.
    So far I have not been able to find any logic as to when this happens.
    If you create a new view with the same fields it works fine.

  • Kmadden1 Profile Picture
    4 on 29 May 2024 at 23:36:03
    Re: Values for a column not shown in Views - Model-driven App

    We are having similar issues.  Find it is occurring mainly with various Account fields such as Address 1 fields (Street, Zip) but also some custom fields.  

    The solutions above do not work.  If you open a specific account and then save it, the data appears in the view for just that row.  

     

  • Mattb-Motive Profile Picture
    180 on 03 Apr 2024 at 13:05:47
    Re: Values for a column not shown in Views - Model-driven App

    Hi @Jos_Vondar 


    Sorry to hear you're having a similar issue. Is it also a duration column?

    Unfortunately, I am still trying to work through the problem with Microsoft support. Everything seems to point to it being an issue with the grid control itself rather than any JS or configuration on our end.

     

    It might be worth submitting a support ticket for your issue as well. This might get the product team to look into it faster.

     

    @jasongre - has this support ticket made it to you (Support Request ID: 2402030030000238)? Has there been any progress on identifying the issue?

  • Jos_Vondar Profile Picture
    15 on 02 Apr 2024 at 12:52:37
    Re: Values for a column not shown in Views - Model-driven App

    Hello,

     

    I have the exact same issue with a user, with the Power apps grid control. The field is not being populated by a JS function though. It only affects them, I have tried replicating the issue with several test users but I haven't been lucky. There are two other people in his team, with the same security groups and the same roles but they aren't affected. I'm guessing it has something to do with this control but I can't be sure. If you find a solution please let me know.

  • Mattb-Motive Profile Picture
    180 on 17 Feb 2024 at 02:23:39
    Re: Values for a column not shown in Views - Model-driven App

    Still working through it with Support. I'll post here when a solution is found (or Microsoft fix the control).

     

    Other users have also confirmed this happening.

  • Neeraj523 Profile Picture
    78 on 16 Feb 2024 at 06:10:57
    Re: Values for a column not shown in Views - Model-driven App

    @MattB_Motive have you heard anything from support team about the issue ?

  • Mattb-Motive Profile Picture
    180 on 09 Feb 2024 at 13:05:09
    Re: Values for a column not shown in Views - Model-driven App

    After a lot of testing we were able to narrow down the issue. It appears that the duration column is intermittently showing blank values when using the 'Power Apps Grid Control' (including the default view of the new modern look).

     

    The values are displayed properly when switching to the 'Read Only Grid' or the 'Power Apps Read-Only Grid'.

     

    Alternatively, refreshing the browser will make the values display properly in the 'Power Apps Grid Control' but this is only temporary and the issue will appear again in a few days. Since the duration column values are displaying properly with two of the controls, it seems like the issue is with the Power Apps Grid Control rather than with the duration column or views.

     

    We were also able to recreate the issue in a separate developer tenant - once again the values displayed correctly when using the 'Read Only Grid'/'Power Apps Read-Only Grid' but were blank with the 'Power Apps Grid Control'.

     

    @jasongre - we have created a support ticket for this issue (Support Request ID: 2402030030000238). Are you able to assist?

     

    Power Apps Grid Control.pngRead Only Grid.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • Mattb-Motive Profile Picture
    180 on 20 Jan 2024 at 13:28:13
    Re: Values for a column not shown in Views - Model-driven App

    Good suggestion. We initially thought it may have been a JS issue (or something to do with the column configuration) until we found the issue with the mismatched FetchXML and LayoutXML - which was resolved when the user removed and readded the duration column in the view.

     

    The values do exist in the records - they are visible in both the Excel export as well as the backend Table view. You can't create a record without the duration being populated. They also appear once the user refreshes the app.

     

    There was a business requirement to have the duration calculated and visible to users when creating a record, hence the use of JS. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,503 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,333 Most Valuable Professional

Leaderboard

Featured topics

Loading started