Unanswered

Teams Power App - Table Control - Filter Issue

(1) Share

Report

Posted on by gsr51

I've created a Teams (Power app / channel tab) that uses a SharePoint list for data. I'm using the modern Table control and created a simple filter on the Items property. The app works as expected in "play" mode, but when I publish it to the Teams channel it doesn't load the data initially.

Here's what it does in the Teams channel. (The items in the SP list don't load initially). But if I enter a user I start getting results and if a backspace to where there's nothing in my search, it displays all the records.

*** I am expecting it to display all the records upon the initial display (with nothing in the search filter) ***

Entering some text then deleting it shows all the records.

When I'm developing it in Power Apps it works as expected when I play the app. All records are shown before doing a filter.

Here's the Items filter I have.

Thanks for any help you can throw my way!

-Greg

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (2)

Report

Hi

To be honest I am surprised it works without a value

You should change your filter to get

Filter('New Hire Portal', IsBlank(TextInput.Text) Or StartsWith(XXX, YYY))

Change it and try that please. making sure to change the words TextInput to your control name and your StartsWith with the proper parameters.

Was this reply helpful? Yes No
gsr51 76 on at

Like (1)

Report

Thank you for that. Adding in the check for blank does the trick!

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

I am so glad your issue is resolved.

To give you a little hint in the future too

You may have a time when you have a drop down or a combo where you want them to select a value to assign to a "column" it would be close to what we have

Filter(Source,

( IsBlank(Combo.Selected Or 'MyColumn' = Combo.Selected)

);

Just a slight variation than what you need today, but who knows maybe tomorrow ;-)

Was this reply helpful? Yes No