cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Super User
Super User

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

20 REPLIES 20
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.

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.

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.

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.

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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,438)