Modern Table control filter issue.

[TheodoreShi]

I am developing an internal application for my client using the latest Modern table control. I have encountered a strange issue where the Modern table control displays incorrectly after the data is filtered. It seems that it is not being refreshed correctly, but the row numbers below are displaying correctly. Please see the screenshot below.

The Modern table control is set to a flexible height. And I did some invetigation and found that as long as I set a fixed height for the Modern table control, this problem will not exist. Therefore, I guess this might be a bug. Anyone has any workaround to help me solve this problem, I would be very grateful.

[v-jefferni]

Hi @TheodoreShi ,

I cannot reproduce this issue in authoring version 3.24041.31. Could you please try and change the version, see if there's any difference? Besides, how did you set the table control to be with flexible height? What's the formula in Height property?

Best regards,

[TheodoreShi]

Hey @v-jefferni ,

Thank you very much for your reply. Please refer to the following steps to reproduce this bug:

1. Create a new Canvas App.
2. Enabled Modern Controls and themes in App Settings.
3. First insert a vertical container, and set the following properties for the container:
    Width: Parent.Width
    Height: Parent.Height
    LayoutAlignItems: LayoutAlignItems.Stretch

    X: 0

    Y: 0

4. Insert a Modern Textinput control and a Modern Table control into the Vertical container.

5. Bind a Dataverse table to the Modern table control, and then set Flexible height property to On. If configured correctly, it should look like the screenshot below:

    

6. In my environment, I am binding a table named Account. You may bind other tables, and then click the Modern table control to modify its Items property to the following expression:

    Items: Filter(Accounts, StartsWith('Account Name', TextInputCanvas1.Value))

7. Click the Preview button to preview the app, and enter any characters in the Text Input control to filter the table. you will see this bug, the table control is not refreshed correctly.

   

8. Now that you could set the table's Flexible height property to Off, the table works as expected.

[v-jefferni]

Hi @TheodoreShi ,

As you can see, I still cannot reproduce the issue with exact same settings:

Authoring version is: 3.24041.31

Best regards,

[wbspjg]

Hi,

I also have this problem and I think the reason you cannot reproduce the problem is that you do not have enough records being returned by your filter.

I was working in 3.24041.31 and I have also tried 3.24044.13 with the same problem. It appears that when there are a larger number of records returned by the filter for me I spotted the problem with a filter containing 30 records. When you change the filter the previous results are visible.

[wbspjg]

I have done some more testing and it appears this is caused when more then 15 records are visible on the screen at the same time. So this only happens on large screens which can display lots of rows. 

Fixing the size of the height is a work around I am working with turning off flexible height and limiting the height to 717 using 

If(Parent.Height > 717, 717, Parent.Height)

[wbspjg]

Sadly I have found this workaround does not work. If you scroll to a record that is off the list ie so record 16 appears and number 1 scrolls off the top the problem still exists.

[Chip1]

I have the same issue and agree it is tied to number of records.  All filters worked fine until the record count increase at which time the problem described occurred for me as well.

Looks like a MS bug from my side after hours of testing before I found this post.

[wbspjg]

@v-jefferni How can this be escalated/reported as a bug? I have tested in the iOS app and the problem does not exist in this app. 

[apeawakening]

I faced same issue filtering on modern table control which has sharepoint datasource , row count show some value and table show all list items,
Workaround I had and it works perfectly.
Workaround : 
In filter function if you're using dropdown or combo box , OnChange property : Refresh(SharepointDataSource).
Still there will be issue with inputtext filter : Again change that inputtext to combobox