Unanswered

Modern Table control filter issue.

(6) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (1)

All responses (18)

Answers (0)

v-jefferni on at

Like (2)

Report

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,

Was this reply helpful? Yes No
TheodoreShi 15 on at

Like (3)

Report

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.

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @TheodoreShi ,

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

Authoring version is: 3.24041.31

Best regards,

Was this reply helpful? Yes No
wbspjg 13 on at

Like (3)

Report

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.

Was this reply helpful? Yes No
wbspjg 13 on at

Like (3)

Report

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)

Was this reply helpful? Yes No
wbspjg 13 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Chip1 5 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
wbspjg 13 on at

Like (2)

Report

@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.

Was this reply helpful? Yes No
Ape Awakening 301 on at

Like (3)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Thomas-4711 4 on at

Like (3)

Report

Hello everyone,
the workaround doesn't work for me. I've tried it with TabList, DropDown and ComboBox. The Sharepoint list only has 46 entries. If I filter the first part and then scroll in the table, the table is not updated when the filter is changed, the old records remain visible. Only the counter is updated.
TabList/ComboBox/DropDown - OnChange:
Refresh(SharepointList)
Table Items:
Filter(SharepointList; Department = TabList_DepartmentSelected.Value)
Are there other options here? I don't want to switch to the old table or a gallery.
thank you very much
kind regards
Thomas

Was this reply helpful? Yes No