Distinct list of months and years

(0) Share

Report

Posted on by JamesSnaps

187

Been racking my brains on this, but not come up with a solution yet.

I've got a collection of dates in a range and I'm trying to create a new collection from that, consisting of two columns - the distinct months and the years of those months.

e.g. my date range is from 2020-11-14 through to 2021-02-11 and I want the end result to be:

November	2020
December	2020
January	2021
February	2021

Getting the distinct months into a collection is easy enough, but it's adding the corresponding year that I'm stuck on. Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JamesSnaps :

I've made a test for your reference:

1\I assume there is a collection named DateRange

ClearCollect( DateRange, ForAll( Sequence(DateDiff(Date(2020,11,14),Date(2021,2,11),Days),0,1), {TheDate:DateAdd(Date(2020,11,14),Value,Days)} ) )

2\Add a date table control and set it's Items property to:

ForAll( Distinct( ForAll( DateRange, { TheValue: Text( TheDate, "[$-en]mmmm" ) & ";;" & Year(TheDate) } ), TheValue ), { TheMonth: First( Split( Result, ";;" ) ).Result, TheYear: Last( Split( Result, ";;" ) ).Result } )

Best Regards,

Bof

Was this reply helpful? Yes No
JamesSnaps 187 on at

Like (0)

Report
Copy link

Link copied!

This is really smart Bof, thanks for the assistance. I've learned some new tricks whilst looking through the solution too!

Was this reply helpful? Yes No