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.

All responses (8)

Answers (1)

Verified answer

bob_taylor_pp 203 on at

Like (1)

Report

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

I solved it myself. Used the old dropdown and text input controls.
bob_taylor_pp 203 on at

Like (1)

Report

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

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

@mmbr1606
bob_taylor_pp 203 on at

Like (1)

Report

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

@mmbr1606
mmbr1606 11,991 Super User 2025 Season 1 on at

Like (1)

Report

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

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

Like (1)

Report

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

@mmbr1606
mmbr1606 11,991 Super User 2025 Season 1 on at

Like (1)

Report

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

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?
bob_taylor_pp 203 on at

Like (1)

Report

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

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)
)
mmbr1606 11,991 Super User 2025 Season 1 on at

Like (1)

Report

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

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