Search on multiple columns in Data Table connected to Data Service

Help Apps
, , , ,
1

I have a Data Table that is connected via Data Service.

image
image1902Ă—358 15.3 KB

I also created a search function. However, I only manage to apply this search function to 1 column. In this example, I am searching on First Name.

image

The properties of the Dropdown search field are:

image
image243Ă—771 26.6 KB

The properties of the Search Button are:

image

The properties of the Data Table are:

image
image219Ă—824 22.5 KB

I would like a search function, which can search on multiple columns. For example, on First Name and Profession.

I have already tried this with 2 search fields and OR function in the Data source of the Data Table. But this does not work.

Does anyone know how I can create a search function on multiple columns?

2

@Steyn_Muller1 ,

you can do more than one filter and this return only AND Result. Apps do not more advanced filter enable so far like OR, or and combination etc.

image
image1067Ă—233 9.96 KB

3

Okay, but AND doesn’t work if I only enter 1 search term, right?

4

@Steyn_Muller1 ,

AND will work,

Thanks,
AK

5

At the moment I’ve this.

For the search field:

image
image218Ă—753 22 KB

For the search button:

image

For the Data Table:

image
image216Ă—818 24.8 KB

That’s the formula for Data Source.

Filter(Dummy Variables, [Dummy Variables.First Name,“startswith”,var_Main_Input_LookupKey], [Dummy Variables.Profession,“startswith”,var_Main_Input_LookupKey])

When I start the process, it looks like this:

image
image1915Ă—373 29.6 KB

When I search for Henk for example, the Table becomes empty.

image
image1903Ă—339 12.8 KB

What do I do wrong?

The goal is that I can search on First Name and Profession.

So for example 1 time I search on First Name. The other time on Profession. Not at the same time.

6

Filter Table Solution.docx (239.3 KB)
Hi @Steyn_Muller1

Developed a solution for you , that only works when you select the first name and profession dropdown menu and it will display the result in the table. Currently AND, OR , StartWith function outputs the boolean value and we cannot use in table. Hope it helps you.

Regards
Naman Jain

1 Like
7

@Steyn_Muller1 - If this solution helps you, please mark it as a solution

8

It was not the solution where I was looking for. Thanks for helping!