cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
a10703ant
Helper I
Helper I

Datepicker only by months

Hi guys,

 

I hope you are doing well,

 

I have two date pickers range for filter my table of data .

 

a10703ant_0-1643119613807.png

 

Function: Today()

 

And have the filter 

 

Sum (
Filter('NAMEOFMYLISTS',
DATA >= datainicio.SelectedDate && DATA <= datafim.SelectedDate),
Value('NAME OF COLLUMN')

)

 

I create one dropdown with months but i can't filter the table....

How can i change this date picker or add one new with only months filter?

 

Thank you for all support !

2 ACCEPTED SOLUTIONS

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @a10703ant 

 

Let me know if this solves your requirement in terms of UI

StalinPonnusamy_1-1643150943987.png

Set the items property of Month Dropdown to

Sequence(12)

 

Set the Items property of Year dropdown to

Sequence(25,2020)

 

Let me know, I can help to filter the data if this UI works for you.


Thanks,
Stalin - Learn To Illuminate

View solution in original post

v-qiaqi-msft
Community Support
Community Support

Hi @a10703ant,

Do you want to filter the data based on month only and sum a column based on the filtered result?

Could you please tell me if the DATA column is a Date and time column in SP list?

 

If it is a Date and time column in your SP list, please keep your DatePicker and modify your formula as below:

Sum (
Filter('NAMEOFMYLISTS',
Month(DATA) >= Month(datainicio.SelectedDate) && Month(DATA) <= Month(datafim.SelectedDate)),
Value('NAME OF COLLUMN')

)

Use the Month() function to extract the month number from the date.

Best Regards,
Qi

View solution in original post

5 REPLIES 5
StalinPonnusamy
Super User
Super User

Hi @a10703ant 

 

I suggest having one dropdown and 2 date control that you have now.

 

StalinPonnusamy_0-1643123126041.png

 

Filter Data Based on Selection. I have blog post similar to this. Please refer and let me know if any questions.

 


Thanks,
Stalin - Learn To Illuminate

a10703ant
Helper I
Helper I

I need all months , january, february, march etc...

StalinPonnusamy
Super User
Super User

Hi @a10703ant 

 

Let me know if this solves your requirement in terms of UI

StalinPonnusamy_1-1643150943987.png

Set the items property of Month Dropdown to

Sequence(12)

 

Set the Items property of Year dropdown to

Sequence(25,2020)

 

Let me know, I can help to filter the data if this UI works for you.


Thanks,
Stalin - Learn To Illuminate

v-qiaqi-msft
Community Support
Community Support

Hi @a10703ant,

Do you want to filter the data based on month only and sum a column based on the filtered result?

Could you please tell me if the DATA column is a Date and time column in SP list?

 

If it is a Date and time column in your SP list, please keep your DatePicker and modify your formula as below:

Sum (
Filter('NAMEOFMYLISTS',
Month(DATA) >= Month(datainicio.SelectedDate) && Month(DATA) <= Month(datafim.SelectedDate)),
Value('NAME OF COLLUMN')

)

Use the Month() function to extract the month number from the date.

Best Regards,
Qi

Thank you for all help

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,673)