Answered

Filter different conditions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I´m working in a double filter app, the first one has to filtrate a number from a column on excel and the second one a date also from excel, but this second one throws me an error which is the next:

La operación solicitada no es válida.
Respuesta del servidor: Error de Tabla1: La cláusula de filtro no es válida: no se admite la operación. Actualmente, solo se admiten los valores únicos "eq", "ne", "contains", "startswith" o "endswith" .
clientRequestId: 60ade09f-2be4-4647-9997-3aa2de038c29.

Thats a pic of how im doing my app, thanks for helping...

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @Anonymous please check if there is any data in your date column, if not add a column to your excel table =TEXT([@YourDateColumn],"dd/mm/yyyy") and make sure the column is a text and not date column.

do the filter using your new colum remember its text now so something like Filter(table1,YourNewColumn = Text(datetimepicker.selecteddate,"dd/mm/yyyy"))

hope this helps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Almost!
Theres still a problem in the filter, but at least I created a new column in text format and now I can call my date as a text, but cant convert it into date again to match with my datepicker2.selecteddate
Any idea? Pls
😞
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @Anonymous i opted to have the datepicker's value formatted to text Filter(table1,YourNewColumn = Text(datetimepicker.selecteddate,"dd/mm/yyyy")) to allow for that text comparison. you can also do Filter(table1,DateValue(YourNewColumn,"en-US") = datetimepicker.selecteddate) where your language codes are the same.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the delay... I opted to left that idea because of that comparision, but I had to use it again, so I saw again your comment and yeah... It was just what I need! Thank you!