Strange error with gallery not showing items [PowerApps & Dataverse]

[GJE]

Hello everyone,

I have a rather large/complex app that I've been making minor changes to in order to optimize it, so far so good. It's been no more than a month since no matter how small the change I try to make and publish, the main gallery simply stops showing items, only when I enter a search and delete it does it seem to understand and start working.

Now, the gallery filter is a bit complex and I think this may be what affects its operation, I'm sharing it here in case someone can help me:

Sort(
    Search(
    Filter(
            'Solicitudes Ofertas'
        ;
        (DesgloseFilter.Value in Desglose || CountRows(ComBoxFiltroDesglose.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroDesglose.SelectedItems.Result) = Blank());
        (Cliente in ComBoxFiltroCliente.SelectedItems.Result || CountRows(ComBoxFiltroCliente.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroCliente.SelectedItems.Result) = Blank());
        ('Tipo Solicitud' in ComBoxFiltroTipoSol.SelectedItems.Result || CountRows(ComBoxFiltroTipoSol.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroTipoSol.SelectedItems.Result) = Blank());
        ('Tipo Oferta' in ComBoxFiltroTipoOferta.SelectedItems.Result || CountRows(ComBoxFiltroTipoOferta.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroTipoOferta.SelectedItems.Result) = Blank());
        ('Estado Oferta' in ComBoxFiltroEstadoOferta.SelectedItems.Value || CountRows(ComBoxFiltroEstadoOferta.SelectedItems.Value) = 0 || CountRows(ComBoxFiltroEstadoOferta.SelectedItems.Value) = Blank());
        ('Comercial Asignado Nombre' in ComBoxFiltroComercial.SelectedItems.Result || CountRows(ComBoxFiltroComercial.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroComercial.SelectedItems.Result) = Blank());
        ('Modelo / Proyecto' in ComBoxFiltroProyecto.SelectedItems.Result || CountRows(ComBoxFiltroProyecto.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroProyecto.SelectedItems.Result) = Blank());
        ('Plano/Referencia' in ComBoxFiltroReferencia.SelectedItems.Result || CountRows(ComBoxFiltroReferencia.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroReferencia.SelectedItems.Result) = Blank());
        (Presentación in colFamilia.descripcion || CountRows(ComBoxFiltroFamilia.SelectedItems.Result) = 0 || CountRows(ComBoxFiltroFamilia.SelectedItems.Result) = Blank())
    );
    DesgloseFilter.Value; Desglose);

    'Fecha de modificación'; SortOrder.Descending
)

The last thing I noticed is that if I type something into one of the filters, the gallery starts working out of nowhere.

[WarrenBelz]

Hi @GJE ,

Try this test instead

Sort(
   Search(
      Filter(
         'Solicitudes Ofertas';
         (
            DesgloseFilter.Value in Desglose || 
            Len(ComBoxFiltroDesglose.Selected.Result) = 0
         );
         (
            Cliente in ComBoxFiltroCliente.SelectedItems.Result || 
            Len(ComBoxFiltroCliente.Selected.Result) = 0
         );
         (
            'Tipo Solicitud' in ComBoxFiltroTipoSol.SelectedItems.Result || 
            Len(ComBoxFiltroTipoSol.Selected.Result) = 0
         );
         (
            'Tipo Oferta' in ComBoxFiltroTipoOferta.SelectedItems.Result || 
            Len(ComBoxFiltroTipoOferta.Selected.Result) = 0
         );
         (
            'Estado Oferta' in ComBoxFiltroEstadoOferta.SelectedItems.Value || 
            Len(ComBoxFiltroEstadoOferta.Selected.Value) = 0
         );
         (
            'Comercial Asignado Nombre' in ComBoxFiltroComercial.SelectedItems.Result || 
            Len(ComBoxFiltroComercial.Selected.Result) = 0
         );
         (
            'Modelo / Proyecto' in ComBoxFiltroProyecto.SelectedItems.Result || 
            Len(ComBoxFiltroProyecto.Selected.Result) = 0
         );
         (
            'Plano/Referencia' in ComBoxFiltroReferencia.SelectedItems.Result || 
            Len(ComBoxFiltroReferencia.Selected.Result) = 0
         );
         (
            Presentación in colFamilia.descripcion || 
            Len(ComBoxFiltroFamilia.Selected.Result) = 0
         )
      );
      DesgloseFilter.Value; 
      Desglose
   );
   'Fecha de modificación'; S
   ortOrder.Descending
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[GJE]

Hi @WarrenBelz !

Thank you first of all for your time and response.

Although the code you sent me for the gallery works fine, the same pattern is repeated, I publish the new version and the gallery appears empty until I start searching by one of the filters.

[WarrenBelz]

Hi @GJE ,

I think it may be the top item - should it not be

(
   Desglose in ComBoxFiltroDesglose.SelectedItems.Result ||
   Len(ComBoxFiltroDesglose.Selected.Result) = 0
);

[GJE]

I have not had any luck performing different tests and removing that first line that you mention, the strange thing is that in the test environment that is identical, this does not happen, the only difference is in the amount of data that the environments handle from the dataverse tables.

[WarrenBelz]

Hi @GJE ,

If it works in Test, that is going to be very hard to debug.

[GJE]

Hi @WarrenBelz 

Would it be better to deploy from development to production? That way I could rule out a code issue.

[WarrenBelz]

Hi @GJE ,

As you would know, the only real way of debugging an error is to reproduce it and then work on things that fix it. I would be applying all of those filters one at a time (keep adding them) until it breaks and then you should be able to see the offending item.

[GJE]

Hi @WarrenBelz 

Sorry for the delay but I was OOO.

I have done multiple tests with different filters and the same thing always happens, the gallery stops showing elements unless I use one of the text filters (specifically the "Desglose" filter).

Given this situation, I decided to rename only one label whose text is entered manually, that is, it does not come from a table and even then the gallery breaks. I can only think that the problem is not the gallery filter.

What can I do in a situation like this? I really have no idea where to look at this point.

CC @Pstork1  @KeithAtherton 

[GJE]

CC @tahoon I mention you here because I saw a similar case to this one where you were giving support. 😀