Modern Table Bug - Does Not Clear Table when Switching Filter

(1) Share

Report

Posted on by jeffgeno

I have a modern table control connected to a filtered SharePoint list. When changing between a filter that returns data and one that doesn't, the message appears saying "We didn't find anything to show here," but the rows of the table are still filled with the info from the last filter that did return data. See the attached screenshot. It shows the right number of rows (zero), but it shows old data instead of no data.

Unfortunately, the table control does not support a Refresh option, so I can't clear the data manually between filters.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jeffgeno,

Can you please share how you are "switching between filters"? I guess it has something to to with the tablist control, but how are you then controlling what data is displayed? Are you using multiple table controls and show/hide them or do you have a single control with a more elaborate formula for its Items property?

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
jeffgeno 39 on at

Like (0)

Report
Copy link

Link copied!

I have a dropdown that's not shown in the screenshot because it has real people's names in it. You select from the person from the dropdown and the table filters to the data that's applicable to that person. The table's Items property has this...

Filter('SP List Name',Status.Value = "Entered" || Status.Value = "Ready to Bill" || Status.Value = "Needs Correcting",ParticipantID = DropdownName.Selected.ID)

Switching between items in the Dropdown changes the ID that I'm filtering against. If I choose one that has no data returned from SP List Name, then it retains the data listed, but shows the icon over the top that says none can be found.

Was this reply helpful? Yes No
Suggested answer

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi!

I tried replicating the issue, but unfortunately I couldn't.

Given that the modern Table control is still in Preview, these things can be expected to happen. However, what may help is to switch authoring versions. The version I was running when testing was 3.25053.6.

Here you can find how to change authoring versions: Change authoring version for Power Apps Studio - Power Apps | Microsoft Learn

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No