Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 113

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:
  • 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
    FrankvdS 3 on at
    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
    Kmadden1 4 on at
    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
    Mattb-Motive 113 on at
    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
    Jos_Vondar 15 on at
    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
    Mattb-Motive 113 on at
    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
    Neeraj523 78 on at
    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
    Mattb-Motive 113 on at
    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
    Mattb-Motive 113 on at
    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. 

  • Neeraj523 Profile Picture
    Neeraj523 78 on at
    Re: Values for a column not shown in Views - Model-driven App

    I think i know where is the problem. As you mentioned that field is being populated through JavaScript expression, this means, by default field is empty when user views the record in a View. But when user opens the record in a form, field gets populated through JS expression. This makes field get a value next time when user view record in a View.

     

    In my opinion, instead using JavaScript to populate value into the field, you should use backend workflow or Power Automate flow.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics