cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Impactful Individual
Impactful Individual

FILTER GALLERY BY MONTH AND YEAR

I have a gallery that comes from the CDS (Common Data Service)...

 

And she has several fields with dates ...

 

In the gif below shows the standard field ...

 

ERRO.gif

 

What I need...

 

Filter the gallery to only show items that match the month "06/2019"

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Create a collection OnVisible:

ClearCollect(MyPedido, 'Pedido e faturamento')

 

Then filter:

Filter (MyPedido; "06/2019" in Text(mesfaturamento;"mm/yyyy"))

------------

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.

View solution in original post

19 REPLIES 19
eka24
Super User
Super User

Try this

Filter (Datasource, Text(DateColumn,"mm/yyyy") >="06/2019")

------------

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.

Gorilla_8
Impactful Individual
Impactful Individual

Hi @eka24 ,

 

He says he expects a value of type number...

 

 

So I tried this:

 

Filter(Colaborações; Text(Value(ThisItem.M1);"[$-pt-BR]mm/yyyy")>="08/2020")

 

Error again...

 

ERRO.gif

Please look at the formula I gave again. It didn't include Thisitem. Recheck and place the formula on the Items property of the Gallery. Your formula with Thisitem is not necessary

------------

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.

Gorilla_8
Impactful Individual
Impactful Individual

Same! 😞

Can you show the new formula that is giving you same result

------------

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.

Gorilla_8
Impactful Individual
Impactful Individual

Here...

 

ERRO.gif

Replace value with Text as I gave in the formula. Instead of value put Text.

------------

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.

Gorilla_8
Impactful Individual
Impactful Individual

Here...

 

ERRO.gif

Please use only equal to sign = 

That's remove > from the formula.

------------

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,798)