Unanswered

Entity List Search Functionality

(0) Share

Report

Posted on by 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.

All responses (4)

Answers (0)

aluzaja178 on at

Like (0)

Report

Re: Entity List Search Functionality

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.
oliver.rodrigues 9,342 Most Valuable Professional on at

Like (1)

Report

Re: Entity List Search Functionality

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 on at

Like (0)

Report

Re: Entity List Search Functionality

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.
oliver.rodrigues 9,342 Most Valuable Professional on at

Like (0)

Report
Re: Entity List Search Functionality

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-configuration
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.