Filter modern data table with text input, drop down & combo box control

(1) Share

Report

Posted on by bob_taylor_pp

203

Hi community

I would like to filter a modern data table with a text input, drop down and combo box control. Unfortunately it does not work. What is wrong with the syntax?

Filter(

Demo_Vertragsmanagement;

(IsBlank(TextInputCanvas1.Value) || TextInputCanvas1.Value in Titel) &&

(IsBlank(DropdownCanvas2.Selected.Value) || Status = DropdownCanvas2.Selected.Value) &&

(IsBlank(ComboboxCanvas1.Selected.Result) || Company = ComboboxCanvas1.Selected.Result) &&

(IsBlank(DropdownCanvas1.Selected.Value) || VertragArt = DropdownCanvas1.Selected.Value)

)

I am grateful for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey @bob_taylor_pp

as of now many wont suggest using modern controls, as many of them are still in preview and can be buggy at many places. have u tried the same with classic controls?

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (1)

Report

The same problem...maybe it's because of the other modern controls I'm using. So text input, dropdown...

Filter(
Demo_Vertragsmanagement;
(IsBlank(TextInputCanvas1.Value) || TextInputCanvas1.Value in Titel) &&
(IsBlank(DropdownCanvas2.Selected.Value) || Status = DropdownCanvas2.Selected.Value) &&
(IsBlank(ComboboxCanvas1.Selected.Value) || Company = ComboboxCanvas1.Selected.Value) &&
(IsBlank(DropdownCanvas1.Selected.Value) || VertragArt = DropdownCanvas1.Selected.Value)
)

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

from the screenshot you are showing it looks like its not an issue with the code. looks more like a delegation warning, what does the yellow triangle say when u hover over it?

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (1)

Report

@mmbr1606

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

As said this in a delegation warnung for lists over 2000 items. How large is your list ?

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (1)

Report

@mmbr1606

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (1)

Report

So it can't be the number of items. What else could be checked?

@mmbr1606

Was this reply helpful? Yes No
Verified answer

bob_taylor_pp 203 on at

Like (1)

Report

I solved it myself. Used the old dropdown and text input controls.

Was this reply helpful? Yes No