Entity List Search Functionality

[aluzaja178]

Hi Experts,

I have a blank portal configured and in this portal, i have an entity list and the search for that entity list is enabled. When i search in that entity list using the "Search" textbox, its only considering the first column only. How can i add other columns as well in search criteria. Thanks

Note: I am not asking about the Global Search but the search that is enabled for entity list only.

[OliverRodrigues]

the search from the Portal works client-side, and searches only by columns displayed on the view

you can add Metadata Filters to search on additional fields, but this would be represented as different fields to be search by: https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/entity-lists#entity-list-filter-c...

another option you can do is adding the field you want to make the search to the view, and hide it via JS

the below JS can be placed in your Entity List custom JavaScript section, the number 4 below represents the index of the column, so just change that to the index of the column you want to hide and search

$(document).ready(function () {

    var list = $(".entitylist.entity-grid").eq(0);

    list.on("loaded", function () {
        // hide column by index
        list.find("table thead th").eq(4).hide();
        list.find("table tbody tr").each(function () { $(this).find("td").eq(4).hide(); });
    });
});

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[aluzaja178]

Thanks Oliver for your help. I have already added that field which i want to search. But that field is of type "Option Set". and when i search this column value from "Search Textbox", the results are not coming. when i search any other column of type "String", the results are coming.

[OliverRodrigues]

I am thinking that it might actually be a bug then

I created an option set on my trial and tried to search, but I am getting zero results, same results as you are

but I tried on an ADX On-Premise that I have and it works fine, so it could be a bug

[aluzaja178]

I am also thinking so. Because its the default behavior of Subgrid to search any record that is rendered on browser. Thanks Oliver for your support and quick response.