Power Platform Community Forum Thread Details

Hello!

I have build an app that allow my costumer to input it's code and then show a list of all his Product Orders, with date, products, delivery date, etc.

I have used the filter function and a vertical gallery for this. The problem is: for some reason, the filter it's not showing all the records for some CostumerCodes, some of then are even not been showed.

I'm trying to understand why there is no problem with some codes, why the ProductOrders of other some are not been fully showed and why there is some codes that are not been showed at all.

The database is a excel table(called "Tabela1") hosted in Onedrive. In the prints above, "AgênciaCorrigida" is the name I gave to the column of my costumers code.

The formula I'm using is "Filter(Tabela1; AgênciaCorrigida=TextInput1.Text)"

I posted below some prints.

Code 0109: two lines in the database, the app show two records.

Code 0039: three lines in the database, the app show only one record.

Code 0395: three lines in the database, the app don't show any record.

I appreciate any kind of help!