FILTER GALLERY BY MONTH AND YEAR

(1) Share

Report

Posted on by Gorilla_8

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

What I need...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
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...

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Same! 😞

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Here...

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Here...

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Delegation warning!

Was this reply helpful? Yes No