Power Platform Community Forum Thread Details

Hello everyone,

I´ve been developing this Power Apps, where i have a gallery connected to my Excel file.

And i want to be able to filter this gallery selecting a date, the biggest issue is that if I have any rows in my Excel file between two occurrences of a date (01/01/2025), those rows appear completely blank in my Power Apps filter.

My filter formula is intended to capture all the distinct dates in my file.

Sort(
    Distinct(
        Contratos;
        IfError(
            'Mês de Reajuste';
            Blank();
            Text(DateAdd('Mês de Reajuste'; TimeZoneOffset(Now()); TimeUnit.Minutes); "dd/mm/yyyy")
        )
    );
    Value;
    SortOrder.Ascending
)

The filter within the gallery is set up this way. Like this:

IsBlank(ComboboxCanvas1_2.SelectedItems) Or IsEmpty(ComboboxCanvas1_2.SelectedItems) Or 
Text(DateAdd('Mês de Reajuste'; TimeZoneOffset(Now()); TimeUnit.Minutes); "dd/mm/yyyy") 
in ComboboxCanvas1_2.SelectedItems
;

And this is how i display this column inside the gallery
IfError(
    Text(DateAdd(ThisItem.'Mês de Reajuste'; TimeZoneOffset(Now()); TimeUnit.Minutes); "dd/mm/yyyy");
    Blank();
    Text(DateAdd(ThisItem.'Mês de Reajuste'; TimeZoneOffset(Now()); TimeUnit.Minutes); "dd/mm/yyyy"))
 
Just to be clear, since I live in Brazil, when I import dates from Excel into Power Apps, dates like (01/07/2024)
turn into (30/06/2024 21:00:00) due to the time zone difference. Therefore, I had to adjust the date
by adding the time zone offset to display it correctly.

Showing the problem, in Power Apps, when I filter by this date, you can see that there is a completely blank row between two occurrences of (01/01/2025). This is reflected in my gallery, and this is how the dates are arranged in my Excel file. Notice that there is a single blank row between the two rows with (01/01/2025), and this is being shown in the gallery. I want to filter the dates so that these blank rows do not appear. With the current approach, this issue occurs in several cases, and in my application, it's normal to have rows with empty dates; I just don't want them to appear this way when filtered by date.

01/01/2025

01/08/2024

01/03/2025

01/10/2024

01/12/2024

01/08/2024

01/04/2024

01/12/2024

01/04/2024

01/03/2025

01/06/2024

01/04/2024

01/09/2024

01/08/2024

01/12/2024

01/04/2024

01/06/2024

01/12/2024

01/01/2025

If anyone can help, I would be very grateful. If anything about my problem isn't clear, I would be happy to provide more details and clarify further.

Thanks in advance.

Categories:

Building Power Apps