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

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.

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 Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (5,572)